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

AM115     AM117     AM125     AM145     AM15.1    AM15.2
AM15.3    AM15.4    AM152     AM153     AM170     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
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

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                                          AM07.1  AM07.2
          LOC-DTL                                                AM07.3  AM115
                                                                 AM117   AM125
                                                                 AM145   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM152
                                                                 AM153   AM170
                                                                 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  AM223
                                                                 AM235   AM245
                                                                 ...

                         AMLOCDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amlocation     AMLOCATION   Required

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