Lawson Insight Technical Documentation

                             MXCATDEF FILE

REFERENCED BY

LO61.1    LO64.1    LX60.1    LX60.2    LX60.3    LX90.2
LX90.3    LX90.4    LX90.5    LX995     RD30.1    RD50.1
RD70.1

UPDATED BY

LX00.1    LX00.2    LX95.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MXC-MATRIX-CAT         Alpha 14                                  LX00.1  LX00.2
Element: Matrix Cat                                              LX95.1

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

MXC-DESCRIPTION        Alpha 50  (Lower Case)                    LX00.1  LX95.1
Element: Description   This field contains the description.

MXC-COLM-HEADING       Alpha 40  (Lower Case)                    LX00.1  LX95.1
Element: Colm Heading

MXC-HAS-VALIDATION     Alpha 1                                   LX00.1
Element: Has ValidationThis field identifies if valid values
                       have been defined for the category. Yes
                       means there are valid value records and
                       the entered value must cohere.
                       Y = Yes
                       N = No

MXC-DEFAULT-VALUE      Alpha 55  (Lower Case)                    LX00.1
Element: Default Value

MXC-DATA-TYPE          Alpha 1                                   LX00.1  LX00.2
Element: Data Type     This field tells ags what type of         LX95.1
                       field. Such as A (alpha) N (Numeric)
                       A = Alpha
                       N = Numeric
                       D = Date

MXC-FIELD-SIZE         Numeric 3                                 LX00.1  LX00.2
Element: Field Size    This field keeps track of the field       LX95.1
                       size int he application database that is
                       needed for creation of the ags string

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

MXC-TIME               Numeric 6  (hhmmss)                       LX95.1
Element: Time

                         MXCATDEF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MXCSET1   MATRIX-CAT                                             LO61.1  LO64.1
                                                                 LX00.1  LX00.2
                                                                 LX60.1  LX60.2
                                                                 LX60.3  LX90.2
                                                                 LX90.3  LX90.4
                                                                 LX90.5  LX95.1
                                                                 LX995   RD30.1
                                                                 RD50.1  RD70.1

MXCSET2   CATEGORY-TYPE KeyChange                                LX90.3
          MATRIX-CAT

                         MXCATDEF FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lomxvalue      LOMXVALUE

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

Lowdgtattr     LOWDGTATTR   Delete Cascades

                            MXC-MATRIX-CAT    -> LWA-MATRIX-CAT
                                                 LWA-WEB-USER
                                                 LWA-WIDGET-ID

Lowdgtdfat     LOWDGTDFAT   Delete Cascades

                            MXC-MATRIX-CAT    -> LDA-MATRIX-CAT
                                                 LDA-WIDGET-ID

Mxidobjcat     MXIDOBJCAT

                            MXC-MATRIX-CAT    -> IOC-MATRIX-CAT
                                                 IOC-MATRIX-TYPE
                                                 IOC-ID-TYPE

Validation     MXVALIDATE   Delete Cascades

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