ICITEMCODE

REFERENCED BY
IC46.1 ICI9.1 PD21.1 POIJ.1


UPDATED BY
IC10.2 IC11.1 IC16.1 IC218 IC330 IC511
IC516 IC811 PO150 PO25.6 PO25.7 PO26.4
PO26.5 PO28.2 PO36.2 PO536 RQ260

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IIC-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.
IC10.2 IC11.1
IC16.1 IC330
IC516 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IIC-ICSEGMENT
Element: Icsegment
Alpha 2
The ICSEGMENT is the first part of a four part item hierarchy structure. The ICSEGMENT is the top level of the hierarchy. All levels of the hierarchy are two characters. This hierarchy also can be used to store UNSPSC codes and descriptions.
IC10.2 IC11.1
IC16.1 IC330
IC516 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IIC-ICFAMILY
Element: Icfamily
Alpha 2
ICFAMILY is the second level of the product hierarchy. If the ICFAMILY field has a 00 in it, this indicates that this code is for describing the segment. If there is a 00 the code parts below this should also be 00.
IC10.2 IC11.1
IC16.1 IC330
IC516 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IIC-ICCLASS
Element: Icclass
Alpha 2
ICCLASS is the third level of the hierarchy. If this is 00 and the code parts below this are 00, then this code is for describing the ICFAMILY field level.
IC10.2 IC11.1
IC16.1 IC330
IC516 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IIC-ICCOMMODITY
Element: Iccommodity
Alpha 2
ICCOMMODITY is the fourth and last level of the hierarchy. All levels of the hierarchy must be entered for a item, it cannot split and only certain levels used. The hierarchy will remain an optional field when entering items. When this field contains 00, the code is for describing the ICCLASS level of the hierarchy.
IC10.2 IC11.1
IC16.1 IC330
IC516 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IIC-DESC-LEVEL
Element: Desc Level
Numeric 1
The description level is an indicator for what level of the hierarchy is being described by the description.
1 = ICSEGMENT Description
2 = ICFAMILY Description
3 = ICCLASS Description
4 = ICCOMMODITY Description
IC10.2 IC11.1
IC16.1 IC330
IC516 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IIC-ICCODE-SDESC
Element: Iccode Sdesc
Alpha 20
The sdesc is a shortened description. It based on the long description. It is needed for screens that cannot display the long description.
IC10.2 IC11.1
IC16.1 IC330
IC516 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IIC-ICCODE-LDESC
Element: Iccode Ldesc
Alpha 250
This is the correct description for the level of the hierarchy that is indicated by the description level field. This should be the full description.
IC10.2 IC11.1
IC16.1 IC330
IC516 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536
IIC-ICCODE-ACTIVE
Element: Iccode Active
Alpha 1
This code defines whether any item is currently using this code. As long as this code is on one item it is considered active. The exception to is for codes that contain 00 which is used for describing levels of the codes.
Y = Code is used for an item
N = Code is not currently used
IC10.2 IC11.1
IC16.1 IC330
IC516 IC811
PO150 PO25.6
PO25.7 PO26.4
PO26.5 PO28.2
PO36.2 PO536


ICITEMCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IICSET1 ITEM-GROUP
ICSEGMENT
ICFAMILY
ICCLASS
ICCOMMODITY
IC10.1 IC10.2
IC11.1 IC11.7
IC16.1 IC218
IC330 IC46.1
IC511 IC516
IC811 ICI9.1
PD21.1 PO150
PO25.6 PO25.7
PO26.4 PO26.5
PO28.2 PO36.2
PO536 POIJ.1
RQ260
IICSET2 ITEM-GROUP
ICSEGMENT
Subset
WhereDESC-LEVEL =1
AndICCODE-ACTIVE ="Y"
IICSET3 ITEM-GROUP
ICSEGMENT
ICFAMILY
Subset
WhereDESC-LEVEL =2
AndICCODE-ACTIVE ="Y"
IICSET4 ITEM-GROUP
ICSEGMENT
ICFAMILY
ICCLASS
Subset
WhereDESC-LEVEL =3
AndICCODE-ACTIVE ="Y"
IICSET5 ITEM-GROUP
ICSEGMENT
ICFAMILY
ICCLASS
ICCOMMODITY
Subset
WhereDESC-LEVEL =4
AndICCODE-ACTIVE ="Y"


ICITEMCODE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Icitemgtin ICITEMGTIN
IIC-ITEM-GROUP->GTI-ITEM-GROUP (GTISET5)
IIC-ICSEGMENT->GTI-ICSEGMENT
IIC-ICFAMILY->GTI-ICFAMILY
IIC-ICCLASS->GTI-ICCLASS
IIC-ICCOMMODITY->GTI-ICCOMMODITY
  GTI-GTIN
  GTI-ITEM
Itemcodetoitem ITEMMAST
IIC-ITEM-GROUP->ITE-ITEM-GROUP
IIC-ICSEGMENT->ITE-ICSEGMENT
IIC-ICFAMILY->ITE-ICFAMILY
IIC-ICCLASS->ITE-ICCLASS
IIC-ICCOMMODITY->ITE-ICCOMMODITY
  ITE-ITEM


File created: Thu Jun 09 11:16:57 2016

Home
Contact Us



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