|
|
ICITEMCODE FILE
REFERENCED BY
PD21.1
UPDATED BY
IC11.1 IC16.1 IC330 IC516 IC811 PO150
PO25.6 PO25.7 PO36.2 PO536
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IIC-ITEM-GROUP Alpha 5 IC11.1 IC16.1
Element: Item Group This field contains the identifier for IC330 IC516
a group of items that can be shared by IC811 PO150
one or more companies. PO25.6 PO25.7
PO36.2 PO536
IIC-ICSEGMENT Alpha 2 IC11.1 IC16.1
Element: Icsegment The ICSEGMENT is the first part of a IC330 IC516
four part item hierarchy structure. The IC811 PO150
ICSEGMENT is the top level of the PO25.6 PO25.7
hierarchy. All levels of the hierarchy PO36.2 PO536
are two characters. This hierarchy also
can be used to store UNSPSC codes and
descriptions.
IIC-ICFAMILY Alpha 2 IC11.1 IC16.1
Element: Icfamily ICFAMILY is the second level of the IC330 IC516
product hierarchy. If the ICFAMILY IC811 PO150
field has a 00 in it, this indicates PO25.6 PO25.7
that this code is for describing the PO36.2 PO536
segment. If there is a 00 the code
parts below this should also be 00.
IIC-ICCLASS Alpha 2 IC11.1 IC16.1
Element: Icclass ICCLASS is the third level of the IC330 IC516
hierarchy. If this is 00 and the code IC811 PO150
parts below this are 00, then this code PO25.6 PO25.7
is for describing the ICFAMILY field PO36.2 PO536
level.
IIC-ICCOMMODITY Alpha 2 IC11.1 IC16.1
Element: Iccommodity ICCOMMODITY is the fourth and last IC330 IC516
level of the hierarchy. All levels of IC811 PO150
the hierarchy must be entered for a PO25.6 PO25.7
item, it cannot split and only certain PO36.2 PO536
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.
IIC-DESC-LEVEL Numeric 1 IC11.1 IC16.1
Element: Desc Level The description level is an indicator IC330 IC516
for what level of the hierarchy is being IC811 PO150
described by the description. PO25.6 PO25.7
1 = ICSEGMENT Description PO36.2 PO536
2 = ICFAMILY Description
3 = ICCLASS Description
4 = ICCOMMODITY Description
IIC-ICCODE-SDESC Alpha 20 IC11.1 IC16.1
Element: Iccode Sdesc The sdesc is a shortened description. It IC330 IC516
based on the long description. It is IC811 PO150
needed for screens that cannot display PO25.6 PO25.7
the long description. PO36.2 PO536
IIC-ICCODE-LDESC Alpha 80 IC11.1 IC16.1
Element: Iccode Ldesc This is the correct description for the IC330 IC516
level of the hierarchy that is indicated IC811 PO150
by the description level field. This PO25.6 PO25.7
should be the full description. PO36.2 PO536
IIC-ICCODE-ACTIVE Alpha 1 IC11.1 IC16.1
Element: Iccode Active This code defines whether any item is IC330 IC516
currently using this code. As long as IC811 PO150
this code is on one item it is PO25.6 PO25.7
considered active. The exception to is PO36.2 PO536
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
ICITEMCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IICSET1 ITEM-GROUP IC11.1 IC16.1
ICSEGMENT IC330 IC516
ICFAMILY IC811 PD21.1
ICCLASS PO150 PO25.6
ICCOMMODITY PO25.7 PO36.2
PO536
IICSET2 ITEM-GROUP Subset
ICSEGMENT Where DESC-LEVEL = 1
And ICCODE-ACTIVE = "Y"
IICSET3 ITEM-GROUP Subset
ICSEGMENT Where DESC-LEVEL = 2
ICFAMILY And ICCODE-ACTIVE = "Y"
IICSET4 ITEM-GROUP Subset
ICSEGMENT Where DESC-LEVEL = 3
ICFAMILY And ICCODE-ACTIVE = "Y"
ICCLASS
IICSET5 ITEM-GROUP Subset
ICSEGMENT Where DESC-LEVEL = 4
ICFAMILY And ICCODE-ACTIVE = "Y"
ICCLASS
ICCOMMODITY
ICITEMCODE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Itemcodetoitem ITEMMAST
IIC-ITEM-GROUP -> ITE-ITEM-GROUP (ITESET10)
IIC-ICSEGMENT -> ITE-ICSEGMENT
IIC-ICFAMILY -> ITE-ICFAMILY
IIC-ICCLASS -> ITE-ICCLASS
IIC-ICCOMMODITY -> ITE-ICCOMMODITY
ITE-ITEM
|
