BillToPay Table
| 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 |