Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            MXVALIDATE FILE

                          Attribute Validation

This file contains the valid values or value ranges that are assigned to the
attribute.


REFERENCED BY

AC13.1    AC13.2    AC17.1    AC256     AC40.1    AC41.1
AC42.1    AC50.1    AC500     AC51.1    AC510     AC530
AC54.1    AC540     AC55.1    AM220     AM221     AM222
AM223     AM224     AM225     AM23.1    AM23.2    AM230
AM235     AM240     AM245     AM250     AM255     AM260
AM265     AM275     AM277     AM280     AM285     AM290
AM292     AM295     AM500     AM94.1    CA10.2    CA190
CA210     GL146     GL165     GL170     GL190     GL191
GL199     GL240     GL256     GL265     GL270     GL40.1
GL40.2    GL40.3    GL40.8    GL40.9    GL44.1    GL45.1
GL55.1    GL65.1    GL70.1    GL70.2    GL70.3    GL70.7
GL162     GL20.5    GL20.7    GL220     GL262     GL62.1
IFGT.1    MX05.1    MX10.1    MX201     MX205     MX500
SL00.5    SL00.6    SL40.1

UPDATED BY

MX00.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MVL-MATRIX-CAT       Alpha 12                                    MX00.1
Matrix Category      Attribute name assigned to an object
                     (like an accounting unit) to track
                     additional information.  Attribute
                     values may then be used in selection and
                     sorting for reporting and analysis.


MVL-FR-MX-VAL        Alpha 20                                    MX00.1
From Matrix Value    The beginning value in a range of
                     values.


MVL-TH-MX-VAL        Alpha 20                                    MX00.1
To Matrix Value      The ending value in a range of values.

                         MXVALIDATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MVLSET1   MATRIX-CAT                                             AC13.1  AC13.2
          TH-MX-VAL                                              AC17.1  AC256
                                                                 AC40.1  AC41.1
                                                                 AC42.1  AC50.1
                                                                 AC500   AC51.1
                                                                 AC510   AC530
                                                                 AC54.1  AC540
                                                                 AC55.1  AM220
                                                                 AM221   AM222
                                                                 AM223   AM224
                                                                 AM225   AM23.1
                                                                 AM23.2  AM230
                                                                 AM235   AM240
                                                                 AM245   AM250
                                                                 AM255   AM260
                                                                 ...

                         MXVALIDATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxcatdef       MXCATDEF     Required

                            MVL-MATRIX-CAT    -> MXC-MATRIX-CAT