TABLE DETAIL REFERENCE: Deposit
(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
TxnDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYeCC
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
DepositToAccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
DepositTotal3 DECIMAL 15TrueFalseFalseFalse%10.2f
CurrencyRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CurrencyRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
ExchangeRate3 DECIMAL 18TrueFalseFalseFalse%6.6f
DepositTotalInHomeCurrency3 DECIMAL 15TrueFalseFalseFalse%10.2f
CashBackInfoTxnLineID12 VARCHAR 36TrueFalseFalseFalse%s
CashBackInfoAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CashBackInfoAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
CashBackInfoMemo12 VARCHAR 4095TrueTrueTrueFalse%s
CashBackInfoAmount3 DECIMAL 15TrueFalseTrueFalse%10.2f