ICITEMCODE

Item Code

REFERENCED BY
IC218 IC46.1 IC511 ICI9.1 PD21.1 RQ260


UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC10.2 IC11.1 IC12.1 IC140 IC141 IC142
IC145 IC16.1 IC243 IC330 IC516 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC811 IC83.1 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.2 PO26.3 PO26.4 PO26.5 PO26.6 PO26.7
PO26.9 PO27.2 PO27.3 PO27.4 PO275 PO276
PO277 PO28.2 PO280 PO29.1 PO30.1 PO30.2
PO30.3 PO30.4 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 PO54.5 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 RQ01.1 RQ10.1 RQ10.2 RQ10.3
RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830

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.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC145 IC16.1
IC243 IC330
IC516 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC811
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
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.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC145 IC16.1
IC243 IC330
IC516 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC811
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
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.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC145 IC16.1
IC243 IC330
IC516 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC811
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
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.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC145 IC16.1
IC243 IC330
IC516 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC811
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
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.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC145 IC16.1
IC243 IC330
IC516 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC811
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
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
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC145 IC16.1
IC243 IC330
IC516 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC811
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
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.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC145 IC16.1
IC243 IC330
IC516 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC811
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
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.
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC145 IC16.1
IC243 IC330
IC516 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC811
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
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
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
IC10.2 IC11.1
IC12.1 IC140
IC141 IC142
IC145 IC16.1
IC243 IC330
IC516 IC64.1
IC64.2 IC64.3
IC64.4 IC64.5
IC64.6 IC64.7
IC64.8 IC64.9
IC66.1 IC811
IC83.1 MA180
MA278 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2


ICITEMCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
IICSET1 ITEM-GROUP
ICSEGMENT
ICFAMILY
ICCLASS
ICCOMMODITY
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
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 02:18:40 2016

Home
Contact Us



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