 |
Lawson Insight Technical Documentation |
|
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 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP32.2 GL110 GL146
GL170 GL197 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL70.2 GL75.1 GL38.2
MA41.2 MA43.2 MA61.1 MA70.1 MAI1.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.3 AP20.4
values are not user maintainable. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-OBJ-ID Numeric 12 AP125 AP126
Object ID Contains the object ID. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL110 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA43.2
MA61.1 MA70.1
MAI1.1
RJB-COMPANY Numeric 4 AP125 AP126
Company The company number as defined in GL10.1 AP20.1 AP20.2
(Company). AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL110 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA43.2
MA61.1 MA70.1
MAI1.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.3 AP20.4
AP20.5 AP20.7
N = Normal AP23.1 AP25.1
I = Intercompany AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-REC-GROUP Numeric 8 AP125 AP126
Group The recurring journal entry number. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-DEBIT-CREDIT Alpha 1 AP125 AP126
Debit - Credit Indicates a debit or credit amount. AP20.1 AP20.2
D = Debit AP20.3 AP20.4
C = Credit AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-TO-ACTIVITY Alpha 15 AP125 AP126
To Activity The ending activity in a range of AP20.1 AP20.2
activities. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.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.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-UNITS-AMOUNT Signed 15.2 AP125 AP126
Units Amount Contains the transaction units amount. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-SCHEDULE-AMT Signed 15.2 AP125 AP126
Schedule Amount Contains the recurring journal AP20.1 AP20.2
scheduled amount. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL38.2 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA43.2
MA61.1 MA70.1
MAI1.1
RJB-SCHEDULE-UNITS Signed 15.2 AP125 AP126
Schedule Units Contains the recurring journal AP20.1 AP20.2
scheduled units amount. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL38.2 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA43.2
MA61.1 MA70.1
MAI1.1
RJB-UPDATED-AMT Signed 15.2 AP125 AP126
Updated Amount Contains the recurring journal updated AP20.1 AP20.2
amount. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL170
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL75.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-UPDATED-UNITS Signed 15.2 AP125 AP126
Updated Units Contains the recurring journal updated AP20.1 AP20.2
units amount. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL170
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL75.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-PERIOD-AMOUNT Signed 15.2 AP125 AP126
Period Amount Contains the recurring journal period AP20.1 AP20.2
amount. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-PERIOD-UNITS Signed 15.2 AP125 AP126
Period Units Contains the recurring journal period AP20.1 AP20.2
units amount. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-TRANS-STATUS Alpha 1 AP125 AP126
Trans Status Contains the transaction status. AP20.1 AP20.2
0 = Unreleased AP20.3 AP20.4
1 = Released AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-FR-SEG-BLOCK Alpha 103 AP125 AP126
Fr Seg Block AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJB-TO-SEG-BLOCK Alpha 103 AP125 AP126
To Seg Block AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA43.2 MA61.1
MA70.1 MAI1.1
RJBSET2 COMPANY KeyChange AP20.1 AP20.2
JE-TYPE AP20.3 AP20.4
REC-GROUP AP20.5 AP20.7
AP23.1 AP30.2
AP32.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.6
GL75.1 GL38.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
|