TABLE DETAIL REFERENCE: VendorCredit
(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
VendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
VendorRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
APAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
APAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueFalseFalseFalse%s Yes
ExchangeRate3 DECIMAL 16TrueFalseFalseFalse%11.7f
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
CreditAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
CreditAmountInHomeCurrency3 DECIMAL 13TrueFalseFalseFalse%11.2f
RefNumber12 VARCHAR 21TrueFalseTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
OpenAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f