Skip to main content
AP

APCashRequirementsReport

PX.Objects.AP
Field NameTypeDisplay NameForeign Key
DocType
char(3)-
Description:No description available
RefNbr
nvarchar(15)Reference Nbr.APRegister
Description:No description available
BaseCuryID
nvarchar(5)Currency
Description:No description available
BranchIDDefault Navigation
intBranch-
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
bigintCurrencyInfo
Description:No description available
CuryOrigDocAmt
decimal-
Description:No description available
CuryPayDiscBalNonexistent in DB
decimalCash Discount Balance-
Description:No description available
CuryPayDocBalNonexistent in DB
decimalBalance-
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
datetime2Cash Discount Date-
Description:No description available
DocBal
decimal-
Description:No description available
DocCuryID
nvarchar(5)Document Currency-
Description:No description available
DocDesc
nvarchar(60)-
Description:No description available
DueDate
datetime2Due Date-
Description:No description available
EstPayDate
datetime2Estimated Pay Date-
Description:No description available
InvoiceNbr
nvarchar(40)Vendor Ref.-
Description:No description available
InvoicePayTypeID
nvarchar(10)Payment Method-
Description:The payment method of the invoice.
OrigCuryMultDiv
char(1)-
Description:No description available
OrigCuryRate
decimal(19, 8)-
Description:No description available
OrigDocAmt
decimal-
Description:No description available
PayAccountIDDefault Navigation
intCash Account-
Description:No description available
PayDate
datetime2-
Description:No description available
PayDiscBal
decimal-
Description:No description available
PayDocBal
decimal-
Description:No description available
PayOrigDocAmt
decimal-
Description:No description available
PaySel
bitApproved for Payment-
Description:No description available
PayTypeID
nvarchar(10)Payment Method-
Description:No description available
PrintDocTypeNonexistent in DB
nchar(3)Type-
Description:No description available
SignBalanceNonexistent in DB
decimalSignBalance-
Description:No description available
TermsID
nvarchar(10)Terms
Description:No description available
VendorIDDefault Navigation
intVendor-
Description:No description available