MFGSHPFAC FILE
This table is used to associate defined ship to facilities (ICFACILITY) with a
manufacturer for the purpose of generating the product transfer and resale
report.
REFERENCED BY
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 IC153 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 PO00.1 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 IC33.1
UPDATED BY
IC34.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MFG-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.
MFG-MANUF-ID Numeric 4 IC34.1
Element: Manuf Id A unique idenitifier for a manufacturer
MFG-ST-FACILITY Alpha 15 IC34.1
Element: St Facility A unique identifier for a ship to
facility.
MFG-NAME Alpha 30 (Lower Case) IC34.1
Element: Name Displays the company description.
MFG-MANUF-FAC-ID Alpha 15 IC34.1
Element: Manuf Fac Id Stores a manufacturer supplied ship to
facility id for use on the product
transfer and resale report EDI
transaction N1 segment.
MFG-ADDR1 Alpha 30 (Lower Case) IC34.1
Element: Address 1 This field contains the first line of
address information.
MFG-ADDR2 Alpha 30 (Lower Case) IC34.1
Element: Address 1 This field contains the second line of
address information.
MFG-ADDR3 Alpha 30 (Lower Case) IC34.1
Element: Address 1 This field contains the third line of
address information.
MFG-ADDR4 Alpha 30 (Lower Case) IC34.1
Element: Address 1 This field contains the fourth line of
address information.
MFG-CITY-ADDR5 Alpha 18 (Lower Case) IC34.1
Element: City The city or address line five.
MFG-STATE-PROV Alpha 2 IC34.1
Element: State or ProviThe state or province.
MFG-POSTAL-CODE Alpha 10 (Lower Case) IC34.1
Element: Postal Code This field contains the postal code.
MFG-COUNTRY-CODE Alpha 2 IC34.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
MFG-COUNTY Alpha 25 (Lower Case) IC34.1
Element: County The county for the company address.
MFGSHPFAC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MFGSET1 ITEM-GROUP AP125 AP126
MANUF-ID AP131 AP25.1
ST-FACILITY 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
IC153 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
...
MFGSET2 ITEM-GROUP IC33.1
ST-FACILITY
MANUF-ID
MFGSHPFAC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Icmanuf ICMANUF Required
MFG-ITEM-GROUP -> ICM-ITEM-GROUP
MFG-MANUF-ID -> ICM-MANUF-ID
MFGSHPFAC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Icfacility ICFACILITY
MFG-ITEM-GROUP -> FAC-ITEM-GROUP
MFG-ST-FACILITY -> FAC-ST-FACILITY
FAC-COMPANY
FAC-FACILITY-LOC
|
