AMLOCATION FILE
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 AM200 AM212 AM220 AM221 AM222
AM223 AM224 AM225 AM230 AM235 AM240
AM245 AM250 AM255 AM260 AM265 AM280
AM285 AM290 AM292 AM295 AM30.1 AM35.1
AM45.1 AM580 AM60.1 AM70.1 AM90.1 AM95.1
UPDATED BY
AM07.1 AM07.2 AM115 AM12.1 AM15.1 AM15.2
AM15.3 AM15.4 AM170 AM20.1 AM20.2 AM20.3
AM20.4 AM20.5 AM20.6 AM500 AM950 AM96.1
AM98.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LOC-LOCATION-NAME Alpha 15 AM07.1 AM07.2
Location Name A user-defined location name which AM115 AM12.1
represents where an asset is physically AM15.1 AM15.2
located. Locations are used to report AM15.3 AM15.4
asset information. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM950 AM96.1
AM98.1
LOC-DESCRIPTION Alpha 30 (Lower Case) AM07.1 AM07.2
Description The description of the asset location. AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM950 AM96.1
AM98.1
LOC-ADDR1 Alpha 30 (Lower Case) AM07.1 AM07.2
Address 1 This field contains the first line of AM115 AM12.1
address information. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM950 AM96.1
AM98.1
LOC-ADDR2 Alpha 30 (Lower Case) AM07.1 AM07.2
Address 2 This field contains the second line of AM115 AM12.1
address information. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM950 AM96.1
AM98.1
LOC-ADDR3 Alpha 30 (Lower Case) AM07.1 AM07.2
Address 3 This field contains the third line of AM115 AM12.1
address information. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-ADDR4 Alpha 30 (Lower Case) AM07.1 AM07.2
Address 4 This field contains the fourth line of AM115 AM12.1
address information. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-ADDR5 Alpha 18 (Lower Case) AM07.1 AM07.2
Address 5 This field contains the fifth line of AM115 AM12.1
address information. In the United AM15.1 AM15.2
States, define the city. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-STATE-PROV Alpha 2 AM07.1 AM07.2
State or Province The state or province for the location AM115 AM12.1
address. An entry in this field creates AM15.1 AM15.2
a record in the Tax Authority file. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-POSTAL-CODE Alpha 10 (Lower Case) AM07.1 AM07.2
Postal Code This field contains the postal code. AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-AUTH-COUNTRY Alpha 30 AM07.1 AM07.2
Country The country for the location address. AM115 AM12.1
Used for property tax compliance, if AM15.1 AM15.2
needed. An entry in this field creates a AM15.3 AM15.4
record in the Tax Authority file. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-AUTH-DISTRICT Alpha 30 AM07.1 AM07.2
District The district for the location address. AM115 AM12.1
Used for property tax compliance, if AM15.1 AM15.2
needed. An entry in this field creates a AM15.3 AM15.4
record in the Tax Authority file. AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-AUTH-CTY-LOCAL Alpha 30 AM07.1 AM07.2
City or Locality The county or locality for the location AM115 AM12.1
address. Used for property tax AM15.1 AM15.2
compliance, if needed. An entry in this AM15.3 AM15.4
field creates a record in the Tax AM170 AM20.1
Authority file. AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-ADDR-CONTACT Alpha 30 (Lower Case) AM07.1 AM07.2
Contact This is the name of the main contact. AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-PHONE-COUNTRY Alpha 6 AM07.1 AM07.2
Phone Prefix This field contains the prefix of the AM115 AM12.1
telephone number. For example, the AM15.1 AM15.2
country or city code. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-PHONE-NUMBER Alpha 15 AM07.1 AM07.2
Phone Number This field contains the telephone AM115 AM12.1
number, including area code. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-PHONE-EXT Alpha 5 AM07.1 AM07.2
Phone Extension This field contains the telephone AM115 AM12.1
extension number. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-FAX-COUNTRY Alpha 6 AM07.1 AM07.2
Fax Prefix This field contains the prefix of the AM115 AM12.1
fax number. For example, the country or AM15.1 AM15.2
city code. AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-FAX-NUMBER Alpha 15 AM07.1 AM07.2
Fax Number This field contains the fax number. AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-FAX-EXT Alpha 5 AM07.1 AM07.2
Fax Extension This field contains the fax number AM115 AM12.1
extension. AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOC-TELEX-NUMBER Alpha 15 AM07.1 AM07.2
Telex Number This is the telex number. AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
AMLOCATION FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LOCSET1 LOCATION-NAME AM07.1 AM07.2
AM115 AM12.1
AM125 AM15.1
AM15.2 AM15.3
AM15.4 AM170
AM20.1 AM20.2
AM20.3 AM20.4
AM20.5 AM20.6
AM200 AM212
AM220 AM221
AM222 AM223
AM224 AM225
AM230 AM235
AM240 AM245
AM250 AM255
...
LOCSET2 AUTH-DISTRICT KeyChange, Subset AM07.1 AM07.2
LOCATION-NAME Where AUTH-DISTRICT != Spaces AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM265
AM500 AM96.1
AM98.1
LOCSET3 AUTH-CTY-LOCALKeyChange, Subset AM07.1 AM07.2
LOCATION-NAME Where AUTH-CTY-LOCAL != Spaces AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOCSET4 STATE-PROV KeyChange, Subset AM07.1 AM07.2
LOCATION-NAME Where STATE-PROV != Spaces AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
LOCSET5 AUTH-COUNTRY KeyChange, Subset AM07.1 AM07.2
LOCATION-NAME Where AUTH-COUNTRY != Spaces AM115 AM12.1
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM500
AM96.1 AM98.1
AMLOCATION FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|