Lawson Insight Technical Documentation

                            AMASTMXVAL FILE

                            Asset Attributes

This file contains the asset attribute information defined in AM23.1 (Asset
Attributes). Attributes capture user-definable additional information about an
asset (i.e., lease, license, and/or insurance information). This file and AM23
 are used in conjunction with the Matrix module where elements, attributes,
templates, attribute values, and lists can be defined. AM23.1 lets you create
attributes, attribute values, and lists.


REFERENCED BY

AM115     AM120     AM15.1    AM15.2    AM15.3    AM15.4
AM170     AM20.1    AM20.2    AM20.3    AM20.4    AM20.5
AM20.6    AM21.1    AM21.2    AM21.3    AM21.4    AM21.5
AM21.6    AM220     AM221     AM222     AM223     AM224
AM225     AM230     AM235     AM240     AM245     AM25.2
AM250     AM255     AM260     AM265     AM275     AM277
AM278     AM280     AM281     AM285     AM290     AM292
AM295     AM320     AM35.1    AM45.1    AM551     AM70.4
AM88.1    AM96.1    AM98.1    AMAS.1    AMBL.1    MX202

UPDATED BY

AM135     AM154     AM192     AM23.1    AM23.2    AM30.1
AM30.2    AM40.1    AM500     MX500

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MXT-OBJ-ID           Numeric 12                                  AM135   AM154
Oject ID             This is the object identifier. It is        AM23.1  AM23.2
                     used to relate transactions back to the     AM30.1  AM30.2
                     originating subsystems.                     AM320   AM40.1
                                                                 AM500   MX500

MXT-MATRIX-CAT       Alpha 12                                    AM135   AM154
Attribute            This is the attribute name assigned to      AM23.1  AM23.2
                     an object to track additional               AM30.1  AM30.2
                     information. Asset attributes are           AM40.1  AM500
                     defined in AC23.1 (Asset Attributes).       MX500
                     Attribute values can be used in
                     selection and sorting for reporting and
                     analysis.



MXT-MX-VALUE         Alpha 32                                    AM135   AM154
Attribute Value      This is the value for the attribute.        AM23.1  AM23.2
                     Asset attributes are defined in AC23.1      AM30.1  AM30.2
                     (Asset Attributes). Values can be           AM40.1  AM500
                     assigned in AM23.2 (Values by Asset         MX500
                     Attributes).


                         AMASTMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MXTSET1   OBJ-ID                                                 AM115   AM120
          MATRIX-CAT                                             AM135   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM21.1  AM21.2
                                                                 AM21.3  AM21.4
                                                                 AM21.5  AM21.6
                                                                 AM220   AM221
                                                                 AM222   AM223
                                                                 AM224   AM225
                                                                 AM23.1  AM23.2
                                                                 ...

MXTSET2   MATRIX-CAT                                             AM120   AM220
          MX-VALUE                                               AM221   AM222
          OBJ-ID                                                 AM223   AM224
                                                                 AM225   AM23.3
                                                                 AM230   AM235
                                                                 AM240   AM245
                                                                 AM25.2  AM250
                                                                 AM255   AM260
                                                                 AM265   AM275
                                                                 AM277   AM278
                                                                 AM280   AM281
                                                                 AM285   AM290
                                                                 AM292   AM295
                                                                 AM320   AM35.1
                                                                 AM45.1  AM70.4
                                                                 ...

                         AMASTMXVAL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Amasset        AMASSET      Required

                            MXT-OBJ-ID        -> AST-OBJ-ID

Mxcatdef       MXCATDEF     Required

                            MXT-MATRIX-CAT    -> MXC-MATRIX-CAT

Mxobjcat       MXOBJCAT     Required

                            "ASSET"           -> MOC-OBJ-TYPE
                            MXT-MATRIX-CAT    -> MOC-MATRIX-CAT