Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACACTMXVDT


                            ACACTMXVDT FILE

REFERENCED BY

AC14.6    AC213     AC51.1    MX202     AC135

UPDATED BY

AC13.1    AC13.7    AC13.8    AC300     AC310     AC510
AC560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MXD-OBJ-ID             Numeric 12                                AC13.1  AC13.7
Element: Obj Id        This is the object identifier. It is      AC13.8  AC510
                       used to relate commitments or posted      AC560
                       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.

MXD-MATRIX-CAT         Alpha 12                                  AC13.1  AC13.7
Element: Matrix Cat    Attribute name assigned to an object      AC13.8  AC510
                       (like accounting unit) to track           AC560
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

MXD-MX-VALUE           Alpha 32                                  AC13.1  AC13.7
Element: Mx Value      The attribute value.                      AC13.8  AC510
                                                                 AC560

MXD-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     AC13.1  AC13.7
Element: Effective DateThe date a vendor's prices will be in     AC13.8  AC510
                       effect.                                   AC560

                         ACACTMXVDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MXDSET1   OBJ-ID                                                 AC13.1  AC13.7
          MATRIX-CAT                                             AC13.8  AC14.6
          EFFECTIVE-DATE                                         AC213   AC300
                                                                 AC310   AC51.1
                                                                 AC510   AC560
                                                                 MX202

MXDSET2   MATRIX-CAT                                             MX202
          EFFECTIVE-DATE
          OBJ-ID

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