TABLE DETAIL REFERENCE: BillPaymentCreditCard
(UK VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
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