Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MXVALREL


                             MXVALREL FILE

The Attribute Valid Value Interface file maintains interface records for the
values or value ranges assigned to an attribute.  These values are imported
from a non-Lawson file. The contents of the file can be reviewed and edited
online, using Attribute Valid Value Adjustment (MX60.1).

REFERENCED BY

MX260

UPDATED BY

MX160     MX60.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MVR-RUN-GROUP          Alpha 15                                  MX60.1
Element: Run Group     Run Group and Seq Number are the keys to
                       the file.  They identify the group of
                       records to be interfaced.

MVR-SEQ-NUMBER         Numeric 6                                 MX60.1
Element: Sequence NumbeA unique number assigned to each record
                       to be interfaced into the Lawson system.

MVR-MATRIX-CAT         Alpha 12                                  MX60.1
Element: Attribute     The attribute for which valies are being
                       uploaded. It must exist in the MXCATDEF
                       file.

MVR-FR-MX-VAL          Alpha 32                                  MX60.1
Element: From AttributeThe begining value of a range of values
                       assigned to the attribute.

MVR-TH-MX-VAL          Alpha 32                                  MX160   MX60.1
Through Attribute      The ending value of a range of values
Value                  assigned to the attribute.

MVR-DESCRIPTION        Alpha 30  (Lower Case)                    MX60.1
Element: Description   The description of the attribute valid
                       value(s) record.

                         MXVALREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MVRSET1   RUN-GROUP                                              MX160   MX260
          SEQ-NUMBER                                             MX60.1

MVRSET2   MATRIX-CAT    KeyChange                                MX160   MX260
          TH-MX-VAL                                              MX60.1
          RUN-GROUP
          SEQ-NUMBER

MVRSET3   RUN-GROUP     KeyChange                                MX160   MX260
          MATRIX-CAT
          TH-MX-VAL
          SEQ-NUMBER