TABLE DETAIL REFERENCE: Transfer
(USA 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 6TrueTrueTrueFalseCCCC-MM-DD
TransferFromAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TransferFromAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
FromAccountBalance3 DECIMAL 18TrueFalseFalseFalse%10.2f
TransferToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TransferToAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
ToAccountBalance3 DECIMAL 18TrueTrueFalseFalse%10.2f
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
Amount3 DECIMAL 18TrueTrueTrueFalse%10.2f
Memo12 VARCHAR 4095TrueTrueTrueFalse%s