Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ICFACILITY

                            ICFACILITY FILE

The purpose of this table is to group Inventory and requesting locations as a
single facility sucha as a hospital or clinic for reporting purposes.

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

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

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

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

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

FAC-FACILITY-LOC       Alpha 5
Element: Facility Loc

FAC-FAC-LOC-TYPE       Numeric 1
Element: Fac Loc Type  Identifies a location as an inventory or
                       requesting location.
                       0 = IC Location
                       1 = Requesting Location

                         ICFACILITY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FACSET1   ITEM-GROUP                                             AP125   AP126
          ST-FACILITY                                            AP131   AP20.1
          COMPANY                                                AP20.2  AP20.3
          FACILITY-LOC                                           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
                                                                 ...

                         ICFACILITY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iclocation     ICLOCATION   Not Required
                            Valid When FAC-FAC-LOC-TYPE = Zeroes

                            FAC-COMPANY         -> ICL-COMPANY
                            FAC-FACILITY-LOC    -> ICL-LOCATION

Rqloc          RQLOC        Not Required
                            Valid When FAC-FAC-LOC-TYPE = 1

                            FAC-COMPANY         -> RQL-COMPANY
                            FAC-FACILITY-LOC    -> RQL-REQ-LOCATION

                         ICFACILITY FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mfgshpfac      MFGSHPFAC

                            FAC-ITEM-GROUP      -> MFG-ITEM-GROUP
                            FAC-ST-FACILITY     -> MFG-ST-FACILITY
                                                   MFG-MANUF-ID