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