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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
MX_VALUE		Alpha 32This field contains the matrix attribute values for the lease.MX500

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
LXVSET1
  1. OBJ-ID
  2. MATRIX-CAT
PrimaryMX123, MX202, MX500
LXVSET2
  1. MATRIX-CAT
  2. MX-VALUE
  3. OBJ-ID
KeyChangeMX123, MX202, MX500

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
LMLSEMXAULMLSEMXVAL

One to many (1) — child tables

RelationTableRulesConditionField map
LmlsemxauLMLSEMXAU
LXV-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)