TABLE DETAIL REFERENCE: StandardTerms
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueTrueTrueTrue%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
StdDueDays4 INTEGER 4TrueTrueTrueFalse%11.0f
StdDiscountDays4 INTEGER 4TrueTrueTrueFalse%11.0f
DiscountPct3 DECIMAL 15TrueTrueTrueFalse%11.7f