TABLE DETAIL REFERENCE: ReceivePaymentLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueFalseTrueTrue%s Yes
ARAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ARAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
TotalAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
TotalAmountInHomeCurrency3 DECIMAL 13TrueFalseFalseFalse%11.2f
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
UnusedPayment3 DECIMAL 13TrueFalseFalseFalse%11.2f
UnusedCredits3 DECIMAL 13TrueFalseFalseFalse%11.2f
AppliedToTxnTxnID12 VARCHAR 36TrueTrueTrueTrue%s
AppliedToTxnPaymentAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
AppliedToTxnTxnType12 VARCHAR 32TrueTrueTrueFalse
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
AppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnRefNumber12 VARCHAR 21TrueFalseFalseFalse%s
AppliedToTxnBalanceRemaining3 DECIMAL 13TrueFalseFalseFalse%11.2f
AppliedToTxnTotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
AppliedToTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
AppliedToTxnSetCreditCreditTxnID12 VARCHAR 36TrueFalseTrueFalse%s
AppliedToTxnSetCreditTxnLineID12 VARCHAR 36TrueFalseTrueFalse%s
AppliedToTxnSetCreditAppliedAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
AppliedToTxnDiscountAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
AppliedToTxnDiscountAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
AppliedToTxnDiscountAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
AppliedToTxnDiscountClassRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
AppliedToTxnDiscountClassRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey