TABLE DETAIL REFERENCE: Terms
(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 31TrueFalseFalseTrue%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
DayOfMonthDue4 INTEGER 4TrueFalseFalseTrue%11.0f
DueNextMonthDays4 INTEGER 4TrueFalseFalseFalse%11.0f
DiscountDayOfMonth4 INTEGER 4TrueFalseFalseFalse%11.0f
DiscountPct3 DECIMAL 18TrueFalseFalseFalse%10.5f
StdDueDays4 INTEGER 4TrueFalseFalseFalse%11.0f
StdDiscountDays4 INTEGER 4TrueFalseFalseFalse%11.0f
StdDiscountPct3 DECIMAL 18TrueFalseFalseFalse%10.5f
Type12 VARCHAR 20TrueFalseFalseFalse%s