BillToPay Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ID 12 VARCHAR 75
BillToPay_TxnID 12 VARCHAR 36 True False False False %s 2.0 US, CA, UK
BillToPay_TxnType 12 VARCHAR 14 True False False False
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
ARRefundCreditCard
 2.0 US, CA, UK
BillToPay_APAccountRef_ListID 12 VARCHAR 36 True False False False %s ListID 2.0 US, CA, UK
BillToPay_APAccountRef_FullName 12 VARCHAR 159 True False False False %s FullName 2.0 US, CA, UK
BillToPay_TxnDate 91 DATE 6 True False False False CCCC-MM-DD 2.0 US, CA, UK
BillToPay_RefNumber 12 VARCHAR 20 True False False False %s 2.0 US, CA, UK
BillToPay_DueDate 91 DATE 10 True False False False CCCC-MM-DD 2.0 US, CA, UK
BillToPay_AmountDue 2 NUMERIC 15 True False False False %10.2f 2.0 US, CA, UK
BillToPay_CurrencyRef_ListID 12 VARCHAR 36 True False False False %s ListID 8.0 US, CA, UK
BillToPay_CurrencyRef_FullName 12 VARCHAR 64 True False False False %s Name 8.0 US, CA, UK
BillToPay_ExchangeRate 2 NUMERIC 18 True False False False %6.6f 8.0 US, CA, UK
BillToPay_AmountDueInHomeCurrency 2 NUMERIC 18 True False False False %10.2f 8.0 US, CA, UK
CreditToApply_TxnID 12 VARCHAR 36 True False False False %s 2.0 US, CA, UK
CreditToApply_TxnType 12 VARCHAR 14 True False False False
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjustment
Paycheck
PayrollLiabilityCheck
PurchaseOrder
ReceivePayment
SalesOrder
SalesReceipt
SalesTaxPaymentCheck
Transfer
VendorCredit
YTDAdjustment
ARRefundCreditCard
 2.0 US, CA, UK
CreditToApply_APAccountRef_ListID 12 VARCHAR 36 True False False False %s ListID 2.0 US, CA, UK
CreditToApply_APAccountRef_FullName 12 VARCHAR 159 True False False False %s FullName 2.0 US, CA, UK
CreditToApply_TxnDate 91 DATE 10 True False False False CCCC-MM-DD 2.0 US, CA, UK
CreditToApply_RefNumber 12 VARCHAR 20 True False False False %s 2.0 US, CA, UK
CreditToApply_CreditRemaining 2 NUMERIC 15 True False False False %10.2f 2.0 US, CA, UK
CreditToApply_CurrencyRef_ListID 12 VARCHAR 36 True False False False %s 8.0 US, CA, UK
CreditToApply_CurrencyRef_FullName 12 VARCHAR 64 True False False False %s 8.0 US, CA, UK
CreditToApply_ExchangeRate 2 NUMERIC 18 True False False False %6.6f 8.0 US, CA, UK
CreditToApply_CreditRemainingInHomeCurrency 2 NUMERIC 15 True False False False %10.2f 8.0 US, CA, UK