ReceivePaymentToDeposit 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 | True | False | False | False | %s | 2.0 | US, CA, UK | |
| TxnID | 12 | VARCHAR | 36 | True | False | False | False | %s | 2.0 | US, CA, UK | |
| TxnLineID | 12 | VARCHAR | 36 | True | False | False | False | %s | 2.0 | US, CA, UK | |
| 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 | |
| CustomerRef_ListID | 12 | VARCHAR | 36 | True | False | False | True | %s | ListID | 2.0 | US, CA, UK |
| CustomerRef_FullName | 12 | VARCHAR | 209 | True | False | False | True | %s | FullName | 2.0 | US, CA, UK |
| TxnDate | 91 | DATE | 10 | True | False | False | False | CCCC-MM-DD | 2.0 | US, CA, UK | |
| RefNumber | 12 | VARCHAR | 20 | True | False | False | False | %s | 2.0 | US, CA, UK | |
| Amount | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 2.0 | US, CA, UK | |
| CurrencyRef_ListID | 12 | VARCHAR | 36 | True | False | False | False | %s | 8.0 | US, CA, UK | |
| CurrencyRef_FullName | 12 | VARCHAR | 64 | True | False | False | False | %s | 8.0 | US, CA, UK | |
| ExchangeRate | 2 | NUMERIC | 18 | True | False | False | False | %6.6f | 8.0 | US, CA, UK | |
| AmountInHomeCurrency | 2 | NUMERIC | 15 | True | False | False | False | %10.2f | 8.0 | US, CA, UK |