ReceivePaymentToDeposit 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 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