TABLE DETAIL REFERENCE: Purchase
(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
RefNumber12 VARCHAR 21TrueTrueTrueFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
AccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
AccountRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
PaymentType12 VARCHAR 1000TrueTrueTrueFalse%s
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
EntityRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
EntityRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
Credit-7 BIT 1TrueTrueTrueFalse
1
0
true
false
TxnSource12 VARCHAR 100TrueFalseFalseFalse%s
RemitToAddrAddr112 VARCHAR 500TrueFalseTrueFalse%s
RemitToAddrAddr212 VARCHAR 500TrueFalseTrueFalse%s
RemitToAddrAddr312 VARCHAR 500TrueFalseTrueFalse%s
RemitToAddrAddr412 VARCHAR 500TrueFalseTrueFalse%s
RemitToAddrAddr512 VARCHAR 500TrueFalseTrueFalse%s
RemitToAddrCity12 VARCHAR 255TrueFalseTrueFalse%s
RemitToAddrPostalCode12 VARCHAR 30TrueFalseTrueFalse%s
TotalAmt3 DECIMAL 13TrueTrueTrueFalse%11.2f
PrintStatus12 VARCHAR 1000TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable