MXVALREL – Attribute Value Interface
- System
- General Ledger Setup (IF)
- Prefix
MVR- Primary key
RUN-GROUP,SEQ-NUMBER- Fields
- 6
- Updated by
- 2 programs
- Referenced by
- 1 program
MXVALREL is the Attribute Value Interface table in Lawson General Ledger Setup (prefix MVR). It is indexed by RUN-GROUP, SEQ-NUMBER (MVRSET1); alternate indexes: MVRSET2 and MVRSET3. It is updated by MX160 and MX60.1 and referenced by MX260. The table has 6 fields, 3 indexes and 0 documented relations.
About MXVALREL
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).
Fields (6)
Column = COBOL field name without the MVR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MVR-RUN-GROUP PKRUN_GROUP | Alpha 15 | Run Group and Seq Number are the keys to the file. They identify the group of records to be interfaced. | MX60.1 |
MVR-SEQ-NUMBER PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each record to be interfaced into the Lawson system. | MX60.1 |
MVR-MATRIX-CATMATRIX_CAT | Alpha 12 | The attribute for which valies are being uploaded. It must exist in the MXCATDEF file. | MX60.1 |
MVR-FR-MX-VALFR_MX_VAL | Alpha 32 | The begining value of a range of values assigned to the attribute. | MX60.1 |
MVR-TH-MX-VALTH_MX_VAL | Alpha 32 | The ending value of a range of values assigned to the attribute. | MX160, MX60.1 |
MVR-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | The description of the attribute valid value(s) record. | MX60.1 |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MVRSET1 | RUN-GROUP, SEQ-NUMBER | Primary | MX160, MX260, MX60.1 | |
MVRSET2 | MATRIX-CAT, TH-MX-VAL, RUN-GROUP, SEQ-NUMBER | KeyChange | MX160, MX260, MX60.1 | |
MVRSET3 | RUN-GROUP, MATRIX-CAT, TH-MX-VAL, SEQ-NUMBER | KeyChange | MX160, MX260 |
Programs
Updated by (2)
Referenced by (1)
- MX260 Attribute Valid Value Listing