Lawson Insight Technical Documentation |
|
AMLOCATION
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 AM207
AM212 AM220 AM221 AM222 AM223 AM224
AM225 AM230 AM235 AM240 AM245 AM25.1
AM25.2 AM25.3 AM250 AM252 AM255 AM260
AM265 AM266 AM267 AM278 AM280 AM281
AM285 AM287 AM290 AM292 AM295 AM30.1
AM330 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
AM21.1 AM21.2 AM21.3 AM21.4 AM21.5 AM21.6
AM500 AM52.1 AM551 AM88.7 AM96.1 AM98.1
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 MA41.2 MA43.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LOC-LOCATION-NAME Alpha 15 AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-DESCRIPTION Alpha 30 (Lower Case) AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-ADDR1 Alpha 30 (Lower Case) AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-ADDR2 Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Address 2 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-ADDR3 Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Address 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-ADDR4 Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Address 4 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-ADDR5 Alpha 18 (Lower Case) AC10.1 AC10.3
Element: Address 5 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-STATE-PROV Alpha 2 AC10.1 AC10.3
Element: State or ProviThe 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-POSTAL-CODE Alpha 10 (Lower Case) AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-AUTH-COUNTRY Alpha 30 AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-AUTH-DISTRICT Alpha 30 AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-AUTH-CTY-LOCAL Alpha 30 AC10.1 AC10.3
Element: City or LocaliThe 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-ADDR-CONTACT Alpha 30 (Lower Case) AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-PHONE-COUNTRY Alpha 6 AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-PHONE-NUMBER Alpha 15 AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-PHONE-EXT Alpha 5 AC10.1 AC10.3
Element: Phone ExtensioThis 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-FAX-COUNTRY Alpha 6 AC10.1 AC10.3
Element: Fax Prefix 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-FAX-NUMBER Alpha 15 AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-FAX-EXT Alpha 5 AC10.1 AC10.3
Element: Fax Extension 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-TELEX-NUMBER Alpha 15 AC10.1 AC10.3
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.1
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 MA41.2
MA43.2
LOC-DTL-SEG-1 Numeric 2 AM07.3
Element: 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
Element: 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
Element: 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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM265 AM500
AM52.1 AM551
AM88.7 AM96.1
...
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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
AM96.1 AM98.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
AM21.1 AM21.2
AM21.3 AM21.4
AM21.5 AM21.6
AM500 AM52.1
AM551 AM88.7
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
Amlocdtl AMLOCDTL
LOC-LOCATION-NAME -> LOD-LOCATION-NAME
LOD-LOC-DTL
|