TABLE DETAIL REFERENCE: BillToPay
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
PayeeEntityRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
DueDateCutoff9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
BillToPayTxnID12 VARCHAR 36TrueFalseFalseFalse%s
BillToPayTxnType12 VARCHAR 14TrueFalseFalseFalse
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
BillToPayTxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
BillToPayAPAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
BillToPayAPAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
BillToPayTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
BillToPayRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
BillToPayDueDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
BillToPayAmountDue3 DECIMAL 15TrueFalseFalseFalse%10.2f
BillToPayCurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
BillToPayCurrencyRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
BillToPayExchangeRate3 DECIMAL 18TrueFalseFalseFalse%6.6f
BillToPayAmountDueInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
CreditToApplyTxnID12 VARCHAR 36TrueFalseFalseFalse%s
CreditToApplyTxnType12 VARCHAR 14TrueFalseFalseFalse
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
CreditToApplyTxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditToApplyAPAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CreditToApplyAPAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
CreditToApplyTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
CreditToApplyRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
CreditToApplyCreditRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey