Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMCNVASSET


                            AMCNVASSET FILE

                        Asset Conversion Number

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.

REFERENCED BY

AM93.1    AM94.1

UPDATED BY

AM170     AM300     AM500     AM40.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CVA-CONVERSION-NBR     Alpha 22                                  AM500
Element: Conversion NumRequired key. This number associates the
                       attribute or transaction with the asset.

CVA-ASSET              Numeric 10                                AM500
Element: Asset         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.


                         AMCNVASSET FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CVASET1   CONVERSION-NBR                                         AM300   AM500
                                                                 AM93.1  AM94.1

CVASET2   ASSET                                                  AM170   AM40.1
          CONVERSION-NBR

                         AMCNVASSET FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amassetcnv     AMASSETCNV   Not Required

                            CVA-CONVERSION-NBR    -> ACN-CONVERSION-NBR

                         AMCNVASSET FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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