Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AUMXVALUE


                             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    AM214     AM220     AM221
AM230     AM240     AM255     AM260     AM267     AM270
AM278     AM280     AM282     AM287     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
Element: Object ID     The unique object identifier.             GL124   GL161
                                                                 GL162   GL20.1
                                                                 GL20.5  GL20.7
                                                                 MX135   MX500

AMV-MATRIX-CAT         Alpha 12                                  GL120   GL124
Element: Matrix CategorAttribute 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
Element: 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  AM214
                                                                 AM220   AM221
                                                                 AM230   AM240
                                                                 AM255   AM260
                                                                 AM267   AM270
                                                                 AM278   AM280
                                                                 AM282   AM287
                                                                 CA10.1  CA10.7
                                                                 GL110   GL120
                                                                 GL191   RW80.1
                                                                 GL124   GL14.8
                                                                 GL161   GL162
                                                                 GL20.1  GL20.5
                                                                 GL20.7  GL220
                                                                 ...

AMVSET2   MATRIX-CAT    KeyChange                                AC34.1  AC35.1
          MX-VALUE                                               AC36.1  AM214
          OBJ-ID                                                 AM220   AM221
                                                                 AM230   AM240
                                                                 AM255   AM260
                                                                 AM267   AM270
                                                                 AM278   AM280
                                                                 AM282   AM287
                                                                 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