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
GL270 GL500
UPDATED BY
AP125 AP126 AP20.1 AP20.2 AP20.5 AP20.7
AP23.1 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4
AP32.2 GL110 GL146 GL170 GL40.1 GL40.2
GL40.3 GL40.8 GL40.9 GL44.1 GL45.1 GL70.2
GL75.1 GL38.2 MA40.1 MA40.2 MA41.1 MA41.2
MA41.4 MA41.5 MA41.6 MA43.1 MA43.2 MA43.3
MA43.4 MA52.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJB-OBJ-TYPE Alpha 5 AP125 AP126
Object Type This field determines the type of AP20.1 AP20.2
object used by the attribute. These AP20.5 AP20.7
values are not user maintainable. AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-OBJ-ID Numeric 12 AP125 AP126
Object ID Contains the object ID. AP20.1 AP20.2
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL110
GL146 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJB-COMPANY Numeric 4 AP125 AP126
Company The company number as defined in GL10.1 AP20.1 AP20.2
(Company). AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL110
GL146 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJB-JE-TYPE Alpha 1 AP125 AP126
Journal Entry Type The type of journal entry. Valid values AP20.1 AP20.2
are Normal and Intercompany. AP20.5 AP20.7
AP23.1 AP25.1
N = Normal AP25.2 AP26.1
I = Intercompany AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-REC-GROUP Numeric 8 AP125 AP126
Group The recurring journal entry number. AP20.1 AP20.2
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-FR-ACCT-UNIT Alpha 15 AP125 AP126
From Accounting Unit This is the beginning accounting unit AP20.1 AP20.2
for a range of accounting units. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-FR-ACCOUNT Numeric 6 AP125 AP126
From Account This is the beginning account for a AP20.1 AP20.2
range of accounts. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-FR-SUB-ACCT Numeric 4 AP125 AP126
From Subaccount This is the beginning subaccount for a AP20.1 AP20.2
range of subaccounts. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-FR-ACTIVITY Alpha 15 AP125 AP126
From Activity This is the beginning activity for a AP20.1 AP20.2
range of activities. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-FR-ACCT-CAT Alpha 5 AP125 AP126
From Account This is the beginning account category AP20.1 AP20.2
Category for a range of account categories. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-DEBIT-CREDIT Alpha 1 AP125 AP126
Debit - Credit Indicates a debit or credit amount. AP20.1 AP20.2
D = Debit AP20.5 AP20.7
C = Credit AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-TO-COMPANY Numeric 4 AP125 AP126
To Company The company number that the recurring AP20.1 AP20.2
journal is posted to. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-TO-ACCT-UNIT Alpha 15 AP125 AP126
To Accounting Unit The accounting unit the recurring AP20.1 AP20.2
journal is posted to. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-TO-ACCOUNT Numeric 6 AP125 AP126
To Account The account number that the recurring AP20.1 AP20.2
journal is posted to. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-TO-SUB-ACCT Numeric 4 AP125 AP126
To Subaccount The subaccount that the recurring AP20.1 AP20.2
journal is posted to. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-TO-ACTIVITY Alpha 15 AP125 AP126
To Activity The ending activity in a range of AP20.1 AP20.2
activities. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-TO-ACCT-CAT Alpha 5 AP125 AP126
To Account Category The ending activity in a range of AP20.1 AP20.2
activities. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-ACTIVITY Alpha 15
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
RJB-ACCT-CATEGORY Alpha 5
Account Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
RJB-TRANS-AMOUNT Signed 15.2 AP125 AP126
Trans Amount This field contains the signed amount AP20.1 AP20.2
associated with this transaction. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-TRANS-ND Numeric 1 AP125 AP126
Trans Number of The transaction number of decimals. AP20.1 AP20.2
Decimals AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-BASE-AMOUNT Signed 15.2 AP125 AP126
Base Amount The base amount to be posted to the AP20.1 AP20.2
General Ledger Master file. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.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.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-UNITS-AMOUNT Signed 15.2 AP125 AP126
Units Amount Contains the transaction units amount. AP20.1 AP20.2
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-SCHEDULE-AMT Signed 15.2 AP125 AP126
Schedule Amount Contains the recurring journal AP20.1 AP20.2
scheduled amount. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL38.2 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJB-SCHEDULE-UNITS Signed 15.2 AP125 AP126
Schedule Units Contains the recurring journal AP20.1 AP20.2
scheduled units amount. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL38.2 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJB-UPDATED-AMT Signed 15.2 AP125 AP126
Updated Amount Contains the recurring journal updated AP20.1 AP20.2
amount. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL75.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-UPDATED-UNITS Signed 15.2 AP125 AP126
Updated Units Contains the recurring journal updated AP20.1 AP20.2
units amount. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL75.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-PERIOD-AMOUNT Signed 15.2 AP125 AP126
Period Amount Contains the recurring journal period AP20.1 AP20.2
amount. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-PERIOD-ND Numeric 1 AP125 AP126
Period Number of Contains the period number of decimals. AP20.1 AP20.2
Decimals AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-PERIOD-UNITS Signed 15.2 AP125 AP126
Period Units Contains the recurring journal period AP20.1 AP20.2
units amount. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-TRANS-STATUS Alpha 1 AP125 AP126
Trans Status Contains the transaction status. AP20.1 AP20.2
0 = Unreleased AP20.5 AP20.7
1 = Released AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJB-SEGMENT-BLOCK Alpha 103 AP125 AP126
User Analysis This field identifies the user analysis AP20.1 AP20.2
values included in the transaction. AP20.5 AP20.7
AP23.1 AP25.1
You can either type up to four values AP25.2 AP26.1
or use Define (F6) to open the User AP30.2 AP30.4
Analysis Entry subform. Use this subform AP32.2 GL146
to select the user analysis values you GL40.1 GL40.2
want to include in the transaction. If GL40.3 GL40.8
you choose to type values, use commas to GL40.9 GL44.1
separate them. For example: GL45.1 MA40.1
value1,value2,value3,value4 MA40.2 MA41.1
MA41.2 MA41.4
There are three conditions that affect MA41.5 MA41.6
how you can select user analysis values. MA43.1 MA43.2
See the User Analysis Entry form help or MA43.3 MA43.4
the Strategic Ledger procedures manual MA52.1
for additional information.
RJBRIDGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJBSET1 OBJ-TYPE AP125 AP126
OBJ-ID AP20.1 AP20.2
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
...
RJBSET2 COMPANY KeyChange AP20.1 AP20.2
JE-TYPE AP20.5 AP20.7
REC-GROUP AP23.1 AP30.2
AP32.2 GL110
GL146 GL170
GL270 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.1
GL70.2 GL70.3
GL70.7 GL75.1
GL38.1 GL38.2
MA40.1 MA40.2
MA41.1 MA41.2
...
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
|