TABLE DETAIL REFERENCE: Department
(POS VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
DefaultMarginPercent4 INTEGER 4TrueTrueTrueFalse%11.0f
DefaultMarkupPercent4 INTEGER 4TrueTrueTrueFalse%11.0f
DepartmentCode12 VARCHAR 3TrueTrueTrueTrue%s
DepartmentName12 VARCHAR 30TrueTrueTrueTrue%s
StoreExchangeStatus12 VARCHAR 12TrueFalseFalseFalse
Modified
Sent
Acknowledged
TaxCode12 VARCHAR 100TrueTrueTrueTrue%s