TABLE DETAIL REFERENCE: Transfer
(Online 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 10TrueFalseFalseFalse%s
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
TxnDate9 DATE 6TrueTrueFalseFalseCCCC-MM-DD
FromAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
FromAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ToAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
TxnSource12 VARCHAR 100TrueTrueTrueFalse%s
Amount3 DECIMAL 15TrueTrueTrueFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseTrueFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseTrueFalse%11.2f
Memo12 VARCHAR 100TrueTrueTrueFalse%s