Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             AMLOCDTL FILE

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

UPDATED BY

AM07.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

LOD-LOC-DTL          Alpha 14                                    AM07.3
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
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
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
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
                                                                 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
                                                                 ...