Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            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     AM15.1    AM15.2    AM15.3    AM15.4    AM170
AM20.1    AM20.2    AM20.3    AM20.4    AM20.5    AM20.6
AM220     AM221     AM222     AM223     AM224     AM225
AM230     AM235     AM240     AM245     AM250     AM255
AM260     AM265     AM275     AM277     AM280     AM285
AM290     AM292     AM295     AM96.1    AM98.1    MX123

UPDATED BY

AM135     AM192     AM23.1    AM23.2    AM30.1    AM30.2
AM40.1    AM500     AM951     AM952

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MXT-OBJ-ID           Numeric 12                                  AM135   AM220
Oject ID             This is the object identifier. It is        AM221   AM222
                     used to relate transactions back to the     AM223   AM224
                     originating subsystems.                     AM225   AM23.1
                                                                 AM23.2  AM23.3
                                                                 AM230   AM235
                                                                 AM240   AM245
                                                                 AM250   AM255
                                                                 AM260   AM265
                                                                 AM275   AM277
                                                                 AM280   AM285
                                                                 AM290   AM292
                                                                 AM295   AM30.1
                                                                 AM30.2  AM40.1
                                                                 AM500   AM951
                                                                 AM952   MX123

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



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


                         AMASTMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MXTSET1   OBJ-ID                                                 AM115   AM135
          MATRIX-CAT                                             AM15.1  AM15.2
                                                                 AM15.3  AM15.4
                                                                 AM170   AM192
                                                                 AM20.1  AM20.2
                                                                 AM20.3  AM20.4
                                                                 AM20.5  AM20.6
                                                                 AM220   AM221
                                                                 AM222   AM223
                                                                 AM224   AM225
                                                                 AM23.1  AM23.2
                                                                 AM23.3  AM230
                                                                 AM235   AM240
                                                                 AM245   AM250
                                                                 AM255   AM260
                                                                 ...

MXTSET2   MATRIX-CAT                                             AM220   AM221
          MX-VALUE                                               AM222   AM223
          OBJ-ID                                                 AM224   AM225
                                                                 AM23.3  AM230
                                                                 AM235   AM240
                                                                 AM245   AM250
                                                                 AM255   AM260
                                                                 AM265   AM275
                                                                 AM277   AM280
                                                                 AM285   AM290
                                                                 AM292   AM295
                                                                 MX123

                         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