MXVALIDATE – Attribute Validation

System
General Ledger Setup (IF)
Prefix
MVL
Primary key
MATRIX-CAT, TH-MX-VAL
Fields
4
Updated by
2 programs
Referenced by
203 programs

MXVALIDATE is the Attribute Validation table in Lawson General Ledger Setup (prefix MVL). It is indexed by MATRIX-CAT, TH-MX-VAL (MVLSET1). It is related 1:1 to MXCATDEF and 1:M to ACBLRATEX, GLSCCAT and MXVALIDAU. It is updated by MX00.1 and MX160 and referenced by AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC13.1, AC13.2, AC13.7 and 195 more. The table has 4 fields, 1 index and 4 documented relations.

About MXVALIDATE

This file contains the valid values or value ranges that are assigned to the attribute.

Fields (4)

Column = COBOL field name without the MVL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MVL-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute 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.MX00.1, MX160
MVL-FR-MX-VAL
FR_MX_VAL		Alpha 32The beginning value in a range of values.MX00.1, MX160
MVL-TH-MX-VAL PK
TH_MX_VAL		Alpha 32The ending value in a range of values.MX00.1, MX160
MVL-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.MX00.1, MX160

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MVLSET1MATRIX-CAT, TH-MX-VALPrimaryAC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC13.1, AC13.2, AC13.7 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxcatdefMXCATDEFRequiredMVL-MATRIX-CAT → MXC-MATRIX-CAT

One to many (3) — child tables

RelationTableRulesConditionField map
AcblratexACBLRATEXMVL-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 AdGLSCCATMVL-MATRIX-CAT → GSC-MATRIX-CAT, "AD" → GSC-SOURCE-CODE, → GSC-SEQ-NBR
MxvalidauMXVALIDAUMVL-MATRIX-CAT → MVU-MATRIX-CAT, MVL-TH-MX-VAL → MVU-TH-MX-VAL, → MVU-ACTION, → MVU-DATE, → MVU-TIME, → MVU-UNIQUE-I-D

Programs

Updated by (2)

Referenced by (203)