LMLSEMXVAL – Lease Attribute Validation

System
LM (LM)
Prefix
LXV
Primary key
OBJ-ID, MATRIX-CAT
Fields
3
Updated by
1 program
Referenced by
2 programs

LMLSEMXVAL is the Lease Attribute Validation table in Lawson LM (prefix LXV). It is indexed by OBJ-ID, MATRIX-CAT (LXVSET1); alternate indexes: LXVSET2. It is related 1:M to LMLSEMXAU. It is updated by MX500 and referenced by MX123 and MX202. The table has 3 fields, 2 indexes and 1 documented relation.

About LMLSEMXVAL

This file stores the LAWSON INSIGHT II Attribute Matrix (MX) attributes and values for lease objects.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
LXV-OBJ-ID PK
OBJ_ID		Numeric 12This is the system-generated object identifier. It connects the attribute to the lease record that it is assigned to.MX500
LXV-MATRIX-CAT PK
MATRIX_CAT		Alpha 12This field contains the matrix attribute categories for the lease. Attribute categories are attribute names assigned to an object (like a lease) additional information. Attribute values may then be used in selection and sorting for report and analysis.MX500
LXV-MX-VALUE
MX_VALUE		Alpha 32This field contains the matrix attribute values for the lease.MX500

Indexes (2)

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

IndexKeysFlagsConditionUsed in
LXVSET1OBJ-ID, MATRIX-CATPrimaryMX123, MX202, MX500
LXVSET2MATRIX-CAT, MX-VALUE, OBJ-IDKeyChangeMX123, MX202, MX500

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
LmlsemxauLMLSEMXAULXV-OBJ-ID → LXA-OBJ-ID, LXV-MATRIX-CAT → LXA-MATRIX-CAT, → LXA-COMPANY, → LXA-LEASE, → LXA-ACTION, → LXA-DATE, → LXA-TIME, → LXA-UNIQUE-I-D

Programs

Updated by (1)

Referenced by (2)