TABLE DETAIL REFERENCE: CustomerType
(USA 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
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueFalseTrueTrue%s
FullName12 VARCHAR 159TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseTrueFalse
1
0
true
false
ParentRefListID12 VARCHAR 36TrueFalseTrueFalse%s
ParentRefFullName12 VARCHAR 159TrueFalseTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f