Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RJENCUMB


                             RJENCUMB FILE

                     Recurring Journal Encumbrance

This file contains the recurring journal transaction line detail information
that links the recurring journal entry to the matching RJ GLCOMMITX records.

UPDATED BY

GL170     GL70.1    GL70.2    GL70.3    GL70.5    GL70.6
GL75.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RJE-COMPANY            Numeric 4                                 GL170   GL70.1
Element: Company       The company number represents an          GL70.2  GL70.3
                       established company and is maintained on  GL70.5  GL70.6
                       GL10.                                     GL75.1

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

RJE-REC-GROUP          Numeric 8                                 GL170   GL70.1
Element: Rec Group     The recurring journal entry number.       GL70.2  GL70.3
                                                                 GL70.5  GL70.6
                                                                 GL75.1

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

RJE-FISCAL-YEAR        Numeric 4                                 GL170   GL70.1
Element: Last Closed YeThis is the fiscal year for the record.   GL70.2  GL70.3
                                                                 GL70.5  GL70.6
                                                                 GL75.1

RJE-PERIOD             Numeric 2                                 GL170   GL70.1
Element: Last Closed PeThis is the period for the record.        GL70.2  GL70.3
                                                                 GL70.5  GL70.6
                                                                 GL75.1

RJE-ACCT-UNIT          Alpha 15                                  GL170   GL70.1
Element: Accounting UniThe accounting unit is a shorthand        GL70.2  GL70.3
                       notation representing the variable level  GL70.5  GL70.6
                       number. The accounting unit entered in    GL75.1
                       this field must be defined in the
                       General Ledger Names file as a posting
                       accounting unit.

RJE-ACCOUNT            Numeric 6                                 GL170   GL70.1
Element: Account       This field along with the accounting      GL70.2  GL70.3
                       unit and subaccount make up the location  GL70.5  GL70.6
                       (account) where amounts and other         GL75.1
                       account information is stored.

RJE-SUB-ACCOUNT        Numeric 4                                 GL170   GL70.1
Element: Subaccount    This field along with the accounting      GL70.2  GL70.3
                       unit and account make up the location     GL70.5  GL70.6
                       (account) where amounts and other         GL75.1
                       account information is stored.

RJE-GLT-OBJ-ID         Numeric 12                                GL170   GL70.1
Object                 This field contains the object ID         GL70.2  GL70.3
Identification         sequence number.                          GL70.5  GL70.6
                                                                 GL75.1

                         RJENCUMB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RJESET1   GLT-OBJ-ID

RJESET2   COMPANY                                                GL170   GL70.1
          JE-TYPE                                                GL70.2  GL70.3
          REC-GROUP                                              GL70.5  GL70.6
          LINE-NBR                                               GL75.1
          FISCAL-YEAR
          PERIOD

                         RJENCUMB FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcommitx      GLCOMMITX    Required

                            RJE-GLT-OBJ-ID    -> GOX-GLT-OBJ-ID

Rjcontrol      RJCONTROL    Required

                            RJE-COMPANY       -> RJC-COMPANY
                            RJE-JE-TYPE       -> RJC-JE-TYPE
                            RJE-REC-GROUP     -> RJC-REC-GROUP