Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXOBJCAT


                             MXOBJCAT FILE

REFERENCED BY

LX60.1    LX60.2    LX60.3

UPDATED BY

LX65.1    LX65.2    LX65.3    LX95.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MOC-MATRIX-TYPE        Alpha 10                                  LX65.1  LX65.2
Element: Matrix Type                                             LX65.3  LX95.1

MOC-ID-TYPE            Alpha 15  (Lower Case)                    LX65.1  LX65.2
Element: Id Type                                                 LX65.3  LX95.1

MOC-REQUIRED-OPT       Alpha 1                                   LX65.1  LX65.2
Element: Required Opt  N = No                                    LX65.3  LX95.1
                       Y = Yes

MOC-USAGE-COUNT        Numeric 12                                LX65.1  LX65.2
Element: Usage Count                                             LX65.3  LX95.1

MOC-DATE               Numeric 8  (yyyymmdd)                     LX65.1  LX65.2
Element: Date          This field contains the system date       LX65.3  LX95.1
                       when this was created.

MOC-TIME               Numeric 6  (hhmmss)                       LX65.1  LX65.2
Element: Time                                                    LX65.3  LX95.1

MOC-TYPE-RECORD        Derived
Element: Type Record

                         MXOBJCAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MOCSET1   MATRIX-TYPE                                            LX60.1  LX60.2
          ID-TYPE                                                LX60.3  LX65.1
                                                                 LX65.2  LX65.3
                                                                 LX95.1

MOCSET2   ID-TYPE                                                LX65.3
          MATRIX-TYPE

MOCSET3   ID-TYPE       KeyChange, Subset
          MATRIX-TYPE   Where (REQUIRED-OPT = "Y" )

                         MXOBJCAT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lomxtypdef     LOMXTYPDEF   Required

                            MOC-MATRIX-TYPE    -> MXD-MATRIX-TYPE  (MXDSET1)

Sirdtype       SIRDTYPE     Required

                            MOC-ID-TYPE        -> IDT-ID-TYPE

                         MXOBJCAT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lomxvalue      LOMXVALUE

                            MOC-MATRIX-TYPE    -> LMV-MATRIX-TYPE
                                                  LMV-MATRIX-CAT
                                                  LMV-OBJ-ID

Mxidobjcat     MXIDOBJCAT

                            MOC-ID-TYPE        -> IOC-ID-TYPE
                            MOC-MATRIX-TYPE    -> IOC-MATRIX-TYPE
                                                  IOC-MATRIX-CAT

Sirdidhdr      SIRDIDHDR

                            MOC-ID-TYPE        -> IDH-ID-TYPE
                                                  IDH-ID