ICMFGDIST

IC Manufacturers Distribution

This table is used to identify inventory locations that have been established as central distribution centers to a manufacturer for the prupose 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 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC140 IC141 IC142 IC145 IC153
IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2
IC24.1 IC24.2 IC243 IC25.1 IC330 IC500
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA53.1 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 PD570 PO00.1 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO115
PO120 PO122 PO131 PO132 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
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 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500
RQ810 RQIB.1 RQIF.1 RQII.1 RQIJ.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


UPDATED BY
IC34.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MFD-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
MFD-MANUF-ID
Element: Manuf Id		Numeric 4
A unique idenitifier for a manufacturer
IC34.1
MFD-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
IC34.1
MFD-LOCATION
Element: Location		Alpha 5
This field contains a valid stocking location within the company inventory.
IC34.1
MFD-NAME
Element: Name		Alpha 30 (Lower Case)
Displays the company description.
IC34.1
MFD-MANUF-DIST-ID
Element: Manuf Dist Id		Alpha 15
Used to store a manufacturer supplied id that will be used to identify a distribution center on the product trasnfer and resale report EDI trasnaction (867) N1 segment.
IC34.1
MFD-ADDR1
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
IC34.1
MFD-ADDR2
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
IC34.1
MFD-ADDR3
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
IC34.1
MFD-ADDR4
Element: Addr1		Alpha 30 (Lower Case)
This field contains the first line of address information.
IC34.1
MFD-CITY-ADDR5
Element: City		Alpha 18 (Lower Case)
This field contains the city of the address.
IC34.1
MFD-STATE-PROV
Element: State Prov		Alpha 2
The state or province.
IC34.1
MFD-POSTAL-CODE
Element: Postal Code		Alpha 10 (Lower Case)
This field contains the postal code.
IC34.1
MFD-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
MFD-COUNTY
Element: County		Alpha 25 (Lower Case)
The county for the company address.
IC34.1


ICMFGDIST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MFDSET1 ITEM-GROUP
MANUF-ID
COMPANY
LOCATION
NAME
...
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
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100


ICMFGDIST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Iclocation ICLOCATION Required
MFD-COMPANY->ICL-COMPANY
MFD-LOCATION->ICL-LOCATION
Icmanuf ICMANUF Required
MFD-ITEM-GROUP->ICM-ITEM-GROUP
MFD-MANUF-ID->ICM-MANUF-ID

File created: Thu Jun 09 02:18:46 2016

Home
Contact Us



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