AMASTMXCNV is the Asset Attribute Conversion table in Lawson Asset Management (prefix MCV). It is indexed by CONVERSION-NBR, MATRIX-CAT (MCVSET1). It is related 1:1 to AMASSETCNV and AMCNVASSET and 1:M to AMASTBKCNV, AMASTITCNV and AMASTTRCNV. It is updated by AM500 and AM94.1. The table has 3 fields, 1 index and 5 documented relations.
About AMASTMXCNV
No description in the Lawson data dictionary.
Fields (3)
Column = COBOL field name without the MCV- 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.
Required key. This number associates the attribute with the asset. This number can be the Lawson-assigned asset number for use when doing just attribute conversion.
This is the value to assign to the asset attribute. This field is required if you are adding or deleting an attribute value.
AM94.1
Indexes (1)
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.
Index
Keys
Flags
Condition
Used in
MCVSET1
CONVERSION-NBR
MATRIX-CAT
Primary
AM500, AM94.1
Relations
Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
