AP
APTranPostBal
PX.Objects.AP37 of 37 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ID | int | - | ||
Description:No description available | ||||
AccountID | int | Account | Account | |
Description:No description available | ||||
Amt | decimal(19, 4) | - | ||
Description:No description available | ||||
ApplicationDate | datetime2 | Application Date | - | |
Description:No description available | ||||
BalanceAmt | decimal | - | ||
Description:No description available | ||||
BatchNbr | nvarchar(15) | Batch Number | Batch | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
CuryAmt | decimal(19, 4) | Amount | - | |
Description:No description available | ||||
CuryBalanceAmt | decimal | Balance | - | |
Description:No description available | ||||
CuryDiscAmt | decimal(19, 4) | Cash Discount Taken | - | |
Description:No description available | ||||
CuryDiscBalanceAmt | decimal | Cash Discount Balance | - | |
Description:No description available | ||||
CuryInfoID | bigint | CurrencyInfo | ||
Description:No description available | ||||
CuryPPDAmt | decimal(19, 4) | Cash Discount Taken | - | |
Description:No description available | ||||
CuryRetainageAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
CuryWhTaxAmt | decimal(19, 4) | With. Tax | - | |
Description:No description available | ||||
DiscAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
DiscBalanceAmt | decimal | - | ||
Description:No description available | ||||
DocDate | datetime2 | Date | - | |
Description:No description available | ||||
DocType | char(3) | Doc. Type | - | |
Description:No description available | ||||
FinPeriodID | char(6) | Application Period | - | |
Description:No description available | ||||
IsMigratedRecord | bit | - | ||
Description:No description available | ||||
LineNbr | int | Line Nbr. | - | |
Description:No description available | ||||
PPDAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
RefNbr | nvarchar(15) | Ref. Nbr. | APInvoice | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
RetainageAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
RGOLAmt | decimal(19, 4) | - | ||
Description:No description available | ||||
SourceDocType | char(3) | Source Doc. Type | - | |
Description:No description available | ||||
SourceRefNbr | nvarchar(15) | Source Ref. Nbr. | - | |
Description:No description available | ||||
SubID | int | Subaccount | Sub | |
Description:No description available | ||||
TranClass | char(4) | - | ||
Description:No description available | ||||
TranPeriodID | char(6) | - | ||
Description:No description available | ||||
TranRefNbr | nvarchar(15) | - | ||
Description:No description available | ||||
TranType | char(3) | - | ||
Description:No description available | ||||
Type | char(1) | - | ||
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||
WhTaxAmt | decimal(19, 4) | - | ||
Description:No description available | ||||