Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            MXCATGPDTL FILE

REFERENCED BY

MX207

UPDATED BY

MX07.1    MX07.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MXL-SYSTEM           Alpha 2                                     MX07.1
System Code          A two-character code representing an
                     application used within the Lawson
                     system. (i.e.: GL = General Ledger, AP =
                     Accounts Payable, etc.)

MXL-MATRIX-CAT-GRP   Alpha 15                                    MX07.1
Matrix Cat Grp

MXL-OBJ-TYPE         Alpha 5                                     MX07.1
Object Type          This field will determine the type of
                     object that is being used by the
                     Attribute. These values are not user
                     maintainable.


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

                         MXCATGPDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MXLSET1   SYSTEM                                                 MX07.1  MX07.2
          MATRIX-CAT-GRP                                         MX207
          OBJ-TYPE
          MATRIX-CAT

MXLSET2   SYSTEM
          OBJ-TYPE
          MATRIX-CAT
          MATRIX-CAT-GRP

                         MXCATGPDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxcatdef       MXCATDEF     Required

                            MXL-MATRIX-CAT        -> MXC-MATRIX-CAT  (MXCSET1)

Mxcatgphdr     MXCATGPHDR   Required

                            MXL-SYSTEM            -> MXG-SYSTEM
                            MXL-MATRIX-CAT-GRP    -> MXG-MATRIX-CAT-GRP

Mxobjcat       MXOBJCAT     Required

                            MXL-OBJ-TYPE          -> MOC-OBJ-TYPE
                            MXL-MATRIX-CAT        -> MOC-MATRIX-CAT