MLRJMXVAL – ML Recurring Attribute Values
- System
- Multi-Ledger (ML)
- Prefix
MRM- Primary key
LEDGER,COMPANY,REC-GROUP,JE-TYPE,LINE-NBR,MATRIX-CAT- Fields
- 7
- Updated by
- 5 programs
- Referenced by
- 2 programs
MLRJMXVAL is the ML Recurring Attribute Values table in Lawson Multi-Ledger (prefix MRM). It is indexed by LEDGER, COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT (MRMSET1). It is related 1:1 to MXCATDEF. It is updated by ML110, ML70.1, ML70.2, ML70.3 and ML70.6 and referenced by ML170 and ML75.1. The table has 7 fields, 1 index and 1 documented relation.
About MLRJMXVAL
The Multi Book Ledger Recurring Journal Attribute Value file contains attribute value information associated with recurring journal entries.
Fields (7)
Column = COBOL field name without the MRM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
MRM-LEDGER PKLEDGER | Alpha 15 | The ledger to which attribute values are posted. | ML110, ML70.1, ML70.2, ML70.3, ML70.6 |
MRM-COMPANY PKCOMPANY | Numeric 4 | The company for which recurring journal entries are posted. It must be linked to the ledger on Ledger Setup (ML10.1). | ML70.1, ML70.2, ML70.3, ML70.6 |
MRM-REC-GROUP PKREC_GROUP | Numeric 8 | The recurring journal entry number. | ML70.1, ML70.2, ML70.3, ML70.6 |
MRM-JE-TYPE PKJE_TYPE | Alpha 1 | The recurring journal entry type (Normal or Intercompany). | ML70.1, ML70.2, ML70.3, ML70.6 |
MRM-LINE-NBR PKLINE_NBR | Numeric 6 | The recurring journal entry line number. | ML70.1, ML70.2, ML70.3, ML70.6 |
MRM-MATRIX-CAT PKMATRIX_CAT | Alpha 12 | The attribute assigned to the recurring journal entry transaction or transaction line. | ML70.1, ML70.2, ML70.3, ML70.6 |
MRM-MX-VALUEMX_VALUE | Alpha 32 | The value assigned to the attribute. | ML70.1, ML70.2, ML70.3, ML70.6 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
MRMSET1 | LEDGER, COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT | Primary | ML110, ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Mxcatdef | MXCATDEF | Not Required | MRM-MATRIX-CAT → MXC-MATRIX-CAT |
Programs
Updated by (5)
- ML110 Ledger Company Copy Delete
- ML70.1 Ledger Recurring Journal
- ML70.2 Define Recurring Journal
- ML70.3 Amounts Only
- ML70.6 Ledger Recurring Copy