RJCONTROL FILE
Recurring Journal Control
This file contains recurring journal entry control information defined in
GL70.1 (Recurring Journal). This information is used to process the recurring
journal entry detail records.
REFERENCED BY
GL179 GL270 GL275 GL38.2
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 GL500
GL70.1 GL70.2 GL70.3 GL70.5 GL70.7 GL75.1
GL950 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
RJC-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
GL70.2 GL70.7
GL950 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJC-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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-STATUS Numeric 1 AP125 AP126
Status This field contains the status of the AP20.1 AP20.2
transaction. AP20.5 AP20.7
1 = Released AP23.1 AP25.1
0 = Unreleased 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
GL70.1 GL70.2
GL70.3 GL70.7
GL75.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the line 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 GL70.1
GL70.2 GL70.3
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-NBR-LINES Numeric 6 AP125 AP126
Number Lines This is the number of detail lines. 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 GL70.1
GL70.2 GL70.3
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Description The recurring journal description. 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-AUTO-ZERO Alpha 1 AP125 AP126
Auto Zero This field is used to determine if AP20.1 AP20.2
amounts are to be zeroed out after AP20.5 AP20.7
processing. AP23.1 AP25.1
AP25.2 AP26.1
N = No AP30.2 AP30.4
Y = Yes AP32.2 GL146
R = Rates Only GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-POST-PERIOD Alpha 1 Occurs 13 Times AP125 AP126
Post Period The accounting periods you want to AP20.1 AP20.2
process the recurring journal entry in. 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-LP-PERIOD Numeric 2 GL170 GL500
Last Post Period The period the transaction was last GL70.7 GL75.1
processed. GL950
RJC-LP-YEAR Numeric 4 GL170 GL500
Last Post Year The year the transaction was last GL70.7 GL75.1
processed. GL950
RJC-BEG-PERIOD Numeric 2 AP125 AP126
Beginning Period This is the beginning period that the AP20.1 AP20.2
transaction 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-BEG-YEAR Numeric 4 AP125 AP126
Beginning Year This is the beginning year that the AP20.1 AP20.2
transaction 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-END-PERIOD Numeric 2 AP125 AP126
End Period This is the ending period that the AP20.1 AP20.2
transaction 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-END-YEAR Numeric 4 AP125 AP126
End Year This is the ending year that the AP20.1 AP20.2
transaction 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-ENTRY-DEBITS Signed 15.2 AP125 AP126
Entry Debits The total positive detail amounts. AP20.1 AP20.2
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
GL70.1 GL70.2
GL70.3 GL70.7
GL75.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-ENTRY-CREDITS Signed 15.2 AP125 AP126
Entry Credits The total negative detail amounts. AP20.1 AP20.2
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
GL70.1 GL70.2
GL70.3 GL70.7
GL75.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-TRAN-ND Numeric 1 AP125 AP126
Trans Number of The number of decimal positions defined AP20.1 AP20.2
Decimals for the transaction 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-UNIT-DEBITS Signed 15.2 AP125 AP126
Unit Debits The total positive detail unit amounts. AP20.1 AP20.2
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
GL70.1 GL70.2
GL70.3 GL70.7
GL75.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-UNIT-CREDITS Signed 15.2 AP125 AP126
Unit Credits The total negative detail unit amounts. AP20.1 AP20.2
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
GL70.1 GL70.2
GL70.3 GL70.7
GL75.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-AUTO-DEBITS Signed 15.2 AP125 AP126
Auto Debits The total positive detail auto AP20.1 AP20.2
reversing amounts. 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
GL70.1 GL70.2
GL70.3 GL70.7
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
RJC-AUTO-CREDITS Signed 15.2 AP125 AP126
Auto Credits The total negative detail auto AP20.1 AP20.2
reversing amounts. 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
GL70.1 GL70.2
GL70.3 GL70.7
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
RJC-AUTO-UNIT-DB Signed 15.2 AP125 AP126
Auto Unit Debits The total positive detail auto AP20.1 AP20.2
reversing units amounts. 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 GL70.1
GL70.2 GL70.3
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-AUTO-UNIT-CR Signed 15.2 AP125 AP126
Auto Unit Credits The total negative detail auto AP20.1 AP20.2
reversing unit amounts. 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 GL70.1
GL70.2 GL70.3
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-POSTING-DAY Numeric 2 AP125 AP126
Posting Day This is the day the transaction is AP20.1 AP20.2
posted in the Lawson General Ledger AP20.5 AP20.7
system. If this field is left blank, the AP23.1 AP25.1
period end-date defaults. 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-OPERATOR Alpha 10 AP125 AP126
Operator This field is used to store the login AP20.1 AP20.2
ID of the person who entered the record. 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-LAST-CMT-SEQ Numeric 4 AP125 AP126
Comment The sequence number of the last comment AP20.1 AP20.2
for the journal entry. 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 GL70.5
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-BASE-ZONE Alpha 15 AP125 AP126
Base Zone The zone within the Lawson General AP20.1 AP20.2
Ledger system where the transaction AP20.5 AP20.7
originates. 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-BASE-DEBITS Signed 15.2 AP125 AP126
Base Debits The total positive detail amount in the AP20.1 AP20.2
company base currency. 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
GL70.1 GL70.2
GL70.3 GL70.7
GL75.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-BASE-CREDITS Signed 15.2 AP125 AP126
Base Credits The total negative detail amount in the AP20.1 AP20.2
company base currency. 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
GL70.1 GL70.2
GL70.3 GL70.7
GL75.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-BASE-AUTO-DB Signed 15.2 AP125 AP126
Base Auto Debits The total positive detail auto AP20.1 AP20.2
reversing amount in the company base AP20.5 AP20.7
currency. 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
GL70.1 GL70.2
GL70.3 GL70.7
GL75.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-BASE-AUTO-CR Signed 15.2 AP125 AP126
Base Auto Credits The total negative detail auto AP20.1 AP20.2
reversing amount in the company base AP20.5 AP20.7
currency. 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
GL70.1 GL70.2
GL70.3 GL70.7
GL75.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-CURRENCY-CODE Alpha 5 AP125 AP126
Currency Code This is the recurring journal entry AP20.1 AP20.2
base currency code. If left blank, the AP20.5 AP20.7
company base currency defaults. 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-BASERATE Signed 12.6 AP125 AP126
Base Rate The exchange rate at the time the AP20.1 AP20.2
journal entry was made. If left blank, AP20.5 AP20.7
the current exchange rate will default. AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL270
GL40.1 GL40.2
GL40.3 GL40.8
GL40.9 GL44.1
GL45.1 GL70.2
GL70.7 GL75.1
GL950 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJC-SOURCE-CODE Alpha 2 AP125 AP126
Source Code A two-character code assigned to a AP20.1 AP20.2
transaction that identifies where the AP20.5 AP20.7
transaction was created. 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 GL70.2
GL950 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJC-AUTO-REV Alpha 1 AP125 AP126
Auto Reverse When the Auto Reversal field is set to AP20.1 AP20.2
"Y," the Lawson General Ledger Closing AP20.5 AP20.7
program GL199 creates an opposite entry AP23.1 AP25.1
for this transaction in the next period. 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 GL70.2
GL950 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJC-REFERENCE Alpha 10 (Lower Case) AP125 AP126
Reference The reference number associated with AP20.1 AP20.2
the 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 GL70.2
GL70.7 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-DOCUMENT-NBR Alpha 24 AP125 AP126
Document Number The document number assigned to the AP20.1 AP20.2
recurring journal entry. 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 GL70.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
RJC-NET-BASE-AMT Derived
Net Base Amount The net base amount.
RJC-NET-BASE-AREV Derived
Net Base Reverse Net base auto-reversed amount.
RJC-JRNL-BOOK-NBR Alpha 12 AP125 AP126
Journal Book Number The journal book assigned to the AP20.1 AP20.2
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 GL70.2
GL950 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
RJC-BRIDGE-FLAG Alpha 1 AP125 AP126
Bridge Flag This field determines the origin of the AP20.1 AP20.2
Recurring Entry. A No value represents AP20.5 AP20.7
that the entry was created through GL70 AP23.1 AP25.1
(Recurring Journal). A Yes value AP25.2 AP26.1
represents that the entry originated AP30.2 AP30.4
from another system. AP32.2 GL146
GL40.1 GL40.2
Y = Yes GL40.3 GL40.8
N = No GL40.9 GL44.1
GL45.1 GL950
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
RJC-TRAN-DESC-DFLT Alpha 1 GL70.2 GL950
Tran Description This field determines the description
that appears for each transaction line.
J = Journal Header
P = Prior Transaction Line
RJC-MX-VALUE Alpha 20 Occurs 3 Times GL70.2 GL950
Matrix Value The attribute value associated with the
recurring journal.
RJCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJCSET1 COMPANY AP125 AP126
JE-TYPE AP20.1 AP20.2
REC-GROUP AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL110
GL146 GL170
GL179 GL270
GL275 GL40.1
GL40.2 GL40.3
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.1
GL70.2 GL70.3
...
RJCONTROL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apdistrib Orig APDISTRIB Not Required
Valid When RJC-OBJ-TYPE = "APDST"
RJB-OBJ-ID -> APD-DST-OBJ-ID
Company GLSYSTEM Required
RJC-COMPANY -> GLS-COMPANY
Gltrans Orig GLTRANS Not Required
Valid When RJC-OBJ-TYPE = "GLTRN"
RJB-OBJ-ID -> GLT-OBJ-ID
Rjbridge RJBRIDGE Not Required
RJC-COMPANY -> RJB-COMPANY
RJC-JE-TYPE -> RJB-JE-TYPE
RJC-REC-GROUP -> RJB-REC-GROUP
RJCONTROL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Comments GLCOMMENT Delete Cascades
RJC-COMPANY -> GCM-COMPANY
"R" -> GCM-RECORD-TYPE
"RJ" -> GCM-SYSTEM
Zeroes -> GCM-FISCAL-YEAR
Zeroes -> GCM-ACCT-PERIOD
RJC-REC-GROUP -> GCM-CONTROL-GROUP
RJC-JE-TYPE -> GCM-JE-TYPE
Zeroes -> GCM-JE-SEQUENCE
GCM-SEQUENCE-NBR
Rjschedule RJSCHEDULE
RJB-OBJ-TYPE -> RJS-OBJ-TYPE
RJB-OBJ-ID -> RJS-OBJ-ID
RJS-FISCAL-YEAR
RJS-ACCT-PERIOD
Rjtrans RJTRANS Delete Cascades
RJC-COMPANY -> RJT-COMPANY
RJC-REC-GROUP -> RJT-REC-GROUP
RJC-JE-TYPE -> RJT-JE-TYPE
RJT-LINE-NBR
|