Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXVALIDATE


                            MXVALIDATE FILE

UPDATED BY

LX00.1    LX00.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MVL-MATRIX-CAT         Alpha 14                                  LX00.1
Element: Matrix Cat

MVL-FR-MX-VAL          Alpha 55  (Lower Case)                    LX00.1
Element: Fr Mx Val

MVL-TH-MX-VAL          Alpha 55  (Lower Case)                    LX00.1
Element: Th Mx Val

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

MVL-TIME               Numeric 6  (hhmmss)                       LX00.1
Element: Time

                         MXVALIDATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MVLSET1   MATRIX-CAT                                             LX00.1  LX00.2
          TH-MX-VAL

                         MXVALIDATE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lomxvalue      LOMXVALUE

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

Mxidobjcat     MXIDOBJCAT

                            MVL-MATRIX-CAT    -> IOC-MATRIX-CAT
                                                 IOC-MATRIX-TYPE
                                                 IOC-ID-TYPE