TABLE DETAIL REFERENCE: PaymentAppliedToTxn
(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
TxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
PrivateNote12 VARCHAR 4000TrueFalseFalseFalse%s
TxnStatus12 VARCHAR 1000TrueFalseFalseFalse%s
CustomerRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CustomerRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ARAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ARAccountRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
DepositToAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
PaymentMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
PaymentRefNum12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CreditCardPaymentCCAccountRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
CreditCardPaymentCCDetailNumber12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailType12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailNameOnAcct12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailCcExpiryMonth4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear4 INTEGER 4TrueFalseFalseFalse%11.0f
CreditCardPaymentCCDetailBillAddrStreet12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailPostalCode12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailCommercialCardCode12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailCCTxnMode12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailCCTxnType12 VARCHAR 1000TrueFalseFalseFalse%s
CreditCardPaymentCCDetailPrevCCTransId12 VARCHAR 1000TrueFalseFalseFalse%s
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
UnappliedAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyReffullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseFalseFalse%11.7f
PaymentAppliedToTxnTxnID12 VARCHAR 36TrueFalseFalseFalse%s
PaymentAppliedToTxnTxnType12 VARCHAR 1000TrueFalseFalseFalse%s
PaymentAppliedToTxnTxnLineID12 VARCHAR 36TrueFalseFalseFalse%s
PaymentAppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
PaymentAppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
PaymentAppliedToTxnBalanceRemaining3 DECIMAL 13TrueFalseFalseFalse%11.7f
PaymentAppliedToTxnAmount3 DECIMAL 15TrueFalseFalseFalse%11.7f
PaymentAppliedToTxnDiscountAmount3 DECIMAL 15TrueFalseFalseFalse%11.7f
TaxDetailDefaultTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxDetailDefaultTaxCodeRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
TaxDetailTxnTaxCodeRef12 VARCHAR 11TrueFalseFalseFalse%8.2f
TaxDetailTotalTax3 DECIMAL 13TrueFalseFalseFalse%10.7f
TaxDetailReviewStatus12 VARCHAR 11TrueFalseFalseFalse
Billable
NotBillable
HasBeenBill
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey