ICGENERIC – Generic Name

System
Inventory Control (IC)
Prefix
ICG
Primary key
ITEM-GROUP, GENERIC
Fields
3
Updated by
1 program
Referenced by
14 programs

ICGENERIC is the Generic Name table in Lawson Inventory Control (prefix ICG). It is indexed by ITEM-GROUP, GENERIC (ICGSET1). It is related 1:1 to ITEMGROUP. It is updated by IC08.1 and referenced by IC10.1, IC10.2, IC11.1, IC208, IC330, IC811, PO150, PO25.6 and 6 more. The table has 3 fields, 1 index and 1 documented relation.

About ICGENERIC

The Generic Name file is a master file of generic names. When generic names are entered on Item Master, they are verified against this file.

Fields (3)

Column = COBOL field name without the ICG- 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
#ICG-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.IC08.1
#ICG-GENERIC PK
GENERIC		Alpha 10This field contains a user-defined general name for an item. This name is used for searching for an item.IC08.1
#ICG-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1This field prevents the use of a generic name.
  • A Active
  • I Inactive
IC08.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
ICGSET1
  1. ITEM-GROUP
  2. GENERIC
PrimaryIC08.1, IC10.1, IC10.2, IC11.1, IC208, IC330, IC811, PO150 +7 more

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemgroupITEMGROUPRequired
ICG-ITEM-GROUP→ITG-ITEM-GROUP

Programs

Updated by (1)

Referenced by (14)