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 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 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 AP25.1 AP25.2
object used by the attribute. These AP26.1 AP27.1
values are not user maintainable. 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
RJB-OBJ-ID Numeric 12 AP125 AP126
Element: Object ID Contains the object ID. 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
MA61.1 MA70.1
MA75.1 MAI1.1
RJB-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
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 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-FR-ACCT-UNIT Alpha 15 AP125 AP126
Element: From AccountinThis is the beginning accounting unit AP25.1 AP25.2
for a range of accounting units. 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
RJB-FR-ACCOUNT Numeric 6 AP125 AP126
Element: From Account This is the beginning account for a AP25.1 AP25.2
range of accounts. 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
RJB-FR-SUB-ACCT Numeric 4 AP125 AP126
Element: From SubaccounThis is the beginning subaccount for a AP25.1 AP25.2
range of subaccounts. 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
RJB-FR-ACTIVITY Alpha 15 AP125 AP126
Element: Activity This is the beginning activity for a AP25.1 AP25.2
range of activities. 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
RJB-FR-ACCT-CAT Alpha 5 AP125 AP126
Element: Account CategoThis is the beginning account category AP25.1 AP25.2
for a range of account categories. 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
RJB-DEBIT-CREDIT Alpha 1 AP125 AP126
Element: Debit - CreditIndicates a debit or credit amount. AP25.1 AP25.2
D = Debit AP26.1 AP27.1
C = Credit 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
RJB-TO-COMPANY Numeric 4 AP125 AP126
Element: To Company The company number that the recurring AP25.1 AP25.2
journal 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-TO-ACCT-UNIT Alpha 15 AP125 AP126
Element: To Accounting The accounting unit the recurring AP25.1 AP25.2
journal 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-TO-ACCOUNT Numeric 6 AP125 AP126
Element: To Account The account number that the recurring AP25.1 AP25.2
journal 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-TO-SUB-ACCT Numeric 4 AP125 AP126
Element: To Subaccount The subaccount that the recurring AP25.1 AP25.2
journal 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-TO-ACTIVITY Alpha 15 AP125 AP126
Element: Activity The ending activity in a range of AP25.1 AP25.2
activities. 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
RJB-TO-ACCT-CAT Alpha 5 AP125 AP126
Element: Account CategoThe ending activity in a range of AP25.1 AP25.2
activities. 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
RJB-TRANS-AMOUNT Signed 18.2 AP125 AP126
Element: Trans Amount This field contains the signed amount AP25.1 AP25.2
associated with this 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-TRANS-ND Numeric 1 AP125 AP126
Trans Number of The transaction number of decimals. AP25.1 AP25.2
Decimals 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
RJB-BASE-AMOUNT Signed 18.2 AP125 AP126
Element: Base Amount The base amount to be posted to the AP25.1 AP25.2
General Ledger Master file. 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
RJB-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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-UNITS-AMOUNT Signed 15.2 AP125 AP126
Element: Units Amount Contains the transaction units amount. 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-SCHEDULE-AMT Signed 18.2 AP125 AP126
Element: Schedule AmounContains the recurring journal AP25.1 AP25.2
scheduled amount. 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
MA61.1 MA70.1
MA75.1 MAI1.1
RJB-SCHEDULE-UNITS Signed 15.2 AP125 AP126
Element: Schedule UnitsContains the recurring journal AP25.1 AP25.2
scheduled units amount. 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
MA61.1 MA70.1
MA75.1 MAI1.1
RJB-UPDATED-AMT Signed 18.2 AP125 AP126
Element: Updated AmountContains the recurring journal updated AP25.1 AP25.2
amount. 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
RJB-UPDATED-UNITS Signed 18.2 AP125 AP126
Element: Updated Units Contains the recurring journal updated AP25.1 AP25.2
units amount. 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
RJB-PERIOD-AMOUNT Signed 18.2 AP125 AP126
Element: Period Amount Contains the recurring journal period AP25.1 AP25.2
amount. 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
RJB-PERIOD-ND Numeric 1 AP125 AP126
Period Number of Contains the period number of decimals. AP25.1 AP25.2
Decimals 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
RJB-PERIOD-UNITS Signed 15.2 AP125 AP126
Element: Period Units Contains the recurring journal period AP25.1 AP25.2
units amount. 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
RJB-TRANS-STATUS Alpha 1 AP125 AP126
Element: Trans Status Contains the transaction status. AP25.1 AP25.2
0 = Unreleased AP26.1 AP27.1
1 = Released 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
RJB-FR-SEG-BLOCK Alpha 103 AP125 AP126
Element: Fr Seg Block 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJB-TO-SEG-BLOCK Alpha 103 AP125 AP126
Element: To Seg Block 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 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 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJBSET2 COMPANY KeyChange AP30.2 GL110
JE-TYPE GL146 GL170
REC-GROUP 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
GL38.1 GL38.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
|