ICMFGCODE FILE
REFERENCED BY
PO00.1 AP125 AP126 AP131 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 IC20.1
IC20.2 IC21.1 IC21.2 IC22.1 IC22.2 IC24.1
IC24.2 IC25.1 IC28.1 IC500 MA180 MA41.2
MA41.7 MA43.1 MA43.2 MA43.3 MA43.9 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 PO100 PO101 PO122 PO131 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 POI3.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ35.1 RQIE.1 WH130
WH132 WH190 WH20.2 WH20.7 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 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 WO132 WO140
UPDATED BY
IC34.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MFC-ITEM-GROUP Alpha 5 IC34.1
Element: Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
MFC-MANUF-ID Numeric 4 IC34.1
Element: Manuf Id
MFC-MANUF-CODE Alpha 4 IC34.1
Element: Manufacturer'sThis field contains a user defined code
that indicates the manufacturer of an
item.
MFC-MANUF-DIVISION Alpha 4 IC34.1
Manufacturer's This is a user defined code that
Division indicates which division of a
manufacturer is tied to an item.
ICMFGCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MFCSET1 ITEM-GROUP IC34.1 PO00.1
MANUF-ID
MANUF-CODE
MANUF-DIVISION
MFCSET2 ITEM-GROUP AP125 AP126
MANUF-CODE AP131 AP20.1
MANUF-DIVISION AP20.2 AP20.3
MANUF-ID AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC34.1 IC500
MA180 MA41.2
...
ICMFGCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Icmanfcode ICMANFCODE Required
MFC-ITEM-GROUP -> IMC-ITEM-GROUP
MFC-MANUF-CODE -> IMC-MANUF-CODE
MFC-MANUF-DIVISION -> IMC-MANUF-DIVISION
Icmanuf ICMANUF Required
MFC-ITEM-GROUP -> ICM-ITEM-GROUP
MFC-MANUF-ID -> ICM-MANUF-ID
|
