TABLE DETAIL REFERENCE: Check
(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
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
AccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AccountRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PayeeEntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayeeEntityRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
Amount3 DECIMAL 15TrueTrueTrueFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
AddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
AddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
AddressCity12 VARCHAR 255TrueTrueTrueFalse%s
AddressState12 VARCHAR 255TrueTrueTrueFalse%s
AddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
AddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
AddressNote12 VARCHAR 500TrueTrueTrueFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
ExpenseLineBillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled