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