ICMFGDIST

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
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
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO136
PO190 PO300 PO520 POCP.1 POI3.1 POII.1
POIJ.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.
MFD-MANUF-ID
Element: Manuf Id
Numeric 4
A unique idenitifier for a manufacturer
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.
MFD-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
MFD-NAME
Element: Name
Alpha 30 (Lower Case)
Displays the company description.
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.
MFD-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
MFD-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
MFD-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
MFD-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
MFD-CITY-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
MFD-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
MFD-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
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).
MFD-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.


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
API1.1 API2.1
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO00.1


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: Wed Jun 08 20:49:38 2016

Home
Contact Us



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