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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RMVSET1COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CATPrimaryGL110, GL146, GL170, GL197, GL270, GL40.1, GL40.2, GL40.3 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
MxcatdefMXCATDEFNot RequiredRMV-MATRIX-CAT → MXC-MATRIX-CAT

One to many (1) — child tables

RelationTableRulesConditionField map
RjmxvaluauRJMXVALUAURMV-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)