Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
Conversion Number    Required key. This number associates the
                     attribute or transaction with the asset.

CVA-ASSET            Numeric 10                                  AM500
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