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