Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MXVALREL FILE

The Attribute Valid Value Interface fiel maintans interface records for the
values or value ranges assigned to a 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
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
Sequence Number      A unique number assigned to each record
                     to be interfaced into the Lawson system.

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

MVR-FR-MX-VAL        Alpha 32                                    MX60.1
From Attribute Value The 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.

                         MXVALREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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

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