AP
APPaySelReport
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BaseCuryID | nvarchar(5) | Base Currency ID | - | |
Description:No description available | ||||
BranchID | int | Branch | - | |
Description:No description available | ||||
CashCuryID | nvarchar(5) | Cash Account Currency | - | |
Description:No description available | ||||
CuryDiscBal | decimal | - | ||
Description:No description available | ||||
CuryDocBal | decimal | - | ||
Description:No description available | ||||
CuryInfoID | bigint | Currency Info | - | |
Description:No description available | ||||
CuryOrigDocAmt | decimal | Amount | - | |
Description:No description available | ||||
CuryPayDiscBalNonexistent in DB | decimal? | Cash Discount Balance | - | |
Description:No description available | ||||
CuryPayDocBalNonexistent in DB | decimal? | Balance | - | |
Description:No description available | ||||
CuryPayOrigDocAmtNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
CuryRateType | nvarchar(6) | - | ||
Description:No description available | ||||
DiscBal | decimal | - | ||
Description:No description available | ||||
DiscDate | datetime | Cash Discount Date | - | |
Description:No description available | ||||
DocBal | decimal | - | ||
Description:No description available | ||||
DocCuryID | nvarchar(5) | Document Currency | - | |
Description:No description available | ||||
DocType | char(3) | Document Type | - | |
Description:No description available | ||||
DueDate | datetime | Due Date | - | |
Description:No description available | ||||
HasMultipleProjects | bit | - | ||
Description:A Boolean value that shows whether the AP document contains lines for different projects. | ||||
InvoiceNbr | nvarchar(40) | Vendor Ref. | - | |
Description:No description available | ||||
OrigCuryMultDiv | char(1) | - | ||
Description:No description available | ||||
OrigCuryRate | decimal | - | ||
Description:No description available | ||||
OrigDocAmt | decimal | - | ||
Description:No description available | ||||
PayAccountID | int | Cash Account | - | |
Description:No description available | ||||
PayDate | datetime | Pay Date | - | |
Description:No description available | ||||
PayDiscBal | decimal | - | ||
Description:No description available | ||||
PayDocBal | decimal | - | ||
Description:No description available | ||||
PayNbr | nvarchar(15) | Payment Nbr. | - | |
Description:No description available | ||||
PayOrigDocAmt | decimal | - | ||
Description:No description available | ||||
PaySel | bit | Selected | - | |
Description:No description available | ||||
PayTypeID | nvarchar(10) | Payment Method | - | |
Description:No description available | ||||
PrintDocTypeNonexistent in DB | string | Type | - | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
RefNbr | nvarchar(15) | Reference Nbr. | - | |
Description:No description available | ||||
SeparateCheck | bit | Separate Check | - | |
Description:No description available | ||||
SignBalanceNonexistent in DB | decimal? | SignBalance | - | |
Description:No description available | ||||
SuppliedByVendorID | int | - | ||
Description:A reference to the Vendor. An integer identifier of the vendor that supplied the goods. | ||||
TermsID | nvarchar(10) | Terms | - | |
Description:No description available | ||||
VendorID | int | Vendor | BAccountR | |
Description:No description available | ||||