|
|
ICMFGDIST FILE
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 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.7 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 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 PO00.1 PO100 PO101 PO122 PO131
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 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 POI3.1 POID.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MFD-ITEM-GROUP Alpha 5
Element: Item Group This field contains the identifier for
a group of items that can be shared by
one or more companies.
MFD-MANUF-ID Numeric 4
Element: Manuf Id A unique idenitifier for a manufacturer
MFD-COMPANY Numeric 4
Element: Company 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 Alpha 5
Element: Location This field contains a valid stocking
location within the company inventory.
MFD-NAME Alpha 30 (Lower Case)
Element: Name Displays the company description.
MFD-MANUF-DIST-ID Alpha 15
Element: Manuf Dist Id 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 Alpha 30 (Lower Case)
Element: Addr1 This field contains the first line of
address information.
MFD-ADDR2 Alpha 30 (Lower Case)
Element: Addr1 This field contains the first line of
address information.
MFD-ADDR3 Alpha 30 (Lower Case)
Element: Addr1 This field contains the first line of
address information.
MFD-ADDR4 Alpha 30 (Lower Case)
Element: Addr1 This field contains the first line of
address information.
MFD-CITY-ADDR5 Alpha 18 (Lower Case)
Element: City This field contains the city of the
address.
MFD-STATE-PROV Alpha 2
Element: State Prov The state or province.
MFD-POSTAL-CODE Alpha 10 (Lower Case)
Element: Postal Code This field contains the postal code.
MFD-COUNTRY-CODE Alpha 2
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
MFD-COUNTY Alpha 25 (Lower Case)
Element: County The county for the company address.
ICMFGDIST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MFDSET1 ITEM-GROUP AP125 AP126
MANUF-ID AP131 AP20.1
COMPANY AP20.2 AP20.3
LOCATION AP20.4 AP20.5
NAME AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
ICMFGDIST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
