MAELMVALUE – Matching Element Value

System
Matching (MA)
Prefix
MVA
Primary key
ELEMENT, ELEMENT-VALUE
Fields
4
Updated by
1 program
Referenced by
225 programs

MAELMVALUE is the Matching Element Value table in Lawson Matching (prefix MVA). It is indexed by ELEMENT, ELEMENT-VALUE (MVASET1). It is updated by MA00.5 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 217 more. The table has 4 fields, 1 index and 0 documented relations.

About MAELMVALUE

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the MVA- 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
#MVA-ELEMENT PK
ELEMENT
Alpha 20—MA00.5
#MVA-ELEMENT-VALUE PK
ELEMENT_VALUE
Alpha 32—MA00.5
#MVA-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.MA00.5
#MVA-ELEMENT-GROUP
ELEMENT_GROUP
Alpha 10—MA00.5

Indexes (1)

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
MVASET1
  1. ELEMENT
  2. ELEMENT-VALUE
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (1)

Referenced by (225)