Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXCATGPDTL


                            MXCATGPDTL FILE

REFERENCED BY

MX207

UPDATED BY

MX07.1    MX07.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MXL-SYSTEM             Alpha 2                                   MX07.1
Element: 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
Element: Matrix Cat Grp

MXL-OBJ-TYPE           Alpha 5                                   MX07.1
Element: 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
Element: 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