Terms Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ListID12VARCHAR36TrueFalseFalseFalse%sListID1.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s1.0US, CA, UK
Name12VARCHAR31TrueFalseTrueTrue%s1.0US, CA, UK
IsActive-7BIT2TrueFalseTrueFalse
1
0
true
false
1.0US, CA, UK
Type12VARCHAR321.0US, CA, UK
StdDueDays4INTEGER9TrueFalseTrueFalse%11.0f1.0US, CA, UK
StdDiscountDays4INTEGER9TrueFalseTrueFalse%11.0f1.0US, CA, UK
StdDiscountPct2NUMERIC18TrueFalseTrueFalse%10.5f1.0US, CA, UK
DayOfMonthDue4INTEGER9TrueFalseTrueTrue%11.0f1.0US, CA, UK
DueNextMonthDays4INTEGER9TrueFalseTrueFalse%11.0f1.0US, CA, UK
DiscountDayOfMonth4INTEGER9TrueFalseTrueFalse%11.0f1.0US, CA, UK
DiscountPct2NUMERIC18TrueFalseTrueFalse%10.5f1.0US, CA, UK