TABLE DETAIL REFERENCE: ItemGroup
(Online 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 10TrueFalseFalseFalse%s
Name12 VARCHAR 100TrueFalseFalseFalse%s
FullName12 VARCHAR 1000TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Sku12 VARCHAR 100TrueFalseFalseFalse%s
Type12 VARCHAR 1000TrueFalseFalseFalse%s
ItemDesc12 VARCHAR 4000TrueFalseFalseFalse%s
IsTaxable-7 BIT 1TrueFalseFalseFalse
1
0
true
false
UnitPrice3 DECIMAL 18TrueFalseFalseFalse%10.7f
PurchaseCost3 DECIMAL 15TrueFalseFalseFalse%10.6f
IsPrintGroupedItems-7 BIT 1TrueFalseFalseFalse
1
0
true
false