Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RJMXVALUE


                             RJMXVALUE FILE

                     Recurring Journal Matrix Value

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


REFERENCED BY

GL170     GL270     GL75.1

UPDATED BY

GL110     GL70.1    GL70.2    GL70.3    GL70.6

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RMV-COMPANY            Numeric 4                                 GL110   GL70.1
Element: Company       The company number as defined in GL10.1   GL70.2  GL70.3
                       (Company).                                GL70.6


RMV-REC-GROUP          Numeric 8                                 GL70.1  GL70.2
Element: Group         The recurring journal entry number.       GL70.3  GL70.6

RMV-JE-TYPE            Alpha 1                                   GL70.1  GL70.2
Element: Journal Entry The type of journal entry. Valid values   GL70.3  GL70.6
                       are Normal and Intercompany.

RMV-LINE-NBR           Numeric 6                                 GL70.1  GL70.2
Element: Line Number   This field contains the line number.      GL70.3  GL70.6

RMV-MATRIX-CAT         Alpha 12                                  GL70.1  GL70.2
Element: Matrix CategorAttribute name assigned to an object      GL70.3  GL70.6
                       (like accounting unit) to track
                       additional information.  Attribute
                       values may then be used in selection and
                       sorting for report and analysis.

RMV-MX-VALUE           Alpha 32                                  GL70.1  GL70.2
Element: Matrix Value  Contains the attribute value.             GL70.3  GL70.6

                         RJMXVALUE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RMVSET1   COMPANY                                                GL110   GL170
          REC-GROUP                                              GL270   GL70.1
          JE-TYPE                                                GL70.2  GL70.3
          LINE-NBR                                               GL70.5  GL70.6
          MATRIX-CAT                                             GL75.1

                         RJMXVALUE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Mxcatdef       MXCATDEF     Not Required

                            RMV-MATRIX-CAT    -> MXC-MATRIX-CAT