TABLE DETAIL REFERENCE: CreditCardCredit
(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
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYeRX<eTT
Amount3 DECIMAL 15TrueFalseFalseFalse%10.2f
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
Tax1Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
Tax2Total3 DECIMAL 15TrueFalseFalseFalse%10.2f
ExchangeRate3 DECIMAL 15TrueTrueTrueFalse%6.6f
AmountIncludesVAT-7 BIT 1TrueFalseFalseFalse
1
0
true
false