Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RJCONTROL


                             RJCONTROL FILE

                       Recurring Journal Control

This file contains recurring journal entry control information defined in
GL70.1 (Recurring Journal). This information is used to process the recurring
journal entry detail records.


REFERENCED BY

GL179     GL238     GL270     GL275     GLCC.1    GL38.2
IFGT.1

UPDATED BY

AP125     AP126     AP25.1    AP25.2    AP26.1    AP27.1
AP30.2    AP30.4    GL110     GL146     GL170     GL197
GL40.1    GL40.2    GL40.3    GL40.7    GL40.8    GL44.1
GL45.1    GL500     GL70.1    GL70.2    GL70.3    GL70.5
GL70.6    GL75.1    MA61.1    MA70.1    MA75.1    MAI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RJC-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       The company number as defined in GL10.1   AP25.1  AP25.2
                       (Company).                                AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL110   GL146
                                                                 GL197   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL70.2  GL70.6
                                                                 GLCC.1  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-JE-TYPE            Alpha 1                                   AP125   AP126
Element: Journal Entry The type of journal entry. Valid values   AP25.1  AP25.2
                       are Normal and Intercompany.              AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                       N = Normal                                GL146   GL197
                       I = Intercompany                          GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  GLCC.1
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-REC-GROUP          Numeric 8                                 AP125   AP126
Element: Group         The recurring journal entry number.       AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  GLCC.1
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-STATUS             Numeric 1                                 AP125   AP126
Element: Status        This field displays the status of the     AP25.1  AP25.2
                       transaction.                              AP26.1  AP27.1
                       1 = Released                              AP30.2  AP30.4
                       0 = Unreleased                            GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-LINE-NBR           Numeric 6                                 AP125   AP126
Element: Line Number   This field contains the line number.      AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.1
                                                                 GL70.2  GL70.3
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-NBR-LINES          Numeric 6                                 AP125   AP126
Element: Number Lines  This is the number of detail lines.       AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.1
                                                                 GL70.2  GL70.3
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-DESCRIPTION        Alpha 30  (Lower Case)                    AP125   AP126
Element: Description   The recurring journal description.        AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-AUTO-ZERO          Alpha 1                                   AP125   AP126
Element: Auto Zero     This field is used to determine if        AP25.1  AP25.2
                       amounts are to be zeroed out after        AP26.1  AP27.1
                       processing.                               AP30.2  AP30.4
                       N = No                                    GL146   GL197
                       Y = Yes                                   GL40.1  GL40.2
                       R = Rates Only                            GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-POST-PERIOD        Alpha 1 Occurs 13 Times                   AP125   AP126
Element: Post Period   The accounting periods you want to        AP25.1  AP25.2
                       process the recurring journal entry in.   AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-LP-PERIOD          Numeric 2                                 GL170   GL500
Element: Last Post PeriThe period the transaction was last       GL70.1  GL70.2
                       processed.                                GL70.3  GL70.5
                                                                 GL70.6  GL75.1

RJC-LP-YEAR            Numeric 4                                 GL170   GL500
Element: Last Post YearThe year the transaction was last         GL70.1  GL70.2
                       processed.                                GL70.3  GL70.5
                                                                 GL70.6  GL75.1

RJC-BEG-PERIOD         Numeric 2                                 AP125   AP126
Element: Beginning PeriThis is the beginning period that the     AP25.1  AP25.2
                       transaction is posted to.                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-BEG-YEAR           Numeric 4                                 AP125   AP126
Element: Beginning YearThis is the beginning year that the       AP25.1  AP25.2
                       transaction is posted to.                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-END-PERIOD         Numeric 2                                 AP125   AP126
Element: End Period    This is the ending period that the        AP25.1  AP25.2
                       transaction is posted to.                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-END-YEAR           Numeric 4                                 AP125   AP126
Element: End Year      This is the ending year that the          AP25.1  AP25.2
                       transaction is posted to.                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-ENTRY-DEBITS       Signed 18.2                               AP125   AP126
