RJMXVALUAU – Recurring JE Attr Value Audit

System
General Ledger Setup (IF)
Prefix
RVA
Primary key
COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D
Fields
15
Updated by
40 programs
Referenced by
103 programs

RJMXVALUAU is the Recurring JE Attr Value Audit table in Lawson General Ledger Setup (prefix RVA). It is indexed by COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D (RVASET1); alternate indexes: RVASET2, RVASET3, RVASET4, RVASET5 and RVAUID. It is related 1:1 to RJMXVALUE. It is updated by GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 and 32 more and referenced by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 95 more. The table has 15 fields, 6 indexes and 1 documented relation.

About RJMXVALUAU

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the RVA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
RVA-UNIQUE-I-D PK
UNIQUE_I_D		Bad Type 36——
RVA-COMPANY PK
COMPANY		Numeric 4—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-REC-GROUP PK
REC_GROUP		Numeric 8—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-JE-TYPE PK
JE_TYPE		Alpha 1—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-LINE-NBR PK
LINE_NBR		Numeric 6—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-MATRIX-CAT PK
MATRIX_CAT		Alpha 12—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-ACTION PK
ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-OPERATOR
OPERATOR		Alpha 10—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-DATE PK
DATE		Numeric 8 (yyyymmdd)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-TIME PK
TIME		Numeric 6 (hhmmss)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-PROGRAM
PROGRAM		Alpha 5—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-FIELD-NAME
FIELD_NAME		Alpha 20 (Lower Case)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-FIELD-ID
FIELD_ID		Numeric 3—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-OLD-VALUE
OLD_VALUE		Alpha 60 (Lower Case)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more
RVA-NEW-VALUE
NEW_VALUE		Alpha 60 (Lower Case)—GL14.1, GL14.5, GL14.7, GL14.8, GL146, GL16.1, GL16.2, GL16.3 +31 more

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RVASET1COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-DPrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RVASET2COMPANY, JE-TYPE, REC-GROUP, LINE-NBR, MATRIX-CAT, ACTION, DATE, TIME, UNIQUE-I-D—
RVASET3OPERATOR, ACTION, DATE, COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT, UNIQUE-I-D—
RVASET4ACTION, DATE, COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT, UNIQUE-I-D—
RVASET5DATE, COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT, ACTION, UNIQUE-I-DMX278, MX305
RVAUIDUNIQUE-I-D—

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
RjmxvalueRJMXVALUERequiredRVA-COMPANY → RMV-COMPANY (RMVSET1), RVA-REC-GROUP → RMV-REC-GROUP, RVA-JE-TYPE → RMV-JE-TYPE, RVA-LINE-NBR → RMV-LINE-NBR, RVA-MATRIX-CAT → RMV-MATRIX-CAT

Programs

Updated by (40)

Referenced by (103)