AMLOCATION

Asset Location

The Location file stores optional location record that describe where an asset is physically located. Locations are physical groups of assets that can be reported on and are used in property tax compliance.

REFERENCED BY
AM125 AM145 AM152 AM153 AM200 AM207
AM212 AM219 AM220 AM221 AM222 AM223
AM224 AM225 AM230 AM235 AM240 AM245
AM25.1 AM25.2 AM25.3 AM250 AM252 AM255
AM258 AM260 AM265 AM266 AM267 AM278
AM280 AM281 AM285 AM287 AM288 AM290
AM292 AM295 AM30.1 AM330 AM35.1 AM35.2
AM45.1 AM45.2 AM45.3 AM51.1 AM55.1 AM580
AM60.1 AM70.1 AM81.2 AM90.1 AM90.4 AM90.5
AM91.1 AM91.4 AM91.5 AM95.1 AM95.4 AM95.5
AM95.6 AM97.1 AP05.3 AP52.3 PO53.9


UPDATED BY
AC10.1 AC10.3 AC160 AC56.1 AC560 AC71.1
AM07.1 AM07.2 AM07.3 AM115 AM117 AM12.1
AM12.2 AM15.1 AM15.2 AM15.3 AM15.4 AM17.1
AM170 AM19.1 AM19.2 AM20.1 AM20.2 AM20.3
AM20.4 AM20.5 AM20.6 AM21.1 AM21.2 AM21.3
AM21.4 AM21.5 AM21.6 AM22.1 AM22.2 AM500
AM52.1 AM551 AM88.7 AM96.1 AM98.1 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 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 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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LOC-LOCATION-NAME
Element: Location Name
Alpha 15
A user-defined location name which represents where an asset is physically located. Locations are used to report asset information.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description of the asset location.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-ADDR1
Element: Address 1
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-ADDR2
Element: Address 2
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-ADDR3
Element: Address 3
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-ADDR4
Element: Address 4
Alpha 30 (Lower Case)
This field contains the first line of address information.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-ADDR5
Element: Address 5
Alpha 18 (Lower Case)
This field contains the city of the address.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-STATE-PROV
Element: State or Province
Alpha 2
The state or province for the location address. An entry in this field creates a record in the Tax Authority file.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-AUTH-COUNTRY
Element: Country
Alpha 30
The country for the location address. Used for property tax compliance, if needed. An entry in this field creates a record in the Tax Authority file.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-AUTH-DISTRICT
Element: District
Alpha 30
The district for the location address. Used for property tax compliance, if needed. An entry in this field creates a record in the Tax Authority file.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-AUTH-CTY-LOCAL
Element: City or Locality
Alpha 30
The county or locality for the location address. Used for property tax compliance, if needed. An entry in this field creates a record in the Tax Authority file.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-ADDR-CONTACT
Element: Contact
Alpha 30 (Lower Case)
This is the name of the main contact.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-PHONE-COUNTRY
Element: Phone Prefix
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-PHONE-NUMBER
Element: Phone Number
Alpha 15
This field contains the telephone number, including area code.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-PHONE-EXT
Element: Phone Extension
Alpha 5
This field contains the telephone extension number.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-FAX-COUNTRY
Element: Fax Prefix
Alpha 6
This field contains the prefix of the telephone number. For example, the country or city code.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-FAX-NUMBER
Element: Fax Number
Alpha 15
Phone number.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-FAX-EXT
Element: Fax Extension
Alpha 5
This field contains the telephone extension number.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-TELEX-NUMBER
Element: Telex Number
Alpha 15
Phone number.
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-DTL-SEG-1
Element: Dtl Seg 1
Numeric 2
This field determines the number of characters used for location detail level 1. The system uses this field to parse the location detail bar code into its components. The total of the three levels cannot exceed 14 characters.
AM07.3
LOC-DTL-SEG-2
Element: Dtl Seg 2
Numeric 2
This field determines the number of characters used for location detail level 2. The system uses this field to parse the location detail bar code into its components. The total of the three levels cannot exceed 14 characters.
AM07.3
LOC-DTL-SEG-3
Element: Dtl Seg 3
Numeric 2
This field determines the number of characters used for location detail level 3. The system uses this field to parse the location detail bar code into its components. The total of the three levels cannot exceed 14 characters.
AM07.3
LOC-GEO-TYPE
Element: Customer Code
Alpha 4
LOC-GEO-LATITUDE
Element: Gis Coordinate
Signed 12.6
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-GEO-LONGITUDE
Element: Gis Coordinate
Signed 12.6
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-GEO-ALTITUDE
Element: Gis Coordinate
Signed 12.6
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-GEO-DATE
Element: Date
Numeric 8 (yyyymmdd)
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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
LOC-GEO-TIME
Element: Sys Time
Numeric 6 (hhmmss)
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM22.2 AM500
AM52.1 AM551
AM88.7 AM96.1
AM98.1 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


AMLOCATION FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LOCSET1 LOCATION-NAME
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 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
LOCSET2 AUTH-DISTRICT
LOCATION-NAME
KeyChange, Subset
WhereAUTH-DISTRICT !=Spaces
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
LOCSET3 AUTH-CTY-LOCAL
LOCATION-NAME
KeyChange, Subset
WhereAUTH-CTY-LOCAL !=Spaces
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
LOCSET4 STATE-PROV
LOCATION-NAME
KeyChange, Subset
WhereSTATE-PROV !=Spaces
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
LOCSET5 AUTH-COUNTRY
LOCATION-NAME
KeyChange, Subset
WhereAUTH-COUNTRY !=Spaces
...
AC10.1 AC10.3
AC160 AC56.1
AC560 AC71.1
AM07.1 AM07.2
AM07.3 AM115
AM117 AM12.1
AM12.2 AM15.1
AM15.2 AM15.3
AM15.4 AM17.1
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3


AMLOCATION FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Amasset1 AMASSET
1->AST-STATUS
LOC-LOCATION-NAME->AST-LOCATION-NAME
  AST-DSP-ASSET
  AST-ASSET
Amasset2 AMASSET
2->AST-STATUS
LOC-LOCATION-NAME->AST-LOCATION-NAME
  AST-DSP-ASSET
  AST-ASSET
Amasset3 AMASSET
3->AST-STATUS
LOC-LOCATION-NAME->AST-LOCATION-NAME
  AST-DSP-ASSET
  AST-ASSET
Amassetadj AMASSETADJ
LOC-LOCATION-NAME->ASA-LOCATION-NAME
  ASA-ASSET
  ASA-PROCESS-SEQ
Amassetdsp AMASSET
9->AST-STATUS
LOC-LOCATION-NAME->AST-LOCATION-NAME
  AST-DSP-ASSET
  AST-ASSET
Amassettrf AMASSETTRF
LOC-LOCATION-NAME->ATF-LOCATION-NAME
  ATF-ASSET
  ATF-PROCESS-SEQ
Amlocdtl AMLOCDTL
LOC-LOCATION-NAME->LOD-LOCATION-NAME
  LOD-LOC-DTL
Location Audit AMLOCAUDIT
LOC-LOCATION-NAME->LOA-LOCATION-NAME
  LOA-DATE
  LOA-TIME
  LOA-ACTION
  LOA-UNIQUE-I-D


File created: Thu Jun 09 02:05:34 2016

Home
Contact Us



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