Element: Entry Debits  The total positive detail amounts.        AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-ENTRY-CREDITS      Signed 18.2                               AP125   AP126
Element: Entry Credits The total negative detail amounts.        AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-TRAN-ND            Numeric 1                                 AP125   AP126
Trans Number of        The number of decimal positions defined   AP25.1  AP25.2
Decimals               for the transaction currency.             AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-UNIT-DEBITS        Signed 15.2                               AP125   AP126
Element: Unit Debits   The total positive detail unit amounts.   AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-UNIT-CREDITS       Signed 15.2                               AP125   AP126
Element: Unit Credits  The total negative detail unit amounts.   AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-AUTO-DEBITS        Signed 18.2                               AP125   AP126
Element: Auto Debits   The total positive detail auto            AP25.1  AP25.2
                       reversing amounts.                        AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-AUTO-CREDITS       Signed 18.2                               AP125   AP126
Element: Auto Credits  The total negative detail auto            AP25.1  AP25.2
                       reversing  amounts.                       AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-AUTO-UNIT-DB       Signed 15.2                               AP125   AP126
Element: Auto Unit DebiThe total positive detail auto            AP25.1  AP25.2
                       reversing units amounts.                  AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.1
                                                                 GL70.2  GL70.3
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-AUTO-UNIT-CR       Signed 15.2                               AP125   AP126
Element: Auto Unit CredThe total negative detail auto            AP25.1  AP25.2
                       reversing unit amounts.                   AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.1
                                                                 GL70.2  GL70.3
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-POSTING-DAY        Numeric 2                                 AP125   AP126
Element: Posting Day   This is the day the transaction is        AP25.1  AP25.2
                       posted in the Lawson General Ledger       AP26.1  AP27.1
                       system. If this field is left blank, the  AP30.2  AP30.4
                       period end-date defaults.                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-OPERATOR           Alpha 10                                  AP125   AP126
Element: Operator      This field is used to store the login     AP25.1  AP25.2
                       ID of the person who entered the record.  AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-LAST-CMT-SEQ       Numeric 4                                 AP125   AP126
Last Comment           The sequence number of the last comment   AP25.1  AP25.2
Sequence Number        for the journal entry.                    AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-BASE-ZONE          Alpha 15                                  AP125   AP126
Element: Base Zone     The zone within the Lawson General        AP25.1  AP25.2
                       Ledger system where the transaction       AP26.1  AP27.1
                       originates.                               AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-BASE-DEBITS        Signed 18.2                               AP125   AP126
Element: Base Debits   The total positive detail amount in the   AP25.1  AP25.2
                       company base currency.                    AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-BASE-CREDITS       Signed 18.2                               AP125   AP126
Element: Base Credits  The total negative detail amount in the   AP25.1  AP25.2
                       company base currency.                    AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-BASE-AUTO-DB       Signed 18.2                               AP125   AP126
Element: Base Auto DebiThe total positive detail auto            AP25.1  AP25.2
                       reversing amount in the  company base     AP26.1  AP27.1
                       currency.                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-BASE-AUTO-CR       Signed 18.2                               AP125   AP126
Element: Base Auto CredThe total negative detail auto            AP25.1  AP25.2
                       reversing amount in the company base      AP26.1  AP27.1
                       currency.                                 AP30.2  AP30.4
                                                                 GL146   GL170
                                                                 GL197   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
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-BASE-ND            Numeric 1                                 AP125   AP126
Base Number of         The number of decimal positions defined   AP25.1  AP25.2
Decimals               for the company base currency.            AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-CURRENCY-CODE      Alpha 5                                   AP125   AP126
Element: Currency Code This is the recurring journal entry       AP25.1  AP25.2
                       base currency code. If left blank, the    AP26.1  AP27.1
                       company  base currency defaults.          AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-BASERATE           Signed 14.7                               AP125   AP126
Element: Base Rate     The exchange rate at the time the         AP25.1  AP25.2
                       journal entry was made. If left blank,    AP26.1  AP27.1
                       the current exchange rate will default.   AP30.2  AP30.4
                                                                 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  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-SOURCE-CODE        Alpha 2                                   AP125   AP126
Element: Source Code   A two-character code assigned to a        AP25.1  AP25.2
                       transaction that identifies where the     AP26.1  AP27.1
                       transaction was created.                  AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-AUTO-REV           Alpha 1                                   AP125   AP126
