Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICMFGDIST


                             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