AMLOCDTL

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 AM17.1
AM170 AM19.1 AM19.2 AM19.3 AM19.4 AM20.1
AM20.2 AM20.3 AM20.4 AM20.5 AM20.6 AM21.1
AM21.2 AM21.3 AM21.4 AM21.5 AM21.6 AM219
AM22.1 AM25.1 AM25.2 AM25.3 AM250 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
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC140
IC66.1 IC83.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA42.1 MA42.2 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MA44.1 MA44.2 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA69.1 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO136 PO150
PO190 PO20.1 PO20.6 PO20.9 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO28.2 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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 PO54.5 POCP.1 POI3.1 POID.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.4 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ500 RQIF.1 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 ZW130 AM152
AM153 AM207 AM252 AM266


UPDATED BY
AM07.1 AM07.2 AM07.3 AM223 AM235 AM245

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LOD-LOCATION-NAME
Element: Location Name		Alpha 15
This field contains the location name defined using Location (AM07.1) or Locations (AM07.2)
AM07.3
LOD-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field contains the description of the location.
LOD-LOC-DTL
Element: Loc Dtl		Alpha 14
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.
AM07.3
LOD-LEVEL-1
Element: Level 1		Alpha 14
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.
AM07.3
LOD-LEVEL-2
Element: Level 2		Alpha 14
This field contains the second level of location detail. Its size is dependent upon the AMLOCATION DTL-SEG-2 field.
AM07.3
LOD-LEVEL-3
Element: Level 3		Alpha 14
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.
AM07.3


AMLOCDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LODSET1 LOCATION-NAME
LOC-DTL
...
AC160 AM07.1
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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Amlocation AMLOCATION Required
LOD-LOCATION-NAME->LOC-LOCATION-NAME

File created: Thu Jun 09 11:06:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.