MFGSHPFAC

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 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
IC153 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1
IC22.2 IC24.1 IC24.2 IC25.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 PO00.1 IC33.1


UPDATED BY
IC34.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MFG-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
MFG-MANUF-ID
Element: Manuf Id		Numeric 4
A unique idenitifier for a manufacturer
IC34.1
MFG-ST-FACILITY
Element: St Facility		Alpha 15
A unique identifier for a ship to facility.
IC34.1
MFG-NAME
Element: Name		Alpha 30 (Lower Case)
Displays the company description.
IC34.1
MFG-MANUF-FAC-ID
Element: Manuf Fac Id		Alpha 15
Stores a manufacturer supplied ship to facility id for use on the product transfer and resale report EDI transaction N1 segment.
IC34.1
MFG-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
IC34.1
MFG-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
IC34.1
MFG-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
IC34.1
MFG-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
IC34.1
MFG-CITY-ADDR5
Element: City		Alpha 18 (Lower Case)
This field contains the city of the address.
IC34.1
MFG-STATE-PROV
Element: State Prov		Alpha 2
The state or province.
IC34.1
MFG-POSTAL-CODE
Element: Postal Code		Alpha 10 (Lower Case)
This field contains the postal code.
IC34.1
MFG-COUNTRY-CODE
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
IC34.1
MFG-COUNTY
Element: County		Alpha 25 (Lower Case)
The county for the company address.
IC34.1


MFGSHPFAC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MFGSET1 ITEM-GROUP
MANUF-ID
ST-FACILITY
...
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
MFGSET2 ITEM-GROUP
ST-FACILITY
MANUF-ID
IC33.1


MFGSHPFAC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Icfacility ICFACILITY
MFG-ITEM-GROUP->FAC-ITEM-GROUP
MFG-ST-FACILITY->FAC-ST-FACILITY
  FAC-COMPANY
  FAC-FACILITY-LOC

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

Home
Contact Us



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