AMLOCATION

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 AM219 AM220 AM221 AM222
AM223 AM224 AM225 AM230 AM235 AM240
AM245 AM25.1 AM25.2 AM25.3 AM250 AM255
AM260 AM265 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 AM580 AM70.1 AM81.2 AM95.1
AM95.4 AM95.5 AM95.6 AM97.1 AP05.3 AP52.3
PO53.9 AM152 AM153 AM200 AM207 AM212
AM252 AM258 AM266 AM60.1 AM90.1 AM90.4
AM90.5 AM91.1 AM91.4 AM91.5


UPDATED BY
AC10.1 AC10.3 AC160 AC56.1 AC560 AC71.1
AM07.1 AM07.2 AM07.3 AM115 AM117 AM12.1
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 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 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 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

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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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
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 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 API1.1
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


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


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 11:06:10 2016

Home
Contact Us



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