Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACGRPMXVAL


                            ACGRPMXVAL FILE

The ACGRPMXVAL file is the primary file updated by AC13.  It stores the
activity group attributes and assigned values by object ID.

REFERENCED BY

AC01.1    AC105     AC112     AC113     AC120     AC121
AC123     AC145     AC160     AC165     AC190     AC191
AC197     AC198     AC200     AC203     AC206     AC207
AC210     AC213     AC218     AC220     AC240     AC246
AC261     AC265     AC290     AC295     AC298     AC30.3
AC310     AC32.1    AC34.1    AC346     AC35.1    AC36.1
AC400     AC401     AC410     AC412     AC420     AC421
AC440     AC460     AC471     AC472     AC473     AC480
AC490     AC493     AC494     AC55.1    AC580     AC583
AC90.1    AC92.1    AC93.1    AC94.1    AC95.1    ACDM.2
SE90.1    AP211     AR250     AR30.5    AR33.2    BR120
BR121     BR130     BR131     BR140     BR142     BR145
BR165     BR19.2    BR190     BR20.9    BR200     BR202
BR204     BR205     BR210     BR212     BR215     BR220
BR245     BR265     BR300     BR400     BR405     BR430
BR450     BR521     BR530     BR580     BRCC.1    MX123
MX202

UPDATED BY

AC00.1    AC135     AC14.1    AC14.2    AC300     MX500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AGV-OBJ-ID             Numeric 12                                AC135   AC14.1
Object                 This is the object identifier. It is      AC14.2  MX500
Identification         used to relate attributes and attribute
                       values back to the activity group.

AGV-MATRIX-CAT         Alpha 12                                  AC135   AC14.1
Element: Attribute     Attribute name assigned to an object      AC14.2  MX500
                       (like accounting unit) to track
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

AGV-MX-VALUE           Alpha 32                                  AC135   AC14.1
Element: Attribute ValuThe attribute value.                      AC14.2  MX500

                         ACGRPMXVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AGVSET1   OBJ-ID                                                 AC00.1  AC01.1
          MATRIX-CAT                                             AC105   AC112
                                                                 AC113   AC120
                                                                 AC121   AC123
                                                                 AC135   AC14.1
                                                                 AC14.2  AC14.3
                                                                 AC145   AC160
                                                                 AC165   AC190
                                                                 AC191   AC197
                                                                 AC198   AC200
                                                                 AC203   AC206
                                                                 AC207   AC210
                                                                 AC213   AC218
                                                                 AC220   AC240
                                                                 AC246   AC261
                                                                 ...

AGVSET2   MATRIX-CAT    KeyChange                                AC01.1  AC105
          MX-VALUE                                               AC112   AC113
          OBJ-ID                                                 AC120   AC121
                                                                 AC123   AC135
                                                                 AC14.3  AC145
                                                                 AC160   AC165
                                                                 AC190   AC191
                                                                 AC197   AC198
                                                                 AC200   AC203
                                                                 AC206   AC207
                                                                 AC210   AC213
                                                                 AC218   AC220
                                                                 AC240   AC246
                                                                 AC261   AC265
                                                                 AC290   AC295
                                                                 ...