Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACGRPMXVDT


                            ACGRPMXVDT FILE

This file is used to store the effective date values for activity group
attributes.

REFERENCED BY

MX202     AC135

UPDATED BY

AC14.1    AC14.6    AC14.7    AC300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GVD-OBJ-ID             Numeric 12                                AC14.1  AC14.6
Object                 This is the object identifier. It is      AC14.7
Identification         used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

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

GVD-MX-VALUE           Alpha 32                                  AC14.1  AC14.6
Element: Attribute ValuThe attribute value.                      AC14.7

GVD-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     AC14.1  AC14.6
Element: Effective DateThe date the attribute value will take    AC14.7
                       effect.

                         ACGRPMXVDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GVDSET1   OBJ-ID                                                 AC14.1  AC14.6
          MATRIX-CAT                                             AC14.7  AC300
          EFFECTIVE-DATE                                         MX202

GVDSET2   MATRIX-CAT                                             MX202
          EFFECTIVE-DATE
          OBJ-ID

GVDSET3   OBJ-ID                                                 AC135
          MATRIX-CAT
          EFFECTIVE-DATE*