ItemGroupLine 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
ID12VARCHAR75
ListID12VARCHAR36TrueFalseFalseFalse%s1.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ1.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s1.0US, CA, UK
Name12VARCHAR31TrueTrueTrueTrue%s1.0US, CA, UK
BarCode_Value12VARCHAR50TrueTrueTrueFalse%s12.0US, CA, UK
BarCode_AssignEvenIfUsed-7BIT2FalseTrueTrueFalse
1
0
true
false
1.0US, CA, UK
BarCode_AllowOverride-7BIT2FalseTrueTrueFalse
1
0
true
false
1.0US, CA, UK
IsActive-7BIT2TrueTrueTrueFalse
1
0
true
false
1.0US, CA, UK
ItemDesc12VARCHAR4095TrueTrueTrueFalse%s1.0US, CA, UK
UnitOfMeasureSetRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID7.0US, CA, UK
UnitOfMeasureSetRef_FullName12VARCHAR31TrueTrueTrueFalse%sName7.0US, CA, UK
ForceUOMChange-7BIT1TrueTrueFalseFalse
1
0
true
false
7.0US, CA, UK
IsPrintItemsInGroup-7BIT1TrueTrueTrueFalse
1
0
true
false
1.0US, CA, UK
ExternalGUID12VARCHAR40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}8.0US, CA, UK
ItemGroupLine_SeqNo4INTEGER9TrueFalseFalseFalseSeqNo1.0US, CA, UK
ItemGroupLine_ItemRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID1.0US, CA, UK
ItemGroupLineItemRef_FullName12VARCHAR159TrueTrueTrueFalse%sFullName1.0US, CA, UK
ItemGroupLine_Quantity4INTEGER9TrueTrueTrueFalse%10.5f1.0US, CA, UK
ItemGroupLine_UnitOfMeasure12VARCHAR31TrueTrueTrueFalse%sName7.0US, CA, UK
RQUseCachedID-7BIT
CFColor12VARCHAR255TrueTrueTrueFalse%s1.0US, CA, UK
CFMaterial12VARCHAR255TrueTrueTrueFalse%s1.0US, CA, UK

Back to list of tables.