Lawson Insight Technical Documentation

                             AUMXVALUE FILE

                       Acct Unit Attribute Value

This file contains accounting unit attribute category information that is
used to build an attribute list.


REFERENCED BY

AC34.1    AC35.1    AC36.1    AM220     AM221     AM230
AM240     AM255     AM260     AM270     AM278     AM280
AM282     CA10.1    CA10.7    GL191     RW80.1    GL14.8
GL220     GL62.1    GLBL.1    IFBO.1    MX202

UPDATED BY

GL110     GL120     GL124     GL161     GL162     GL20.1
GL20.5    GL20.7    MX135     MX500

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AMV-OBJ-ID           Numeric 12                                  GL110   GL120
Object ID            The unique object identifier.               GL124   GL161
                                                                 GL162   GL20.1
                                                                 GL20.5  GL20.7
                                                                 MX135   MX500

AMV-MATRIX-CAT       Alpha 12                                    GL120   GL124
Matrix Category      Attribute name assigned to an object        GL161   GL162
                     (like an accounting unit) to track          GL20.1  GL20.5
                     additional information. Attribute values    GL20.7  MX135
                     may then be used in selection and           MX500
                     sorting for reporting and analysis.


AMV-MX-VALUE         Alpha 32                                    GL120   GL124
Matrix Value         The category value assigned to the          GL161   GL162
                     object.                                     GL20.1  GL20.5
                                                                 GL20.7  MX135
                                                                 MX500

                         AUMXVALUE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AMVSET1   OBJ-ID                                                 AC34.1  AC35.1
          MATRIX-CAT                                             AC36.1  AM220
                                                                 AM221   AM230
                                                                 AM240   AM255
                                                                 AM260   AM270
                                                                 AM278   AM280
                                                                 AM282   CA10.1
                                                                 CA10.7  GL110
                                                                 GL120   GL191
                                                                 RW80.1  GL124
                                                                 GL14.8  GL161
                                                                 GL162   GL20.1
                                                                 GL20.5  GL20.7
                                                                 GL220   GL62.1
                                                                 GLBL.1  IFBO.1
                                                                 ...

AMVSET2   MATRIX-CAT    KeyChange                                AC34.1  AC35.1
          MX-VALUE                                               AC36.1  AM220
          OBJ-ID                                                 AM221   AM230
                                                                 AM240   AM255
                                                                 AM260   AM270
                                                                 AM278   AM280
                                                                 AM282   CA10.1
                                                                 CA10.7  GL191
                                                                 RW80.1  GLBL.1
                                                                 MX202

AMVSET3   OBJ-ID        Subset                                   GL20.1
          MATRIX-CAT    Where MATRIX-CAT != "LVL 1 VALUE "
                        And   MATRIX-CAT != "LVL 2 VALUE "
                        And   MATRIX-CAT != "LVL 3 VALUE "
                        And   MATRIX-CAT != "LVL 4 VALUE "
                        And   MATRIX-CAT != "LVL 5 VALUE "

                         AUMXVALUE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Unit      GLNAMES      Not Required

                            AMV-OBJ-ID        -> GLN-OBJ-ID

Glnames        GLNAMES      Not Required

                            AMV-OBJ-ID        -> GLN-OBJ-ID

Matrix Cat     MXOBJCAT     Required

                            "ACCTU"           -> MOC-OBJ-TYPE
                            AMV-MATRIX-CAT    -> MOC-MATRIX-CAT

Mxcatdef       MXCATDEF     Required

                            AMV-MATRIX-CAT    -> MXC-MATRIX-CAT

                         AUMXVALUE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Same Value     AUMXVALUE

                            AMV-MATRIX-CAT    -> AMV-MATRIX-CAT
                            AMV-MX-VALUE      -> AMV-MX-VALUE
                                                 AMV-OBJ-ID