AMASTMXCNV – Asset Attribute Conversion
- System
- Asset Management (AM)
- Prefix
MCV- Primary key
CONVERSION-NBR,MATRIX-CAT- Fields
- 3
- Updated by
- 2 programs
- Referenced by
- 0 programs
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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MCV-CONVERSION-NBR PKCONVERSION_NBR | Alpha 22 | 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. | AM94.1 |
MCV-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | This is the name of the asset attribute to which you are assigning values. This field is required if you are adding or deleting an asset attribute. | AM94.1 |
MCV-MX-VALUEMX_VALUE | Alpha 32 | 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 marked * are descending. 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
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Amassetcnv | AMASSETCNV | Not Required | MCV-CONVERSION-NBR → ACN-CONVERSION-NBR | |
| Amcnvasset | AMCNVASSET | Not Required | MCV-CONVERSION-NBR → CVA-CONVERSION-NBR |
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Amastbkcnv | AMASTBKCNV | MCV-CONVERSION-NBR → ABC-CONVERSION-NBR, ABC-BOOK | ||
| Amastitcnv | AMASTITCNV | MCV-CONVERSION-NBR → ITC-CONVERSION-NBR, ITC-SEQ-NUMBER | ||
| Amasttrcnv | AMASTTRCNV | MCV-CONVERSION-NBR → TNC-CONVERSION-NBR, TNC-SEQ-NUMBER |