Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MFGSHPFAC


                             MFGSHPFAC FILE

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    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

MFG-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.

MFG-MANUF-ID           Numeric 4
Element: Manuf Id      A unique idenitifier for a manufacturer

MFG-ST-FACILITY        Alpha 15
Element: St Facility   A unique identifier for a ship to
                       facility.

MFG-NAME               Alpha 30  (Lower Case)
Element: Name          Displays the company description.

MFG-MANUF-FAC-ID       Alpha 15
Element: Manuf Fac Id  Stores a manufacturer supplied ship to
                       facility id for use on the product
                       transfer and resale report EDI
                       transaction N1 segment.

MFG-ADDR1              Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

MFG-ADDR2              Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

MFG-ADDR3              Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

MFG-ADDR4              Alpha 30  (Lower Case)
Element: Addr1         This field contains the first line of
                       address information.

MFG-CITY-ADDR5         Alpha 18  (Lower Case)
Element: City          This field contains the city of the
                       address.

MFG-STATE-PROV         Alpha 2
Element: State Prov    The state or province.

MFG-POSTAL-CODE        Alpha 10  (Lower Case)
Element: Postal Code   This field contains the postal code.

MFG-COUNTRY-CODE       Alpha 2
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

MFG-COUNTY             Alpha 25  (Lower Case)
Element: County        The county for the company address.

                         MFGSHPFAC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MFGSET1   ITEM-GROUP                                             AP125   AP126
          MANUF-ID                                               AP131   AP20.1
          ST-FACILITY                                            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
                                                                 ...

MFGSET2   ITEM-GROUP
          ST-FACILITY
          MANUF-ID

                         MFGSHPFAC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Icmanuf        ICMANUF      Required

                            MFG-ITEM-GROUP     -> ICM-ITEM-GROUP  (ICMSET1)
                            MFG-MANUF-ID       -> ICM-MANUF-ID

                         MFGSHPFAC FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Icfacility     ICFACILITY

                            MFG-ITEM-GROUP     -> FAC-ITEM-GROUP
                            MFG-ST-FACILITY    -> FAC-ST-FACILITY
                                                  FAC-COMPANY
                                                  FAC-FACILITY-LOC