ICITEMGPC

This table contains the Global Classification Category (GPC) codes which is an international standard for classifying items.

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GPC-ITEM-GROUP
Element: Item Group
Alpha 5
This field contains the identifier for a group of items that can be shared by one or more companies.
GPC-SEGMENT
Element: Gpc Segment
Alpha 2
GPC-FAMILY
Element: Gpc Family
Alpha 2
GPC-CLASS
Element: Gpc Class
Alpha 2
GPC-BRICK
Element: Gpc Brick
Alpha 8
GPC-ATTRIBUTE-TYPE
Element: Gpc Attrib Tp
Alpha 8
GPC-ATTRIBUTE-VAL
Element: Gpc Attrib Val
Alpha 8
GPC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This is a free-form description of the GPC.


ICITEMGPC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GPCSET1 ITEM-GROUP
SEGMENT
FAMILY
CLASS
BRICK
ATTRIBUTE-TYPE
ATTRIBUTE-VAL


ICITEMGPC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Itemgroup ITEMGROUP Required
GPC-ITEM-GROUP->ITG-ITEM-GROUP (ITGSET1)


ICITEMGPC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Wed Jun 08 20:49:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.