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.

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

IndexKeysFlagsConditionUsed in
GPCSET1ITEM-GROUP, SEGMENT, FAMILY, CLASS, BRICK, ATTRIBUTE-TYPE, ATTRIBUTE-VALPrimaryIC00.1

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemgroupITEMGROUPRequiredGPC-ITEM-GROUPITG-ITEM-GROUP

One to many (1) — child tables

RelationTableRulesConditionField map
IcitemgtinICITEMGTINGPC-ITEM-GROUPGTI-ITEM-GROUP, GPC-SEGMENTGTI-GPC-SEGMENT, GPC-FAMILYGTI-GPC-FAMILY, GPC-CLASSGTI-GPC-CLASS, GPC-BRICKGTI-GPC-BRICK, GTI-ITEM, GTI-GTIN

Programs

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