AMCNVASSET – Asset Conversion Number
- System
- Asset Management (AM)
- Prefix
CVA- Primary key
CONVERSION-NBR- Fields
- 2
- Updated by
- 4 programs
- Referenced by
- 2 programs
AMCNVASSET is the Asset Conversion Number table in Lawson Asset Management (prefix CVA). It is indexed by CONVERSION-NBR (CVASET1); alternate indexes: CVASET2. It is related 1:1 to AMASSETCNV and 1:M to AMASTBKCNV, AMASTITCNV, AMASTMXCNV and AMASTTRCNV. It is updated by AM170, AM300, AM40.1 and AM500 and referenced by AM93.1 and AM94.1. The table has 2 fields, 2 indexes and 5 documented relations.
About AMCNVASSET
This file is a cross-reference file, containing the conversion number and the asset number that the converted asset was assigned. This file lets you convert asset attributes and transactions at times other than the initial asset conversion.
Fields (2)
Column = COBOL field name without the CVA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CVA-CONVERSION-NBR PKCONVERSION_NBR | Alpha 22 | Required key. This number associates the attribute or transaction with the asset. | AM500 |
CVA-ASSETASSET | Numeric 10 | This is the Lawson-assigned asset number, to be used for attribute conversion at a later date. The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide. | AM500 |
Indexes (2)
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 |
|---|---|---|---|---|
CVASET1 | CONVERSION-NBR | Primary | AM300, AM500, AM93.1, AM94.1 | |
CVASET2 | ASSET, CONVERSION-NBR | AM170, AM40.1 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Amassetcnv | AMASSETCNV | Not Required | CVA-CONVERSION-NBR → ACN-CONVERSION-NBR |
One to many (4) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Amastbkcnv | AMASTBKCNV | CVA-CONVERSION-NBR → ABC-CONVERSION-NBR, ABC-BOOK | ||
| Amastitcnv | AMASTITCNV | CVA-CONVERSION-NBR → ITC-CONVERSION-NBR, ITC-SEQ-NUMBER | ||
| Amastmxcnv | AMASTMXCNV | CVA-CONVERSION-NBR → MCV-CONVERSION-NBR, MCV-MATRIX-CAT | ||
| Amasttrcnv | AMASTTRCNV | CVA-CONVERSION-NBR → TNC-CONVERSION-NBR, TNC-SEQ-NUMBER |