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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ICGSET1ITEM-GROUP, GENERICPrimaryIC08.1, IC10.1, IC10.2, IC11.1, IC208, IC330, IC811, PO150 +7 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemgroupITEMGROUPRequiredICG-ITEM-GROUP → ITG-ITEM-GROUP

Programs

Updated by (1)

Referenced by (14)