RJMXVALUE

Recurring Journal Matrix Value

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

REFERENCED BY
GL146 GL170 GL197 GL270 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL75.1
GL14.1 GL14.5 GL14.7 GL14.8 GL16.1 GL16.2
GL16.3 GL16.4 GL20.7 GL20.8 GL20.9 MX00.1
MX00.2 MX00.3 MX05.1 MX05.2 MX06.1 MX06.2
MX10.1 MX10.2 MX135 MX20.1 MX20.2 MX20.4
MX20.5 ML270 SL40.1


UPDATED BY
GL110 GL70.1 GL70.2 GL70.3 GL70.6

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RMV-COMPANY
Element: Company
Numeric 4
The company number as defined in GL10.1 (Company).
GL110 GL70.1
GL70.2 GL70.3
GL70.6
RMV-REC-GROUP
Element: Group
Numeric 8
The recurring journal entry number.
GL70.1 GL70.2
GL70.3 GL70.6
RMV-JE-TYPE
Element: Journal Entry Type
Alpha 1
The type of journal entry. Valid values are Normal and Intercompany.
GL70.1 GL70.2
GL70.3 GL70.6
RMV-LINE-NBR
Element: Line Number
Numeric 6
This field contains the line number.
GL70.1 GL70.2
GL70.3 GL70.6
RMV-MATRIX-CAT
Element: Matrix Category
Alpha 12
Attribute 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
Element: Matrix Value
Alpha 32
Contains the attribute value.
GL70.1 GL70.2
GL70.3 GL70.6


RJMXVALUE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RMVSET1 COMPANY
REC-GROUP
JE-TYPE
LINE-NBR
MATRIX-CAT
...
GL110 GL146
GL170 GL197
GL270 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 GL75.1
GL14.1 GL14.5
GL14.7 GL14.8
GL16.1 GL16.2
GL16.3 GL16.4
GL20.7 GL20.8
GL20.9 MX00.1


RJMXVALUE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Mxcatdef MXCATDEF Not Required
RMV-MATRIX-CAT->MXC-MATRIX-CAT


RJMXVALUE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Rjmxvaluau RJMXVALUAU
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


File created: Thu Jun 09 02:21:05 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.