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
 |