TABLE DETAIL REFERENCE: ReceivePaymentToDeposit
(Canada VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TxnLineID12 VARCHAR 21TrueFalseFalseFalse
TxnType12 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
CustomerRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerRefFullName12 VARCHAR 209TrueFalseFalseFalse%s Yes
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
RefNumber12 VARCHAR 20TrueFalseFalseFalse%s
Amount3 DECIMAL 18TrueFalseFalseFalse%10.2f
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey