Lawson Insight Technical Documentation

                            MXIDOBJCAT FILE

REFERENCED BY

LX80.1    LX90.2    LX90.4    LX90.5    LX995

UPDATED BY

LX00.2    LX60.1    LX60.2    LX60.3    LX95.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

IOC-MATRIX-TYPE        Alpha 10                                  LX00.2  LX60.1
Element: Matrix Type                                             LX60.2  LX60.3
                                                                 LX95.1

IOC-MATRIX-CAT         Alpha 14                                  LX00.2  LX60.1
Element: Matrix Cat                                              LX60.2  LX60.3
                                                                 LX95.1

IOC-ID-TYPE            Alpha 15  (Lower Case)                    LX00.2  LX60.1
Element: Id Type                                                 LX60.2  LX60.3
                                                                 LX95.1

IOC-CATEGORY-TYPE      Alpha 1                                   LX00.2  LX95.1
Element: Category Type L = Lawson
                       U = User

IOC-DEFAULT-VALUE      Alpha 55  (Lower Case)                    LX00.2  LX60.1
Element: Default Value                                           LX60.2  LX60.3

IOC-REQUIRED-OPT       Alpha 1                                   LX00.2  LX60.1
Element: Required Opt  N = No                                    LX60.2  LX60.3
                       Y = Yes                                   LX95.1

IOC-USAGE-COUNT        Numeric 12                                LX00.2  LX60.1
Element: Usage Count                                             LX60.2  LX60.3
                                                                 LX95.1

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

IOC-TIME               Numeric 6  (hhmmss)                       LX00.2  LX60.1
Element: Time                                                    LX60.2  LX60.3
                                                                 LX95.1

IOC-TYPE-RECORD        Derived
Element: Type Record

                         MXIDOBJCAT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

IOCSET1   MATRIX-TYPE                                            LX00.2  LX60.1
          MATRIX-CAT                                             LX60.2  LX60.3
          ID-TYPE                                                LX80.1  LX90.2
                                                                 LX90.4  LX90.5
                                                                 LX95.1

IOCSET2   ID-TYPE                                                LX60.3  LX90.2
          MATRIX-TYPE                                            LX90.4  LX90.5
          MATRIX-CAT

IOCSET3   MATRIX-CAT                                             LX00.1  LX00.2
          MATRIX-TYPE                                            LX95.1  LX995
          ID-TYPE

IOCSET4   CATEGORY-TYPE KeyChange                                LX90.2  LX90.4
          ID-TYPE                                                LX90.5
          MATRIX-TYPE
          MATRIX-CAT

                         MXIDOBJCAT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lomxtypdef     LOMXTYPDEF   Required

                            IOC-MATRIX-TYPE    -> MXD-MATRIX-TYPE

Mxcatdef       MXCATDEF     Required

                            IOC-MATRIX-CAT     -> MXC-MATRIX-CAT

Mxobjcat       MXOBJCAT     Required

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

Sirdtype       SIRDTYPE     Required

                            IOC-ID-TYPE        -> IDT-ID-TYPE

                         MXIDOBJCAT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lomxvalue      LOMXVALUE

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

Mxvalidate     MXVALIDATE

                            IOC-MATRIX-CAT     -> MVL-MATRIX-CAT
                                                  MVL-TH-MX-VAL

Sirdidhdr      SIRDIDHDR

                            IOC-ID-TYPE        -> IDH-ID-TYPE
                                                  IDH-ID