ICMFGCODE FILE
This table is used to associate manufacturer codes to a manufacturer.
REFERENCED BY
PO00.1 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 API1.1
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 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 PO100 PO101 PO122 PO131
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.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 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 POI3.1 POID.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MFC-ITEM-GROUP Alpha 5
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
Element: Manuf Id A unique idenitifier for a manufacturer
MFC-MANUF-CODE Alpha 4
Element: Manuf Code This field contains a user defined code
that indicates the manufacturer of an
item.
MFC-MANUF-DIVISION Alpha 4
Element: Manuf DivisionThis is a user defined code that
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 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 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
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
|
