Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            AMASTMXCNV FILE

                       Asset Attribute Conversion

This file stores asset attribute conversion information. It must be loaded in
a way similar to existing asset conversion files (such as AMASSETCNV).


UPDATED BY

AM500     AM94.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MCV-CONVERSION-NBR   Alpha 22                                    AM94.1
Conversion Number    Required key. This number associates
                     the attribute with the asset. This
                     number can be the Lawson-assigned asset
                     number for use when doing just attribute
                     conversion.


MCV-MATRIX-CAT       Alpha 12                                    AM94.1
Asset Attribute      This is the name of the asset attribute
                     to which you are assigning values. This
                     field is required if you are adding or
                     deleting an asset attribute.


MCV-MX-VALUE         Alpha 32                                    AM94.1
Attribute Value      This is the value to assign to the
                     asset attribute. This field is required
                     if you are adding or deleting an
                     attribute value.


                         AMASTMXCNV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MCVSET1   CONVERSION-NBR                                         AM500   AM94.1
          MATRIX-CAT

                         AMASTMXCNV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amassetcnv     AMASSETCNV   Not Required

                            MCV-CONVERSION-NBR    -> ACN-CONVERSION-NBR

Amcnvasset     AMCNVASSET   Not Required

                            MCV-CONVERSION-NBR    -> CVA-CONVERSION-NBR

                         AMASTMXCNV FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amastbkcnv     AMASTBKCNV

                            MCV-CONVERSION-NBR    -> ABC-CONVERSION-NBR
                                                     ABC-BOOK

Amastitcnv     AMASTITCNV

                            MCV-CONVERSION-NBR    -> ITC-CONVERSION-NBR
                                                     ITC-SEQ-NUMBER

Amasttrcnv     AMASTTRCNV

                            MCV-CONVERSION-NBR    -> TNC-CONVERSION-NBR
                                                     TNC-SEQ-NUMBER