Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACACTMXVDT FILE

REFERENCED BY

AC213     AC51.1    MX202     AC135

UPDATED BY

AC13.7    AC13.8    AC300     AC310     AC510

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MXD-OBJ-ID           Numeric 12                                  AC13.7  AC13.8
Object               This is the object identifier. It is        AC510
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.

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

MXD-MX-VALUE         Alpha 32                                    AC13.7  AC13.8
Attribute Value                                                  AC510

MXD-EFFECTIVE-DATE   Numeric 8  (yyyymmdd)                       AC13.7  AC13.8
Effective Date       The date a vendor's prices will be in       AC510
                     effect.

                         ACACTMXVDT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

MXDSET2   MATRIX-CAT                                             MX202
          EFFECTIVE-DATE
          OBJ-ID

MXDSET3   EFFECTIVE-DATE*
          MATRIX-CAT
          OBJ-ID

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