Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
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
Group                The recurring journal entry number.         GL70.3  GL70.6

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

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

RMV-MATRIX-CAT       Alpha 12                                    GL70.1  GL70.2
Matrix Category      Attribute 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
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.6  GL75.1
          MATRIX-CAT

                         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