ICMFGCODE FILE
This table is used to associate manufacturer codes to a manufacturer.
REFERENCED BY
PO00.1 AP125 AP126 AP131 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 BL120 BL122 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 IC20.1 IC20.2 IC21.1
IC21.2 IC22.1 IC22.2 IC24.1 IC24.2 IC25.1
IC28.1 IC500 MA180 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 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE111 OE113 OE114 OE116 OE129 OE13.2
OE13.3 OE13.5 OE13.6 OE14.4 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE530 OE81.1 OE810 OE830 OE90.1
OE90.2 PO100 PO101 PO122 PO131 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
POI3.1 POIE.1 POII.1 POIJ.1 RQ10.1 RQ10.2
RQ35.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 A unique idenitifier for a manufacturer
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 AP25.1
MANUF-DIVISION AP25.2 AP26.1
MANUF-ID AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
...
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
|
