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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
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 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
CVASET1
CONVERSION-NBR
Primary
AM300, AM500, AM93.1, AM94.1
CVASET2
ASSET
CONVERSION-NBR
AM170, AM40.1
Relations
Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
