MLMXVALUE – ML Attribute Value
- System
- Multi-Ledger (ML)
- Prefix
MLV- Primary key
OBJ-ID,MATRIX-CAT- Fields
- 3
- Updated by
- 14 programs
- Referenced by
- 2 programs
MLMXVALUE is the ML Attribute Value table in Lawson Multi-Ledger (prefix MLV). It is indexed by OBJ-ID, MATRIX-CAT (MLVSET1). It is related 1:1 to MXCATDEF. It is updated by ML110, ML146, ML190, ML199, ML300, ML40.1, ML40.2, ML40.3 and 6 more and referenced by ML170 and ML240. The table has 3 fields, 1 index and 1 documented relation.
About MLMXVALUE
This file stores the lawson.insight Attribute Matrix (MX) attributes and values for Multi Book Ledger transaction (MLTRN) objects.
Fields (3)
Column = COBOL field name without the MLV- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#MLV-OBJ-ID PKOBJ_ID | Numeric 12 | This is the system-generated object identifier. It connects the attribute to the ledger journal entry record that it is assigned to. | ML146, ML190, ML199, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more |
#MLV-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | The attribute name assigned a Multi Book Ledger entry to track additional information. Attribute values may then be used in selection and sorting for report and analysis | ML146, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8, ML44.1, ML45.1 +1 more |
#MLV-MX-VALUEMX_VALUE | Alpha 32 | The value assigned to a Multi Book Ledger entry (MLTRN) attribute. | ML146, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8, ML44.1, ML45.1 +1 more |
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MLVSET1 |
| Primary | ML110, ML146, ML170, ML190, ML199, ML240, ML300, ML40.1 +7 more |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Mxcatdef | MXCATDEF | Required |
|
Programs
Updated by (14)
- ML110 Ledger Company Copy Delete
- ML146 Batch Ledger Journal Control
- ML190 Ledger Journal Posting
- ML199 Ledger Period Closing
- ML300 Ledger History Delete
- ML40.1 Ledger Journal Entry
- ML40.2 Define Ledger Journal
- ML40.3 Ledger Speed Entry
- ML40.6 Ledger Journal Copy
- ML40.7 Ledger Totals
- ML40.8 Ledger Journal Entry
- ML44.1 Ledger Report Currency Entry
- ML45.1 Ledger Journal Control
- MLIT.1 General Ledger Account Edit