TABLE DETAIL REFERENCE: BillPaymentCreditCardLine
(UK 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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
PayeeEntityRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueFalseTrueTrue%s Yes
APAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYeRX<eTT
CreditCardAccountRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
CreditCardAccountRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueFalseTrueTrue%s
Memo12 VARCHAR 4095TrueFalseTrueFalse%s
AppliedToTxnSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
AppliedToTxnTxnID12 VARCHAR 36TrueFalseTrueTrue%s
AppliedToTxnPaymentAmount3 DECIMAL 15TrueFalseTrueFalse%10.2f
AppliedToTxnTxnType12 VARCHAR 14TrueFalseFalseFalse
Bill
BillPaymentCheck
BillPaymentCreditCard
BuildAssembly
Charge
Check
CreditCardCharge
CreditCardCredit
CreditMemo
Deposit
Estimate
InventoryAdjustment
Invoice
ItemReceipt
JournalEntry
LiabilityAdjusoNKv  ۅT ۅT HۅTHۅT 
AppliedToTxnTxnDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
AppliedToTxnRefNumber12 VARCHAR 20TrueFalseFalseFalse%s
AppliedToTxnBalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
AppliedToTxnSetCreditCreditTxnID12 VARCHAR 36TrueFalseTrueFalse%s
AppliedToTxnSetCreditAppliedAmount3 DECIMAL 15TrueFalseTrueFalse%10.2f
AppliedToTxnDiscountAmount3 DECIMAL 15TrueFalseTrueFalse%10.2f
AppliedToTxnDiscountAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
AppliedToTxnDiscountAccountRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
AppliedToTxnDiscountClassRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
AppliedToTxnDiscountClassRefFullName12 VARCHAR 159TrueFalseTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey