ICMFGCODE

This table is used to associate manufacturer codes to a manufacturer.

REFERENCED BY
PO00.1


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 API1.1 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC140
IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2
IC24.1 IC24.2 IC25.1 IC34.1 IC500 IC66.1
IC83.1 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA42.2 MA43.2 MA43.7 MA44.1 MA44.2 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 PO100 PO101 PO122
PO131 PO136 PO150 PO190 PO20.1 PO20.6
PO20.9 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO28.2 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 RQ10.1 RQ10.2
RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQIF.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
ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MFC-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.
IC34.1
MFC-MANUF-ID
Element: Manuf Id		Numeric 4
A unique idenitifier for a manufacturer
IC34.1
MFC-MANUF-CODE
Element: Manuf Code		Alpha 4
This field contains a user defined code that indicates the manufacturer of an item.
IC34.1
MFC-MANUF-DIVISION
Element: Manuf Division		Alpha 4
This is a user defined code that indicates which division of a manufacturer is tied to an item.
IC34.1


ICMFGCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MFCSET1 ITEM-GROUP
MANUF-ID
MANUF-CODE
MANUF-DIVISION
IC34.1 PO00.1
MFCSET2 ITEM-GROUP
MANUF-CODE
MANUF-DIVISION
MANUF-ID
...
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 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140


ICMFGCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 11:17:03 2016

Home
Contact Us



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