ITEMGROUP – Item Group

System
Inventory Control (IC)
Prefix
ITG
Primary key
ITEM-GROUP
Fields
15
Updated by
3 programs
Referenced by
328 programs

ITEMGROUP is the Item Group table in Lawson Inventory Control (prefix ITG). It is indexed by ITEM-GROUP (ITGSET1). It is related 1:M to ICCOMPANY, GLNLOC, HAZARD, ICVALUOM, MAJORCL and ITEMMAST. It is updated by IC00.1, IC00.2 and IC00.3 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 320 more. The table has 15 fields, 1 index and 8 documented relations.

About ITEMGROUP

The Item Group file stores the names of valid item groups. This file allows companies to share Item Master records or to keep them separate by company.

Fields (15)

Column = COBOL field name without the ITG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ITG-ITEM-GROUP PK
ITEM_GROUP		Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.IC00.1, IC00.2, IC00.3
#ITG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the description of the item group.IC00.1
#ITG-AUDIT-ITEM-FL
AUDIT_ITEM_FL		Alpha 1This field contains the option to audit all changes made to items in the Item Master file for an item group.
  • N No
  • Y Yes
IC00.1
#ITG-DEF-DEC-COST
DEF_DEC_COST		Numeric 1This field contains the default value for the number of decimal places in cost fields. 0 1 2 3 4 5IC00.1
#ITG-DEF-DEC-PRICE
DEF_DEC_PRICE		Numeric 1This field contains the default value for the number of decimal places in the price fields. 0 1 2 3 4 5IC00.1
#ITG-COM-TYPE
COM_TYPE		Alpha 1 Occurs 10 Times ×10This field contains valid item comment types for this item group.IC00.2
#ITG-COM-TYPE-DESC
COM_TYPE_DESC		Alpha 10 (Lower Case)Occurs 10 Times This field contains descriptions of comment types.IC00.2
#ITG-COM-OPT-IC210
COM_OPT_IC210		Alpha 1 Occurs 10 Times ×10These fields determine which comment types are printed on Item Master Listing (IC210).
  • X Print Comments
IC00.3
#ITG-COM-OPT-IC211
COM_OPT_IC211		Alpha 1 Occurs 10 Times ×10These fields determine which comment types are printed on Item Location Listing (IC211).
  • X Print Comments
IC00.3
#ITG-COM-OPT-IC110
COM_OPT_IC110		Alpha 1 Occurs 10 Times ×10These fields determine which comment types are printed on Intransit Shipping (IC110).
  • X Print Comments
IC00.3
#ITG-DEF-ITEM-CR-FL
DEF_ITEM_CR_FL		Alpha 1Default item create flag is needed for the creation of new item numbers when importing vendor catalogs in PO536 or manually entering price agreements in PO25. If no Item Create Flag is supplied during the creation of an agreement, this value will default. Valid values are, 1 to create the next sequential item number, 2 to assign the item number from another field, and 3 to manually input the new item number.
  • 1 Sequential
  • 2 Assign
  • 3 Manual Input
IC00.1
#ITG-DEF-ITEM-AS-FL
DEF_ITEM_AS_FL		Alpha 1If the item create flag is set to assign, this indicates the field from which the new item number is assigned. " " = None
  • 1 VENDOR-ITEM
  • 2 MFG-ITEM
  • 3 UPC
  • 4 SKU
  • 5 HIBCC-UPN
  • 6 UCCEAN-UPN
  • 7 NDC
—
#ITG-COMM-STRUCTURE
COMM_STRUCTURE		Alpha 20—IC00.1
#ITG-UOM-EDIT-FLAG
UOM_EDIT_FLAG		Numeric 1—
  • 0 Prevent UOM changes
  • 1 Allow UOM change
IC00.1
#ITG-AUTO-UPD-GLN
AUTO_UPD_GLN		Numeric 1Set this flag to 1 (Yes) to automatically create work units when a GLN is added, updated, or deleted.
  • 0 No
  • 1 Yes
IC00.1

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ITGSET1
  1. ITEM-GROUP
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICCOMPANYGLNLOCHAZARDICVALUOMMAJORCLITEMMASTITEMGROUP

One to many (8) — child tables

RelationTableRulesConditionField map
CompanyICCOMPANYDelete Restricted
ITG-ITEM-GROUP→ICC-ITEM-GROUP
—→ICC-COMPANY
GlnlocGLNLOC
ITG-ITEM-GROUP→GLO-ITEM-GROUP
—→GLO-GLN-NBR
HazardcodeHAZARDDelete Restricted
ITG-ITEM-GROUP→HAZ-ITEM-GROUP
—→HAZ-HAZARD-CODE
IcvaluomICVALUOM
ITG-ITEM-GROUP→ICV-ITEM-GROUP
—→ICV-VALID-UOM
Inv ClassMAJORCLDelete Restricted
ITG-ITEM-GROUP→MAJ-ITEM-GROUP
"I"→MAJ-CLASS-TYPE
—→MAJ-MAJOR-CLASS
ItemmasterITEMMASTDelete Restricted
ITG-ITEM-GROUP→ITE-ITEM-GROUP
—→ITE-ITEM
Purch ClassMAJORCLDelete Restricted
ITG-ITEM-GROUP→MAJ-ITEM-GROUP
"P"→MAJ-CLASS-TYPE
—→MAJ-MAJOR-CLASS
Sales ClassMAJORCLDelete Restricted
ITG-ITEM-GROUP→MAJ-ITEM-GROUP
"S"→MAJ-CLASS-TYPE
—→MAJ-MAJOR-CLASS

Programs

Updated by (3)

Referenced by (328)