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 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 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 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
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 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
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PD10.1 PD10.2 PD130 PD20.1 PD20.2 PD20.3
PO100 PO101 PO122 PO131 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO27.2
PO29.1 PO30.1 PO30.2 PO30.3 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 POI3.1 POID.1
POII.1 POIJ.1 RQ10.1 RQ10.2 WH20.2 WH20.7
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 AC160 AC56.1
represents where an asset is physically AC560 AC71.1
located. Locations are used to report AM07.1 AM07.2
asset information. 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
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
...
LOC-DESCRIPTION Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Description The description of the asset location. 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
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
...
LOC-ADDR1 Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Address 1 This field contains the first line of AC160 AC56.1
address information. 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
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
...
LOC-ADDR2 Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Address 2 This field contains the first line of AC160 AC56.1
address information. 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
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
...
LOC-ADDR3 Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Address 3 This field contains the first line of AC160 AC56.1
address information. 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
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
...
LOC-ADDR4 Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Address 4 This field contains the first line of AC160 AC56.1
address information. 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
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
...
LOC-ADDR5 Alpha 18 (Lower Case) AC10.1 AC10.3
Element: Address 5 This field contains the city of the AC160 AC56.1
address. 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
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
...
LOC-STATE-PROV Alpha 2 AC10.1 AC10.3
Element: State or ProviThe state or province for the location AC160 AC56.1
address. An entry in this field creates AC560 AC71.1
a record in the Tax Authority file. 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
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
...
LOC-POSTAL-CODE Alpha 10 (Lower Case) AC10.1 AC10.3
Element: Postal Code This field contains the postal code. 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
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
...
LOC-AUTH-COUNTRY Alpha 30 AC10.1 AC10.3
Element: Country The country for the location address. AC160 AC56.1
Used for property tax compliance, if AC560 AC71.1
needed. An entry in this field creates a AM07.1 AM07.2
record in the Tax Authority file. 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
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
...
LOC-AUTH-DISTRICT Alpha 30 AC10.1 AC10.3
Element: District The district for the location address. AC160 AC56.1
Used for property tax compliance, if AC560 AC71.1
needed. An entry in this field creates a AM07.1 AM07.2
record in the Tax Authority file. 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
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
...
LOC-AUTH-CTY-LOCAL Alpha 30 AC10.1 AC10.3
Element: City or LocaliThe county or locality for the location AC160 AC56.1
address. Used for property tax AC560 AC71.1
compliance, if needed. An entry in this AM07.1 AM07.2
field creates a record in the Tax AM07.3 AM115
Authority file. 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
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
...
LOC-ADDR-CONTACT Alpha 30 (Lower Case) AC10.1 AC10.3
Element: Contact This is the name of the main contact. 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
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
...
LOC-PHONE-COUNTRY Alpha 6 AC10.1 AC10.3
Element: Phone Prefix This field contains the prefix of the AC160 AC56.1
telephone number. For example, the AC560 AC71.1
country or city code. 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
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
...
LOC-PHONE-NUMBER Alpha 15 AC10.1 AC10.3
Element: Phone Number This field contains the telephone AC160 AC56.1
number, including area code. 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
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
...
LOC-PHONE-EXT Alpha 5 AC10.1 AC10.3
Element: Phone ExtensioThis field contains the telephone AC160 AC56.1
extension number. 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
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
...
LOC-FAX-COUNTRY Alpha 6 AC10.1 AC10.3
Element: Fax Prefix This field contains the prefix of the AC160 AC56.1
telephone number. For example, the AC560 AC71.1
country or city code. 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
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
...
LOC-FAX-NUMBER Alpha 15 AC10.1 AC10.3
Element: Fax Number Phone number. 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
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
...
LOC-FAX-EXT Alpha 5 AC10.1 AC10.3
Element: Fax Extension This field contains the telephone AC160 AC56.1
extension number. 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
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
...
LOC-TELEX-NUMBER Alpha 15 AC10.1 AC10.3
Element: Telex Number Phone number. 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
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
...
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
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 KeyChange, Subset AC10.1 AC10.3
LOCATION-NAME Where AUTH-DISTRICT != Spaces 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-LOCALKeyChange, Subset AC10.1 AC10.3
LOCATION-NAME Where AUTH-CTY-LOCAL != Spaces 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 KeyChange, Subset AC10.1 AC10.3
LOCATION-NAME Where STATE-PROV != Spaces 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 KeyChange, Subset AC10.1 AC10.3
LOCATION-NAME Where AUTH-COUNTRY != Spaces 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 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
|