Lawson Insight Technical Documentation |
|
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 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP32.2 API1.1 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 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL110
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL110
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
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 AP23.1 AP25.1
I = Intercompany AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-FR-ACCOUNT Numeric 6 AP125 AP126
Element: From Account 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
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-FR-SUB-ACCT Numeric 4 AP125 AP126
Element: From Subaccount 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
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-FR-ACCT-CAT Alpha 5 AP125 AP126
Element: Account CategoThis is the beginning account category AP20.1 AP20.2
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
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-TO-ACCT-CAT Alpha 5 AP125 AP126
Element: Account CategoThe 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
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-TRANS-AMOUNT Signed 15.2 AP125 AP126
Element: Trans 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
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-BASE-AMOUNT Signed 15.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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-BASE-ND Numeric 1 AP125 AP126
Base Number of 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
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-SCHEDULE-AMT Signed 15.2 AP125 AP126
Element: Schedule AmounContains 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
API1.1 GL146
GL197 GL38.2
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL38.2
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJB-UPDATED-AMT Signed 15.2 AP125 AP126
Element: Updated AmountContains 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
API1.1 GL146
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-UPDATED-UNITS Signed 15.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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-PERIOD-AMOUNT Signed 15.2 AP125 AP126
Element: 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
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 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
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
MA41.2 MA41.7
MA43.2 MA61.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
|