ICITEMGPC – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
GPC
Primary key
ITEM-GROUP, SEGMENT, FAMILY, CLASS, BRICK, ATTRIBUTE-TYPE, ATTRIBUTE-VAL
Fields
8
Updated by
0 programs
Referenced by
0 programs

ICITEMGPC is a Lawson Inventory Control table (prefix GPC); no description in the lawson data dictionary. It is indexed by ITEM-GROUP, SEGMENT, FAMILY, CLASS, BRICK, ATTRIBUTE-TYPE, ATTRIBUTE-VAL (GPCSET1). It is related 1:1 to ITEMGROUP and 1:M to ICITEMGTIN. The table has 8 fields, 1 index and 2 documented relations.

About ICITEMGPC

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the GPC- 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
#GPC-ITEM-GROUP PK
ITEM_GROUP		Alpha 5——
#GPC-SEGMENT PK
SEGMENT		Alpha 2——
#GPC-FAMILY PK
FAMILY		Alpha 2——
#GPC-CLASS PK
CLASS		Alpha 2——
#GPC-BRICK PK
BRICK		Alpha 8——
#GPC-ATTRIBUTE-TYPE PK
ATTRIBUTE_TYPE		Alpha 8——
#GPC-ATTRIBUTE-VAL PK
ATTRIBUTE_VAL		Alpha 8——
#GPC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)——

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
GPCSET1
  1. ITEM-GROUP
  2. SEGMENT
  3. FAMILY
  4. CLASS
  5. BRICK
  6. ATTRIBUTE-TYPE
  7. ATTRIBUTE-VAL
PrimaryIC00.1

Relations

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

One to one (1) — lookups and parents

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

One to many (1) — child tables

RelationTableRulesConditionField map
IcitemgtinICITEMGTIN
GPC-ITEM-GROUP→GTI-ITEM-GROUP
GPC-SEGMENT→GTI-GPC-SEGMENT
GPC-FAMILY→GTI-GPC-FAMILY
GPC-CLASS→GTI-GPC-CLASS
GPC-BRICK→GTI-GPC-BRICK
—→GTI-ITEM
—→GTI-GTIN

Programs

No Lawson programs are documented as updating or referencing this table.