Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AMASTMXVAL


                            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

AM120     AM220     AM221     AM222     AM223     AM224
AM225     AM230     AM235     AM240     AM245     AM25.2
AM250     AM255     AM260     AM265     AM267     AM275
AM277     AM278     AM280     AM281     AM285     AM287
AM290     AM292     AM295     AM310     AM320     AM35.1
AM45.1    AM501     AM70.4    AM88.1    AMAS.1    AMBL.1
MX202

UPDATED BY

AM135     AM154     AM192     AM23.1    AM23.2    AM30.1
AM30.2    AM40.1    AM500     MX500     AC160     AM115
AM117     AM15.1    AM15.2    AM15.3    AM15.4    AM170
AM19.1    AM19.2    AM20.1    AM20.2    AM20.3    AM20.4
AM20.5    AM20.6    AM21.1    AM21.2    AM21.3    AM21.4
AM21.5    AM21.6    AM330     AM551     AM96.1    AM98.1
AP115     AP125     AP126     AP131     AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.7    AP21.1    AP220
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.2
AP30.4    AP305     API1.1    API2.1    BL120     BL122
BL130     BL20.1    BL20.3    BL21.2    BL21.5    BL29.1
BL29.2    BL520     BL820     BL92.1    MA180     MA41.1
MA41.2    MA41.4    MA41.7    MA43.1    MA43.2    MA43.3
MA43.4    MA43.6    MA43.7    MA530     MA531     MA60.2
MA60.3    MA60.5    MA61.1    MA63.1    MA65.1    MA66.2
MA66.3    MA67.2    MA67.3    MA68.2    MA68.3    MA68.5
MA70.1    MA75.1    MA80.1    MAI1.1    PD10.1    PD10.2
PD130     PD20.1    PD20.2    PD20.3    PO100     PO101
PO122     PO131     PO20.1    PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO23.1    PO24.1    PO25.1
PO25.5    PO25.6    PO25.7    PO27.2    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.2
PO32.4    PO33.1    PO34.1    PO35.1    PO36.1    PO36.2
PO38.1    PO39.1    PO39.2    PO44.1    PO50.1    PO52.1
PO520     PO536     POI3.1    POID.1    POII.1    POIJ.1
RQ10.1    RQ10.2    WH20.2    WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MXT-OBJ-ID             Numeric 12                                AM135   AM154
Element: 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.                   AM310   AM320
                                                                 AM40.1  AM500
                                                                 AM501   MX500

MXT-MATRIX-CAT         Alpha 12                                  AM135   AM154
Element: 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
Element: Attribute ValuThis 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                                                 AC160   AM115
          MATRIX-CAT                                             AM117   AM120
                                                                 AM135   AM15.1
                                                                 AM15.2  AM15.3
                                                                 AM15.4  AM154
                                                                 AM170   AM19.1
                                                                 AM19.2  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
                                                                 ...

MXTSET2   MATRIX-CAT                                             AM120   AM135
          MX-VALUE                                               AM154   AM220
          OBJ-ID                                                 AM221   AM222
                                                                 AM223   AM224
                                                                 AM225   AM23.3
                                                                 AM230   AM235
                                                                 AM240   AM245
                                                                 AM25.2  AM250
                                                                 AM255   AM260
                                                                 AM265   AM267
                                                                 AM275   AM277
                                                                 AM278   AM280
                                                                 AM281   AM285
                                                                 AM287   AM290
                                                                 AM292   AM295
                                                                 ...

                         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