Lawson Insight Technical Documentation

                            MXVALIDATE FILE

                          Attribute Validation

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


REFERENCED BY

AC03.2    AC03.3    AC03.4    AC03.5    AC03.6    AC13.1
AC13.2    AC170     AC213     AC256     AC40.1    AC40.4
AC41.1    AC41.4    AC42.1    AC45.1    AC50.1    AC500
AC51.1    AC510     AC52.1    AC520     AC530     AC54.1
AC540     AC55.1    AC70.1    AC70.4    AM220     AM221
AM222     AM223     AM224     AM225     AM23.1    AM23.2
AM230     AM235     AM240     AM245     AM250     AM255
AM260     AM265     AM275     AM277     AM278     AM280
AM281     AM285     AM290     AM292     AM295     AM500
AM94.1    BR00.3    BR03.1    BR03.3    CA10.2    CA190
CA210     GL146     GL165     GL170     GL190     GL191
GL199     GL240     GL256     GL265     GL270     GL40.1
GL40.2    GL40.3    GL40.7    GL40.8    GL44.1    GL45.1
GL55.1    GL65.1    GL70.1    GL70.2    GL70.3    GL70.6
GL123     GL124     GL14.5    GL14.7    GL16.1    GL16.2
GL16.3    GL16.4    GL162     GL20.5    GL20.7    GL20.8
GL20.9    GL220     GL262     GL62.1    IFGT.1    MX05.1
MX06.1    MX10.1    MX135     MX201     MX205     MX260
MX500     MX60.1

UPDATED BY

MX00.1    MX160

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

MVL-MATRIX-CAT       Alpha 12                                    MX00.1  MX160
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 32                                    MX00.1  MX160
From Matrix Value    The beginning value in a range of
                     values.


MVL-TH-MX-VAL        Alpha 32                                    MX00.1  MX160
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                                             AC03.2  AC03.3
          TH-MX-VAL                                              AC03.4  AC03.5
                                                                 AC03.6  AC13.1
                                                                 AC13.2  AC170
                                                                 AC213   AC256
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC50.1  AC500
                                                                 AC51.1  AC510
                                                                 AC52.1  AC520
                                                                 AC530   AC54.1
                                                                 AC540   AC55.1
                                                                 AC70.1  AC70.4
                                                                 AM220   AM221
                                                                 ...

                         MXVALIDATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxcatdef       MXCATDEF     Required

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