Element: Auto Reverse  When the Auto Reversal field is set to    AP25.1  AP25.2
                       "Y," the Lawson General Ledger Closing    AP26.1  AP27.1
                       program GL199 creates an opposite entry   AP30.2  AP30.4
                       for this transaction in the next period.  GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-REFERENCE          Alpha 10  (Lower Case)                    AP125   AP126
Element: Reference     The reference number associated with      AP25.1  AP25.2
                       the transaction.                          AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 GL70.6  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJC-DOCUMENT-NBR       Alpha 27                                  AP125   AP126
Element: Document NumbeThe document number assigned to the       AP25.1  AP25.2
                       recurring journal entry.                  AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-NET-BASE-AMT       Derived
Element: Net Base AmounThe net base amount.

RJC-NET-BASE-AREV      Derived
Element: Net Base ReverNet base auto-reversed amount.

RJC-JRNL-BOOK-NBR      Alpha 12                                  AP125   AP126
Element: Journal Book NThe journal book assigned to the          AP25.1  AP25.2
                       transaction.                              AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJC-BRIDGE-FLAG        Alpha 1                                   AP125   AP126
Element: Bridge Flag   This field determines the origin of the   AP25.1  AP25.2
                       Recurring Entry. A No value represents    AP26.1  AP27.1
                       that the entry was created through GL70   AP30.2  AP30.4
                       (Recurring Journal). A Yes value          GL146   GL197
                       represents that the entry originated      GL40.1  GL40.2
                       from another system.                      GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                       Y = Yes                                   GL45.1  MA61.1
                       N = No                                    MA70.1  MA75.1
                                                                 MAI1.1

RJC-TRAN-DESC-DFLT     Alpha 1                                   GL70.2
Element: Tran DescriptiThis field determines the description
                       that appears for each transaction line.

                       J = Journal Header
                       P = Prior Transaction Line

RJC-MX-VALUE           Alpha 32 Occurs 3 Times                   GL70.2
Element: Matrix Value  The attribute value associated with the
                       recurring journal.


RJC-TRANS-DAY          Numeric 2                                 GL70.2  GL70.6
Element: Posting Day   This field contains the journal entry
                       transaction day.

RJC-BLANK              Derived
Element: Blank         This derived field is always blank. It
                       is used in the Drill Around feature for
                       column headings.

                         RJCONTROL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RJCSET1   COMPANY                                                AP125   AP126
          JE-TYPE                                                AP25.1  AP25.2
          REC-GROUP                                              AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL110   GL146
                                                                 GL170   GL179
                                                                 GL197   GL238
                                                                 GL270   GL275
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GL70.1  GL70.2
                                                                 GL70.3  GL70.5
                                                                 GL70.6  GL75.1
                                                                 ...

                         RJCONTROL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apapdhist Orig APAPDHIST    Required
                            When RJB-OBJ-TYPE = "APDST"

                            RJB-OBJ-ID       -> AH2-DST-OBJ-ID

Apdistrib Orig APDISTRIB    Not Required
                            Valid When RJB-OBJ-TYPE = "APDST"

                            RJB-OBJ-ID       -> APD-DST-OBJ-ID

Company        GLSYSTEM     Required

                            RJC-COMPANY      -> GLS-COMPANY

Gltrans Orig   GLTRANS      Not Required
                            Valid When RJB-OBJ-TYPE = "GLTRN"

                            RJB-OBJ-ID       -> GLT-OBJ-ID

Rjbridge       RJBRIDGE     Not Required

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

                         RJCONTROL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Rjschedule     RJSCHEDULE

                            RJB-OBJ-TYPE     -> RJS-OBJ-TYPE
                            RJB-OBJ-ID       -> RJS-OBJ-ID
                                                RJS-FISCAL-YEAR
                                                RJS-ACCT-PERIOD

Rjtrans        RJTRANS      Delete Cascades

                            RJC-COMPANY      -> RJT-COMPANY
                            RJC-REC-GROUP    -> RJT-REC-GROUP
                            RJC-JE-TYPE      -> RJT-JE-TYPE
                                                RJT-LINE-NBR