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 / column | Type | Description & values | Updated by |
|---|---|---|---|
GPC-ITEM-GROUP PKITEM_GROUP | Alpha 5 | — | — |
GPC-SEGMENT PKSEGMENT | Alpha 2 | — | — |
GPC-FAMILY PKFAMILY | Alpha 2 | — | — |
GPC-CLASS PKCLASS | Alpha 2 | — | — |
GPC-BRICK PKBRICK | Alpha 8 | — | — |
GPC-ATTRIBUTE-TYPE PKATTRIBUTE_TYPE | Alpha 8 | — | — |
GPC-ATTRIBUTE-VAL PKATTRIBUTE_VAL | Alpha 8 | — | — |
GPC-DESCRIPTIONDESCRIPTION | 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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GPCSET1 | ITEM-GROUP, SEGMENT, FAMILY, CLASS, BRICK, ATTRIBUTE-TYPE, ATTRIBUTE-VAL | Primary | IC00.1 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Itemgroup | ITEMGROUP | Required | GPC-ITEM-GROUP → ITG-ITEM-GROUP |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Icitemgtin | ICITEMGTIN | 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.