AMASTMXVAL – Asset Attributes

System
Asset Management (AM)
Prefix
MXT
Primary key
OBJ-ID, MATRIX-CAT
Fields
3
Updated by
271 programs
Referenced by
37 programs

AMASTMXVAL is the Asset Attributes table in Lawson Asset Management (prefix MXT). It is indexed by OBJ-ID, MATRIX-CAT (MXTSET1); alternate indexes: MXTSET2. It is related 1:1 to AMASSET, MXCATDEF and MXOBJCAT. It is updated by AC160, AM115, AM117, AM135, AM15.1, AM15.2, AM15.3, AM15.4 and 263 more and referenced by AM120, AM220, AM221, AM222, AM223, AM224, AM225, AM230 and 29 more. The table has 3 fields, 2 indexes and 3 documented relations.

About AMASTMXVAL

This file contains the asset attribute information defined in AM23.1 (Asset Attributes). Attributes capture user-definable additional information about an asset (i.e., lease, license, and/or insurance information). This file and AM23 are used in conjunction with the Matrix module where elements, attributes, templates, attribute values, and lists can be defined. AM23.1 lets you create attributes, attribute values, and lists.

Fields (3)

Column = COBOL field name without the MXT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MXT-OBJ-ID PK
OBJ_ID		Numeric 12This is the object identifier. It is used to relate transactions back to the originating subsystems.AM135, AM154, AM23.1, AM23.2, AM30.1, AM30.2, AM310, AM320 +4 more
#MXT-MATRIX-CAT PK
MATRIX_CAT		Alpha 12This is the attribute name assigned to an object to track additional information. Asset attributes are defined in AC23.1 (Asset Attributes). Attribute values can be used in selection and sorting for reporting and analysis.AM135, AM154, AM23.1, AM23.2, AM30.1, AM30.2, AM40.1, AM500 +1 more
#MXT-MX-VALUE SET2
MX_VALUE		Alpha 32This is the value for the attribute. Asset attributes are defined in AC23.1 (Asset Attributes). Values can be assigned in AM23.2 (Values by Asset Attributes).AM135, AM154, AM23.1, AM23.2, AM30.1, AM30.2, AM40.1, AM500 +1 more

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MXTSET1
  1. OBJ-ID
  2. MATRIX-CAT
PrimaryAC160, AM115, AM117, AM120, AM135, AM15.1, AM15.2, AM15.3 +22 more (list truncated in source)
MXTSET2
  1. MATRIX-CAT
  2. MX-VALUE
  3. OBJ-ID
AM120, AM135, AM154, AM220, AM221, AM222, AM223, AM224 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
AMASSETMXCATDEFMXOBJCATAMASTMXVAL

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETRequired
MXT-OBJ-ID→AST-OBJ-ID
MxcatdefMXCATDEFRequired
MXT-MATRIX-CAT→MXC-MATRIX-CAT
MxobjcatMXOBJCATRequired
"ASSET"→MOC-OBJ-TYPE
MXT-MATRIX-CAT→MOC-MATRIX-CAT

Programs

Updated by (271)

Referenced by (37)