|
|
ICITEMCODE FILE
REFERENCED BY
IC330 IC46.1 PO150 PO25.6 PO25.7 PO36.2
PO536
UPDATED BY
IC10.2 IC11.1 IC16.1 IC516 IC811
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
IIC-ITEM-GROUP Alpha 5 IC10.2 IC11.1
Element: Item Group This field contains the identifier for IC16.1 IC516
a group of items that can be shared by IC811
one or more companies.
IIC-ICSEGMENT Alpha 2 IC10.2 IC11.1
Element: Icsegment The Icsegment is the first part of a IC16.1 IC516
four part item hierarchy structure. The IC811
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.
IIC-ICFAMILY Alpha 2 IC10.2 IC11.1
Element: Icfamily Icfamily is the second level of the IC16.1 IC516
product hierarchy. If the icfamily IC811
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.
IIC-ICCLASS Alpha 2 IC10.2 IC11.1
Element: Icclass Icclass is the third level of the IC16.1 IC516
hierarchy. If this is 00 and the code IC811
parts below this are 00, then this code
is for describing the icfamily field
level.
IIC-ICCOMMODITY Alpha 2 IC10.2 IC11.1
Element: Iccommodity Iccommodity is the fourth and last level IC16.1 IC516
of the hierarchy. All levels of the IC811
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
descibing the icclass level of the
hierarchy.
IIC-DESC-LEVEL Numeric 1 IC10.2 IC11.1
Element: Desc Level The desc-level is an indicator for what IC16.1 IC516
level of the hiearchy is being described IC811
by the description.
1 = ICSEGMENT Description
2 = ICFAMILY Description
3 = ICCLASS Description
4 = ICCOMMODITY Description
IIC-ICCODE-SDESC Alpha 20 IC10.2 IC11.1
Element: Iccode Sdesc The sdesc is a shortened description. It IC16.1 IC516
based on the long description. It is IC811
needed for screens that cannot display
the long description.
IIC-ICCODE-LDESC Alpha 80 IC10.2 IC11.1
Element: Iccode Ldesc This is the correct description for the IC16.1 IC516
level of the hiearchy that is indicated IC811
by the desc-level field. This should be
the full description.
IIC-ICCODE-ACTIVE Alpha 1 IC10.2 IC11.1
Element: Iccode Active This code defines whether any item is IC16.1 IC516
currently using this code. As long as IC811
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
ICITEMCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IICSET1 ITEM-GROUP IC10.1 IC10.2
ICSEGMENT IC11.1 IC16.1
ICFAMILY IC330 IC46.1
ICCLASS IC516 IC811
ICCOMMODITY PO150 PO25.6
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
|
