AP
APDocumentEnq.GLDocumentPeriodResult
PX.Objects.AP54 of 54 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
DocType | char(3) | Type | - | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | APDocumentResult | |
Description:No description available | ||||
AccountID | int | Account | - | |
Description:No description available | ||||
APAccountID | int | AP Account | - | |
Description:No description available | ||||
APSubID | int | AP Subaccount | - | |
Description:No description available | ||||
APTurnover | decimal | AP Turnover | - | |
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Nbr. | Batch | |
Description:No description available | ||||
BegBalance | decimal | Period Beg. Balance | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
ClosedDate | datetime2 | Closed Date | - | |
Description:No description available | ||||
ClosedFinPeriodID | char(6) | Closed Period | - | |
Description:No description available | ||||
ClosedTranPeriodID | char(6) | Closed Master Period | - | |
Description:No description available | ||||
CuryBegBalance | decimal | Currency Period Beg. Balance | - | |
Description:No description available | ||||
CuryDiscActTaken | decimal | Currency Cash Discount Taken | - | |
Description:No description available | ||||
CuryDocBal | decimal | Currency Balance | - | |
Description:No description available | ||||
CuryID | nvarchar(5) | Currency | Currency | |
Description:No description available | ||||
CuryInfoID | bigint | - | ||
Description:No description available | ||||
CuryOrigDocAmt | decimal | Currency Origin. Amount | - | |
Description:No description available | ||||
CuryOrigDocAmtWithRetainageTotal | decimal | Total Amount | - | |
Description:No description available | ||||
CuryRetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
CuryRetainageUnreleasedAmt | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
CuryTaxWheld | decimal | Currency Tax Withheld | - | |
Description:No description available | ||||
DiscActTaken | decimal | Cash Discount Taken | - | |
Description:No description available | ||||
DocBal | decimal | Balance | - | |
Description:No description available | ||||
DocDate | datetime2 | Date | - | |
Description:No description available | ||||
DocDesc | nvarchar(512) | Description | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(30) | Vendor Invoice Nbr./Payment Nbr. | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Post Period | - | |
Description:No description available | ||||
FinPostPeriodID | char(6) | - | ||
Description:No description available | ||||
GLTurnoverNonexistent in DB | decimal | GL Turnover | - | |
Description:No description available | ||||
Hold | bit | Hold | - | |
Description:No description available | ||||
InstallmentCntr | smallint | - | ||
Description:No description available | ||||
IsMigratedRecord | bit | - | ||
Description:No description available | ||||
IsRetainageDocument | bit | Retainage Bill | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OpenDoc | bit | Open | - | |
Description:No description available | ||||
OrigDocAmt | decimal | Origin. Amount | - | |
Description:No description available | ||||
OrigDocAmtWithRetainageTotal | decimal | Total Amount | - | |
Description:No description available | ||||
OrigDocType | char(3) | Orig. Doc. Type | - | |
Description:No description available | ||||
OrigRefNbr | nvarchar(15) | Orig. Ref. Nbr. | - | |
Description:No description available | ||||
PaymentMethodID | nvarchar(10) | Payment Method | - | |
Description:No description available | ||||
Prebooked | bit | Prebooked | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
RetainageTotal | decimal | Original Retainage | - | |
Description:No description available | ||||
RetainageUnreleasedAmt | decimal | Unreleased Retainage | - | |
Description:No description available | ||||
RGOLAmt | decimal | RGOL Amount | - | |
Description:No description available | ||||
Scheduled | bit | - | ||
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SubID | int | Subaccount | - | |
Description:No description available | ||||
TaxWheld | decimal | Tax Withheld | - | |
Description:No description available | ||||
TranPeriodID | char(6) | Master Period | - | |
Description:No description available | ||||
TranPostPeriodID | char(6) | - | ||
Description:No description available | ||||
VendorID | int | Vendor | - | |
Description:No description available | ||||
Voided | bit | Void | - | |
Description:No description available | ||||