Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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

AC03.2    AC03.3    AC03.4    AC03.5    AC03.6    AC13.1
AC13.2    AC13.7    AC13.8    AC135     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    BR10.1    BR20.6    CA10.2    CA190     CA210
GL146     GL147     GL165     GL170     GL190     GL191
GL197     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    SL195

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.

MVL-DESCRIPTION      Alpha 30  (Lower Case)                      MX00.1  MX160
Description          This field displays the description.

                         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  AC13.7
                                                                 AC13.8  AC135
                                                                 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
                                                                 ...

                         MXVALIDATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxcatdef       MXCATDEF     Required

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