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 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 AM22.1 AM22.2 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 AM55.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 AP510 AP52.3 API1.1 API2.1 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC12.1 IC140
IC141 IC142 IC145 IC243 IC330 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC83.1 MA126 MA180
MA278 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 MA53.1 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 PD570
PO04.1 PO04.2 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.3 PO26.7 PO26.9 PO27.2
PO27.3 PO27.4 PO275 PO276 PO277 PO28.2
PO280 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 RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1 RQII.1
RQIJ.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


UPDATED BY
AM07.3

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
LOD-GEO-TYPE
Element: Customer Code
Alpha 4
LOD-GEO-LATITUDE
Element: Gis Coordinate
Signed 12.6
AM07.3
LOD-GEO-LONGITUDE
Element: Gis Coordinate
Signed 12.6
AM07.3
LOD-GEO-ALTITUDE
Element: Gis Coordinate
Signed 12.6
AM07.3
LOD-GEO-DATE
Element: Date
Numeric 8 (yyyymmdd)
AM07.3
LOD-GEO-TIME
Element: Sys Time
Numeric 6 (hhmmss)
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 02:05:35 2016

Home
Contact Us



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