TABLE DETAIL REFERENCE: ItemGroupLine
(USA 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 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueTrueTrueTrue%s
BarCodeValue12 VARCHAR 50TrueTrueTrueFalse%s
BarCodeAssignEvenIfUsed-7 BIT 1FalseTrueTrueFalse
1
0
true
false
BarCodeAllowOverride-7 BIT 1FalseTrueTrueFalse
1
0
true
false
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ItemDesc12 VARCHAR 4095TrueTrueTrueFalse%s
UnitOfMeasureSetRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
UnitOfMeasureSetRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ForceUOMChange-7 BIT 1TrueTrueFalseFalse
1
0
true
false
IsPrintItemsInGroup-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
SpecialItemType12 VARCHAR 24TrueFalseFalseFalse
FinanceCharge
ReimbursableExpenseGroup
ReimbursableExpenseSubtotal
Yes
ClearItemsInGroup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
ItemGroupLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ItemGroupLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemGroupLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ItemGroupLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ItemGroupLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueTrueTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey