Lawson Insight Technical Documentation |
|
RJCONTROL
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 GL238 GL270 GL275 GLCC.1 GL38.2
IFGT.1
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 GL500 GL70.1
GL70.2 GL70.3 GL70.6 GL75.1 MA41.2 MA41.7
MA43.2 MA61.1 MA70.1 MA75.1 MAI1.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJC-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 GL70.2
GL70.6 GLCC.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-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
GL70.2 GL70.6
GLCC.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-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
GL70.2 GL70.6
GLCC.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP20.1 AP20.2
transaction. AP20.3 AP20.4
1 = Released AP20.5 AP20.7
0 = Unreleased 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 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line 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
GL70.1 GL70.2
GL70.3 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-NBR-LINES Numeric 6 AP125 AP126
Element: Number Lines This is the number of detail lines. 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
GL70.1 GL70.2
GL70.3 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description The recurring journal description. 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-AUTO-ZERO Alpha 1 AP125 AP126
Element: Auto Zero This field is used to determine if AP20.1 AP20.2
amounts are to be zeroed out after AP20.3 AP20.4
processing. AP20.5 AP20.7
N = No AP23.1 AP25.1
Y = Yes AP25.2 AP26.1
R = Rates Only 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-POST-PERIOD Alpha 1 Occurs 13 Times AP125 AP126
Element: Post Period The accounting periods you want to AP20.1 AP20.2
process the recurring journal entry in. 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-LP-PERIOD Numeric 2 GL170 GL500
Element: Last Post Period GL70.6 GL75.1
RJC-LP-YEAR Numeric 4 GL170 GL500
Element: Last Post Year GL70.6 GL75.1
RJC-BEG-PERIOD Numeric 2 AP125 AP126
Element: Beginning PeriThis is the beginning period that the AP20.1 AP20.2
transaction 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BEG-YEAR Numeric 4 AP125 AP126
Element: Beginning YearThis is the beginning year that the AP20.1 AP20.2
transaction 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-END-PERIOD Numeric 2 AP125 AP126
Element: End Period This is the ending period that the AP20.1 AP20.2
transaction 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-END-YEAR Numeric 4 AP125 AP126
Element: End Year This is the ending year that the AP20.1 AP20.2
transaction 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-ENTRY-DEBITS Signed 15.2 AP125 AP126
Element: Entry Debits The total positive detail amounts. 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
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-ENTRY-CREDITS Signed 15.2 AP125 AP126
Element: Entry Credits 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
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-TRAN-ND Numeric 1 AP125 AP126
Trans 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-UNIT-DEBITS Signed 15.2 AP125 AP126
Element: Unit Debits 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
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-UNIT-CREDITS Signed 15.2 AP125 AP126
Element: Unit Credits 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
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-AUTO-DEBITS Signed 15.2 AP125 AP126
Element: Auto Debits The total positive detail auto AP20.1 AP20.2
reversing amounts. 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 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-AUTO-CREDITS Signed 15.2 AP125 AP126
Element: Auto Credits The total negative detail auto AP20.1 AP20.2
reversing amounts. 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 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-AUTO-UNIT-DB Signed 15.2 AP125 AP126
Element: Auto Unit Debits 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
GL70.1 GL70.2
GL70.3 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-AUTO-UNIT-CR Signed 15.2 AP125 AP126
Element: Auto Unit Credits 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
GL70.1 GL70.2
GL70.3 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-POSTING-DAY Numeric 2 AP125 AP126
Element: Posting Day This is the day the transaction is AP20.1 AP20.2
posted in the Lawson General Ledger AP20.3 AP20.4
system. If this field is left blank, the AP20.5 AP20.7
period end-date defaults. 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-OPERATOR Alpha 10 AP125 AP126
Element: Operator This field is used to store the login AP20.1 AP20.2
ID of the person who entered the record. 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-LAST-CMT-SEQ Numeric 4 AP125 AP126
Element: Sequence 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
RJC-BASE-ZONE Alpha 15 AP125 AP126
Element: Base Zone The zone within the Lawson General AP20.1 AP20.2
Ledger system where the transaction AP20.3 AP20.4
originates. 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BASE-DEBITS Signed 15.2 AP125 AP126
Element: Base Debits 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
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BASE-CREDITS Signed 15.2 AP125 AP126
Element: Base Credits 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
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BASE-AUTO-DB Signed 15.2 AP125 AP126
Element: Base Auto Debits 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
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BASE-AUTO-CR Signed 15.2 AP125 AP126
Element: Base Auto Credits 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
GL170 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6 GL75.1
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-CURRENCY-CODE Alpha 5 AP125 AP126
Element: Currency Code This is the recurring journal entry AP20.1 AP20.2
base currency code. If left blank, the AP20.3 AP20.4
company base currency defaults. 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
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BASERATE Signed 12.6 AP125 AP126
Element: Base Rate The exchange rate at the time the AP20.1 AP20.2
journal entry was made. If left blank, AP20.3 AP20.4
the current exchange rate will default. 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
GL270 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.2 GL70.6
GL75.1 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-SOURCE-CODE Alpha 2 AP125 AP126
Element: Source Code A two-character code assigned to a AP20.1 AP20.2
transaction that identifies where the AP20.3 AP20.4
transaction was created. 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
GL70.2 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-AUTO-REV Alpha 1 AP125 AP126
Element: Auto Reverse When the Auto Reversal field is set to AP20.1 AP20.2
"Y," the Lawson General Ledger Closing AP20.3 AP20.4
program GL199 creates an opposite entry AP20.5 AP20.7
for this transaction in the next period. 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
GL70.2 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-REFERENCE Alpha 10 (Lower Case) AP125 AP126
Element: Reference The reference number associated with AP20.1 AP20.2
the 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
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.2 GL70.6
MA41.2 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-DOCUMENT-NBR Alpha 27 AP125 AP126
Element: Document NumbeThe document number assigned to the AP20.1 AP20.2
recurring journal entry. 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
GL70.2 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-NET-BASE-AMT Derived
Element: Net Base AmounThe net base amount.
RJC-NET-BASE-AREV Derived
Element: Net Base ReverNet base auto-reversed amount.
RJC-JRNL-BOOK-NBR Alpha 12 AP125 AP126
Element: Journal Book NThe journal book assigned to the AP20.1 AP20.2
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
API1.1 GL146
GL197 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.2 MA41.2
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-BRIDGE-FLAG Alpha 1 AP125 AP126
Element: Bridge Flag This field determines the origin of the AP20.1 AP20.2
Recurring Entry. A No value represents AP20.3 AP20.4
that the entry was created through GL70 AP20.5 AP20.7
(Recurring Journal). A Yes value AP23.1 AP25.1
represents that the entry originated AP25.2 AP26.1
from another system. AP27.1 AP30.2
AP30.4 AP32.2
Y = Yes API1.1 GL146
N = No 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
RJC-TRAN-DESC-DFLT Alpha 1 GL70.2
Element: Tran DescriptiThis field determines the description
that appears for each transaction line.
J = Journal Header
P = Prior Transaction Line
RJC-MX-VALUE Alpha 32 Occurs 3 Times GL70.2
Element: 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.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
GL179 GL197
GL238 GL270
GL275 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
...
RJCONTROL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apapdhist Orig APAPDHIST Required
When RJB-OBJ-TYPE = "APDST"
RJB-OBJ-ID -> AH2-DST-OBJ-ID
Apdistrib Orig APDISTRIB Not Required
Valid When RJB-OBJ-TYPE = "APDST"
RJB-OBJ-ID -> APD-DST-OBJ-ID
Company GLSYSTEM Required
RJC-COMPANY -> GLS-COMPANY
Gltrans Orig GLTRANS Not Required
Valid When RJB-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
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
|