TABLE DETAIL REFERENCE: BillPaymentLine
(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 6TrueTrueTrueFalseCCCC-MM-DD
DocNumber12 VARCHAR 1000TrueFalseFalseFalse%s
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 1000TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
VendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
PayType12 VARCHAR 13TrueFalseTrueFalse
Check
CreditCard
CheckPaymentBankAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CheckPaymentBankAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CheckPaymentPrintStatus12 VARCHAR 13TrueTrueTrueFalse
NeedToPrint
NotSet
PrintComplete
CheckPaymentCheckDetailCheckNum12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailStatus12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailAcctNum12 VARCHAR 1000TrueTrueTrueFalse%s
CheckPaymentCheckDetailBankName12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditCardPaymentCCAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditCardPaymentCCDetailNumber12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailNameOnAcct12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCcExpiryMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailCcCcExpiryYear4 INTEGER 4TrueTrueTrueFalse%11.0f
CreditCardPaymentCCDetailBillAddrStreet12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPostalCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCommercialCardCode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnMode12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailCCTxnType12 VARCHAR 1000TrueTrueTrueFalse%s
CreditCardPaymentCCDetailPrevCCTransId12 VARCHAR 1000TrueTrueTrueFalse%s
TotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
BillPaymentLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
BillPaymentLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
BillPaymentAppliedToTxnTxnID12 VARCHAR 36TrueFalseTrueFalse%s
BillPaymentAppliedToTxnTxnType12 VARCHAR 1000TrueFalseTrueFalse%s
BillPaymentAppliedToTxnTxnLineID12 VARCHAR 36TrueFalseTrueFalse%s
BillPaymentAppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
BillPaymentAppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueTrueFalseFalseFQPrimaryKey