Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RJBRIDGE


                             RJBRIDGE FILE

                        Recurring Journal Bridge

The Recurring Journal Bridge file contains recurring journal interface
information that is used by the Journal Entry programs.


REFERENCED BY

GL238     GL270     GL275     GL500

UPDATED BY

AP125     AP126     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP21.1    AP23.1    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    GL70.1    GL70.2    GL70.3
GL70.5    GL70.6    GL75.1    GL38.2    MA41.1    MA41.2
MA41.4    MA41.7    MA43.2    MA61.1    MA70.1    MA75.1
MAI1.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RJB-OBJ-TYPE           Alpha 5                                   AP125   AP126
Element: Object Type   This field determines the type of         AP20.1  AP20.2
                       object used by the attribute. These       AP20.3  AP20.4
                       values are not user maintainable.         AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-OBJ-ID             Numeric 12                                AP125   AP126
Element: Object ID     Contains the object ID.                   AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 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
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJB-COMPANY            Numeric 4                                 AP125   AP126
Element: Company       The company number as defined in GL10.1   AP20.1  AP20.2
                       (Company).                                AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 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
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJB-JE-TYPE            Alpha 1                                   AP125   AP126
Element: Journal Entry The type of journal entry. Valid values   AP20.1  AP20.2
                       are Normal and Intercompany.              AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                       N = Normal                                AP21.1  AP23.1
                       I = Intercompany                          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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-REC-GROUP          Numeric 8                                 AP125   AP126
Element: Group         The recurring journal entry number.       AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-FR-ACCT-UNIT       Alpha 15                                  AP125   AP126
Element: From AccountinThis is the beginning accounting unit     AP20.1  AP20.2
                       for a range of accounting units.          AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-FR-ACCOUNT         Numeric 6                                 AP125   AP126
Element: From Account  This field along with the accounting      AP20.1  AP20.2
                       unit and subaccount make up the location  AP20.3  AP20.4
                       (account) where amounts and other         AP20.5  AP20.7
                       account information is stored.            AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-FR-SUB-ACCT        Numeric 4                                 AP125   AP126
Element: From SubaccounThis field contains the subaccount from   AP20.1  AP20.2
                       your general ledger chart of accounts     AP20.3  AP20.4
                       that was charged with the amount carried  AP20.5  AP20.7
                       on this record.                           AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-FR-ACTIVITY        Alpha 15                                  AP125   AP126
Element: Activity      This is the beginning activity for a      AP20.1  AP20.2
                       range of activities.                      AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-FR-ACCT-CAT        Alpha 5                                   AP125   AP126
Element: Acct Category This is the beginning account category    AP20.1  AP20.2
                       for a range of account categories.        AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-DEBIT-CREDIT       Alpha 1                                   AP125   AP126
Element: Debit - CreditIndicates a debit or credit amount.       AP20.1  AP20.2
                       D = Debit                                 AP20.3  AP20.4
                       C = Credit                                AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TO-COMPANY         Numeric 4                                 AP125   AP126
Element: To Company    The company number that the recurring     AP20.1  AP20.2
                       journal is posted to.                     AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TO-ACCT-UNIT       Alpha 15                                  AP125   AP126
Element: To Accounting The accounting unit the recurring         AP20.1  AP20.2
                       journal is posted to.                     AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TO-ACCOUNT         Numeric 6                                 AP125   AP126
Element: To Account    The account number that the recurring     AP20.1  AP20.2
                       journal is posted  to.                    AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TO-SUB-ACCT        Numeric 4                                 AP125   AP126
Element: To Subaccount The subaccount that the recurring         AP20.1  AP20.2
                       journal is posted to.                     AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TO-ACTIVITY        Alpha 15                                  AP125   AP126
Element: Activity      The ending activity in a range of         AP20.1  AP20.2
                       activities.                               AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TO-ACCT-CAT        Alpha 5                                   AP125   AP126
Element: Acct Category The ending activity in a range of         AP20.1  AP20.2
                       activities.                               AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TRANS-AMOUNT       Signed 18.2                               AP125   AP126
Element: Trans Amount                                            AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TRANS-ND           Numeric 1                                 AP125   AP126
Trans Number of        The transaction number of decimals.       AP20.1  AP20.2
Decimals                                                         AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-BASE-AMOUNT        Signed 18.2                               AP125   AP126
Element: Base Amount   The base amount to be posted to the       AP20.1  AP20.2
                       General Ledger Master file.               AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-BASE-ND            Numeric 1                                 AP125   AP126
Base Number of         The number of decimal positions defined   AP20.1  AP20.2
Decimals               for the company base currency.            AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-UNITS-AMOUNT       Signed 15.2                               AP125   AP126
Element: Units Amount  Contains the transaction units amount.    AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-SCHEDULE-AMT       Signed 18.2                               AP125   AP126
Element: Schedule AmounContains the recurring journal            AP20.1  AP20.2
                       scheduled amount.                         AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL38.2  GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJB-SCHEDULE-UNITS     Signed 15.2                               AP125   AP126
Element: Schedule UnitsContains the recurring journal            AP20.1  AP20.2
                       scheduled units amount.                   AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 GL146   GL197
                                                                 GL38.2  GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJB-UPDATED-AMT        Signed 18.2                               AP125   AP126
Element: Updated AmountContains the recurring journal updated    AP20.1  AP20.2
                       amount.                                   AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJB-UPDATED-UNITS      Signed 18.2                               AP125   AP126
Element: Updated Units Contains the recurring journal updated    AP20.1  AP20.2
                       units amount.                             AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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
                                                                 MA41.1  MA41.2
                                                                 MA41.4  MA41.7
                                                                 MA43.2  MA61.1
                                                                 MA70.1  MA75.1
                                                                 MAI1.1

RJB-PERIOD-AMOUNT      Signed 18.2                               AP125   AP126
Element: Period Amount Contains the recurring journal period     AP20.1  AP20.2
                       amount.                                   AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-PERIOD-ND          Numeric 1                                 AP125   AP126
Period Number of       Contains the period number of decimals.   AP20.1  AP20.2
Decimals                                                         AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-PERIOD-UNITS       Signed 15.2                               AP125   AP126
Element: Period Units  Contains the recurring journal period     AP20.1  AP20.2
                       units amount.                             AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TRANS-STATUS       Alpha 1                                   AP125   AP126
Element: Trans Status  Contains the transaction status.          AP20.1  AP20.2
                       0 = Unreleased                            AP20.3  AP20.4
                       1 = Released                              AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-FR-SEG-BLOCK       Alpha 103                                 AP125   AP126
Element: Fr Seg Block                                            AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

RJB-TO-SEG-BLOCK       Alpha 103                                 AP125   AP126
Element: To Seg Block                                            AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 MA61.1  MA70.1
                                                                 MA75.1  MAI1.1

                         RJBRIDGE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RJBSET1   OBJ-TYPE                                               AP125   AP126
          OBJ-ID                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 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  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.7  MA43.2
                                                                 ...

RJBSET2   COMPANY       KeyChange                                AP20.1  AP20.2
          JE-TYPE                                                AP20.3  AP20.4
          REC-GROUP                                              AP20.5  AP20.7
                                                                 AP21.1  AP23.1
                                                                 AP30.2  GL110
                                                                 GL146   GL170
                                                                 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
                                                                 ...

                         RJBRIDGE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Rjcontrol      RJCONTROL    Required

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

                         RJBRIDGE 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