RJMXVALUE – Recurring Journal Matrix Value

System
General Ledger Setup (IF)
Prefix
RMV
Primary key
COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT
Fields
6
Updated by
5 programs
Referenced by
39 programs

RJMXVALUE is the Recurring Journal Matrix Value table in Lawson General Ledger Setup (prefix RMV). It is indexed by COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT (RMVSET1). It is related 1:1 to MXCATDEF and 1:M to RJMXVALUAU. It is updated by GL110, GL70.1, GL70.2, GL70.3 and GL70.6 and referenced by GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 and 31 more. The table has 6 fields, 1 index and 2 documented relations.

About RJMXVALUE

The Recurring Journal Attribute Value file contains attribute value information associated with recurring journal entries.

Fields (6)

Column = COBOL field name without the RMV- 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
#RMV-COMPANY PK
COMPANY		Numeric 4The company number as defined in GL10.1 (Company).GL110, GL70.1, GL70.2, GL70.3, GL70.6
#RMV-REC-GROUP PK
REC_GROUP		Numeric 8The recurring journal entry number.GL70.1, GL70.2, GL70.3, GL70.6
#RMV-JE-TYPE PK
JE_TYPE		Alpha 1The type of journal entry. Valid values are Normal and Intercompany.GL70.1, GL70.2, GL70.3, GL70.6
#RMV-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.GL70.1, GL70.2, GL70.3, GL70.6
#RMV-MATRIX-CAT PK
MATRIX_CAT		Alpha 12Attribute name assigned to an object (like accounting unit) to track additional information. Attribute values may then be used in selection and sorting for report and analysis.GL70.1, GL70.2, GL70.3, GL70.6
#RMV-MX-VALUE
MX_VALUE		Alpha 32Contains the attribute value.GL70.1, GL70.2, GL70.3, GL70.6

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
RMVSET1
  1. COMPANY
  2. REC-GROUP
  3. JE-TYPE
  4. LINE-NBR
  5. MATRIX-CAT
PrimaryGL110, GL146, GL170, GL197, GL270, GL40.1, GL40.2, GL40.3 +22 more (list truncated in source)

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxcatdefMXCATDEFNot Required
RMV-MATRIX-CAT→MXC-MATRIX-CAT

One to many (1) — child tables

RelationTableRulesConditionField map
RjmxvaluauRJMXVALUAU
RMV-COMPANY→RVA-COMPANY
RMV-REC-GROUP→RVA-REC-GROUP
RMV-JE-TYPE→RVA-JE-TYPE
RMV-LINE-NBR→RVA-LINE-NBR
RMV-MATRIX-CAT→RVA-MATRIX-CAT
—→RVA-ACTION
—→RVA-DATE
—→RVA-TIME
—→RVA-UNIQUE-I-D

Programs

Updated by (5)

Referenced by (39)