TABLE DETAIL REFERENCE: BillToPay
(UK 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
LiabilityAdjusÃÝoNþKvÉÐþ ø ÄÛ…T ÄÛ…TÐþ øHÄÛ…THÄÛ…TžŸžŸÐþ ø
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
LiabilityAdjusÃÝoNþKvÉÐþ ø ÄÛ…T ÄÛ…TÐþ øHÄÛ…THÄÛ…TžŸžŸÐþ ø
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