Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXVALIDATE


                            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     AC14.1    AC14.2
AC14.6    AC14.7    AC16.1    AC16.2    AC16.7    AC16.8
AC16.9    AC213     AC256     AC40.1    AC40.4    AC41.1
AC41.4    AC42.1    AC45.1    AC50.1    AC500     AC51.1
AC510     AC52.1    AC520     AC54.1    AC540     AC55.1
AC558     AC560     AC58.3    AC58.4    ACAC.1    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    AP03.1    AP03.2    AP162     AP262
AP62.1    AR23.1    AR23.2    AR251     AR30.1    AR33.1
AR39.1    AR42.2    AR42.8    AR502     AR515     AR560
AR72.1    BR00.3    BR03.1    BR03.3    BR10.7    BR20.6
BR43.1    BR44.1    CB01.4    CB01.5    CB162     CB262
CB62.1    ET540     ET700     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
IC02.3    IC02.4    ICBL.1    ICBL.2    ICBL.3    ICLM.1
ICLM.3    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    IFBO.1
IFGT.1    MX05.1    MX06.1    MX10.1    MX100     MX123
MX135     MX201     MX205     MX260     MX500     MX60.1
PA495     PO04.5    PO04.6    POBL.1    POBL.3    PW110
PW510     RQ01.2    RQ01.3    RQBL.3    SL00.5    SL00.6
SL40.1

UPDATED BY

MX00.1    MX160

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MVL-MATRIX-CAT         Alpha 12                                  MX00.1  MX160
Element: Matrix CategorAttribute 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
Element: From Matrix VaThe beginning value in a range of
                       values.


MVL-TH-MX-VAL          Alpha 32                                  MX00.1  MX160
Element: To Matrix ValuThe ending value in a range of values.

MVL-DESCRIPTION        Alpha 30  (Lower Case)                    MX00.1  MX160
Element: 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
                                                                 AC14.1  AC14.2
                                                                 AC14.6  AC14.7
                                                                 AC16.1  AC16.2
                                                                 AC16.7  AC16.8
                                                                 AC16.9  AC213
                                                                 AC256   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC50.1
                                                                 AC500   AC51.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

                         MXVALIDATE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acblratex      ACBLRATEX

                            MVL-MATRIX-CAT    -> ALX-MATRIX-CAT
                                                 ALX-ACTIVITY
                                                 ALX-SUM-ACCT-CAT
                                                 ALX-CTR-CAT-GRP
                                                 ALX-ACCT-CATEGORY
                                                 ALX-SOURCE-CODE
                                                 ALX-EFFECTIVE-DT
                                                 ALX-MX-VALUE

Glsscat Ad     GLSCCAT

                            MVL-MATRIX-CAT    -> GSC-MATRIX-CAT
                            "AD"              -> GSC-SOURCE-CODE
                                                 GSC-SEQ-NBR