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 at times other than the initial asset conversion.


REFERENCED BY

AM94.1

UPDATED BY

AM170     AM300     AM40.1    AM500

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CVA-CONVERSION-NBR   Alpha 10                                    AM500
Conversion Number    Required key. This number associates
                     the attribute 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
                                                                 AM94.1

CVASET2   ASSET                                                  AM170   AM40.1
          CONVERSION-NBR                                         AM500

                         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