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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

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

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
AmassetAMASSETRequiredMXT-OBJ-ID → AST-OBJ-ID
MxcatdefMXCATDEFRequiredMXT-MATRIX-CAT → MXC-MATRIX-CAT
MxobjcatMXOBJCATRequired"ASSET" → MOC-OBJ-TYPE, MXT-MATRIX-CAT → MOC-MATRIX-CAT

Programs

Updated by (271)

Referenced by (37)