 |
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
AP30.2 AP30.4 AP32.2 GL110 GL146 GL170
GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1
GL45.1 GL70.2 GL75.1 GL38.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJB-OBJ-TYPE Alpha 5 AP30.2 AP30.4
Object Type This field determines the type of AP32.2 GL146
object used by the attribute. These GL40.1 GL40.2
values are not user maintainable. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-OBJ-ID Numeric 12 AP30.2 AP30.4
Object ID Contains the object ID. AP32.2 GL110
GL146 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
RJB-COMPANY Numeric 4 AP30.2 AP30.4
Company The company number as defined in GL10.1 AP32.2 GL110
(Company). GL146 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
RJB-JE-TYPE Alpha 1 AP30.2 AP30.4
Journal Entry Type The type of journal entry. Valid values AP32.2 GL146
are Normal and Intercompany. GL40.1 GL40.2
GL40.3 GL40.7
N = Normal GL40.8 GL44.1
I = Intercompany GL45.1
RJB-REC-GROUP Numeric 8 AP30.2 AP30.4
Group The recurring journal entry number. AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-FR-ACCT-UNIT Alpha 15 AP30.2 AP30.4
From Accounting Unit This is the beginning accounting unit AP32.2 GL146
for a range of accounting units. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-FR-ACCOUNT Numeric 6 AP30.2 AP30.4
From Account This is the beginning account for a AP32.2 GL146
range of accounts. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-FR-SUB-ACCT Numeric 4 AP30.2 AP30.4
From Subaccount This is the beginning subaccount for a AP32.2 GL146
range of subaccounts. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-FR-ACTIVITY Alpha 15 AP30.2 AP30.4
From Activity This is the beginning activity for a AP32.2 GL146
range of activities. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-FR-ACCT-CAT Alpha 5 AP30.2 AP30.4
From Account This is the beginning account category AP32.2 GL146
Category for a range of account categories. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-DEBIT-CREDIT Alpha 1 AP30.2 AP30.4
Debit - Credit Indicates a debit or credit amount. AP32.2 GL146
D = Debit GL40.1 GL40.2
C = Credit GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TO-COMPANY Numeric 4 AP30.2 AP30.4
To Company The company number that the recurring AP32.2 GL146
journal is posted to. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TO-ACCT-UNIT Alpha 15 AP30.2 AP30.4
To Accounting Unit The accounting unit the recurring AP32.2 GL146
journal is posted to. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TO-ACCOUNT Numeric 6 AP30.2 AP30.4
To Account The account number that the recurring AP32.2 GL146
journal is posted to. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TO-SUB-ACCT Numeric 4 AP30.2 AP30.4
To Subaccount The subaccount that the recurring AP32.2 GL146
journal is posted to. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TO-ACTIVITY Alpha 15 AP30.2 AP30.4
To Activity The ending activity in a range of AP32.2 GL146
activities. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TO-ACCT-CAT Alpha 5 AP30.2 AP30.4
To Account Category The ending activity in a range of AP32.2 GL146
activities. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TRANS-AMOUNT Signed 15.2 AP30.2 AP30.4
Trans Amount This field contains the signed amount AP32.2 GL146
associated with this transaction. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TRANS-ND Numeric 1 AP30.2 AP30.4
Trans Number of The transaction number of decimals. AP32.2 GL146
Decimals GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-BASE-AMOUNT Signed 15.2 AP30.2 AP30.4
Base Amount The base amount to be posted to the AP32.2 GL146
General Ledger Master file. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-BASE-ND Numeric 1 AP30.2 AP30.4
Base Number of The number of decimal positions defined AP32.2 GL146
Decimals for the company base currency. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-UNITS-AMOUNT Signed 15.2 AP30.2 AP30.4
Units Amount Contains the transaction units amount. AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-SCHEDULE-AMT Signed 15.2 AP30.2 AP30.4
Schedule Amount Contains the recurring journal AP32.2 GL146
scheduled amount. GL38.2 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
RJB-SCHEDULE-UNITS Signed 15.2 AP30.2 AP30.4
Schedule Units Contains the recurring journal AP32.2 GL146
scheduled units amount. GL38.2 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
RJB-UPDATED-AMT Signed 15.2 AP30.2 AP30.4
Updated Amount Contains the recurring journal updated AP32.2 GL146
amount. GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL75.1
RJB-UPDATED-UNITS Signed 15.2 AP30.2 AP30.4
Updated Units Contains the recurring journal updated AP32.2 GL146
units amount. GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL75.1
RJB-PERIOD-AMOUNT Signed 15.2 AP30.2 AP30.4
Period Amount Contains the recurring journal period AP32.2 GL146
amount. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-PERIOD-ND Numeric 1 AP30.2 AP30.4
Period Number of Contains the period number of decimals. AP32.2 GL146
Decimals GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-PERIOD-UNITS Signed 15.2 AP30.2 AP30.4
Period Units Contains the recurring journal period AP32.2 GL146
units amount. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TRANS-STATUS Alpha 1 AP30.2 AP30.4
Trans Status Contains the transaction status. AP32.2 GL146
0 = Unreleased GL40.1 GL40.2
1 = Released GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-FR-SEG-BLOCK Alpha 103 AP30.2 AP30.4
Fr Seg Block AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJB-TO-SEG-BLOCK Alpha 103 AP30.2 AP30.4
To Seg Block AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJBRIDGE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJBSET1 OBJ-TYPE AP30.2 AP30.4
OBJ-ID AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJBSET2 COMPANY KeyChange AP30.2 AP32.2
JE-TYPE GL110 GL146
REC-GROUP GL170 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
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
|