Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMLOCDTL


                             AMLOCDTL FILE

                            Location Detail

The Location Detail file stores detail location information for a location.
This file is populated by LOction (AM07.1), Locations (AM07.2), and Location
Detail (AM07.3).

REFERENCED BY

AC160     AM115     AM117     AM125     AM145     AM15.1
AM15.2    AM15.3    AM15.4    AM15.5    AM15.6    AM152
AM153     AM17.1    AM170     AM19.1    AM19.2    AM19.3
AM19.4    AM20.1    AM20.2    AM20.3    AM20.4    AM20.5
AM20.6    AM207     AM21.1    AM21.2    AM21.3    AM21.4
AM21.5    AM21.6    AM219     AM223     AM235     AM245
AM25.1    AM25.2    AM25.3    AM250     AM252     AM266
AM30.1    AM35.1    AM35.2    AM45.1    AM45.2    AM45.3
AM500     AM51.1    AM52.1    AM551     AM96.1    AM97.1
AM98.1    AP05.3    AP115     AP125     AP126     AP131
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP21.1    AP220     AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP30.2    AP30.4    AP305     AP52.3    API1.1
API2.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.4    MA43.6    MA43.7
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA63.1    MA65.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    PO100     PO101     PO122     PO131     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     PO53.9    PO536
POI3.1    POID.1    POII.1    POIJ.1    RQ10.1    RQ10.2
WH20.2    WH20.7

UPDATED BY

AM07.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

LOD-LOCATION-NAME      Alpha 15                                  AM07.3
Element: Location Name This field contains the location name
                       defined using Location (AM07.1) or
                       Locations (AM07.2)

LOD-DESCRIPTION        Alpha 30  (Lower Case)
Element: Description   This field contains the description of
                       the location.

LOD-LOC-DTL            Alpha 14                                  AM07.3
Element: Loc Dtl       This field contains the detail location
                       of an item within the location, defined
                       using Location Detail (AM07.3). The
                       location detail consists of up to three
                       location detail levels concatenated into
                       a scannable location detail bar code.

LOD-LEVEL-1            Alpha 14                                  AM07.3
Element: Level 1       This field contains the first level of
                       the location detail.  It contains the
                       first set of characters from the LOC-DTL
                       field and its size is represented by the
                       AMLOCATION DTL-SEG-1 field.


LOD-LEVEL-2            Alpha 14                                  AM07.3
Element: Level 2       This field contains the second level of
                       location detail.  Its size is dependent
                       upon the AMLOCATION DTL-SEG-2 field.


LOD-LEVEL-3            Alpha 14                                  AM07.3
Element: Level 3       This field contains the lowest level of
                       location detail.  It characters come
                       from the last characters in the LOC-DTL
                       field.  The size of this field is in
                       AMLOCATION DTL-SEG-3.


                         AMLOCDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LODSET1   LOCATION-NAME                                          AC160   AM07.1
          LOC-DTL                                                AM07.2  AM07.3
                                                                 AM115   AM117
                                                                 AM125   AM145
                                                                 AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM15.5  AM15.6
                                                                 AM152   AM153
                                                                 AM17.1  AM170
                                                                 AM19.1  AM19.2
                                                                 AM19.3  AM19.4
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM207   AM21.1
                                                                 ...

                         AMLOCDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amlocation     AMLOCATION   Required

                            LOD-LOCATION-NAME    -> LOC-LOCATION-NAME