TABLE DETAIL REFERENCE: Employee
(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
City12 VARCHAR 31TrueTrueTrueFalse%s
CommissionPercent3 DECIMAL 15TrueTrueTrueFalse%7.5f
Country12 VARCHAR 31TrueTrueTrueFalse%s
Email12 VARCHAR 99TrueTrueTrueFalse%s
FirstName12 VARCHAR 30TrueTrueTrueFalse%s
LastName12 VARCHAR 30TrueTrueTrueFalse%s
LoginName12 VARCHAR 20TrueTrueTrueTrue%s
Notes12 VARCHAR 245TrueTrueTrueFalse%s
Phone12 VARCHAR 40TrueTrueTrueFalse%s
Phone212 VARCHAR 40TrueTrueTrueFalse%s
Phone312 VARCHAR 40TrueTrueTrueFalse%s
Phone412 VARCHAR 40TrueTrueTrueFalse%s
PostalCode12 VARCHAR 13TrueTrueTrueFalse%s
State12 VARCHAR 21TrueTrueTrueFalse%s
Street12 VARCHAR 41TrueTrueTrueFalse%s
CustomFieldOther12 VARCHAR 30TrueFalseFalseFalse%s