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 AP21.1 AP23.1 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 GL500 GL70.1 GL70.2
GL70.3 GL70.5 GL70.6 GL75.1 MA41.1 MA41.2
MA41.4 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
AP21.1 AP23.1
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
GL70.2 GL70.6
GLCC.1 MA41.1
MA41.2 MA41.4
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 AP21.1 AP23.1
I = Intercompany 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 GL70.2
GL70.6 GLCC.1
MA41.1 MA41.2
MA41.4 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
AP21.1 AP23.1
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 GL70.2
GL70.6 GLCC.1
MA41.1 MA41.2
MA41.4 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 AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 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
AP21.1 AP23.1
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 GL70.1
GL70.2 GL70.3
GL70.6 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.1
GL70.2 GL70.3
GL70.6 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
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 AP21.1 AP23.1
Y = Yes AP25.1 AP25.2
R = Rates Only AP26.1 AP27.1
AP30.2 AP30.4
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-LP-PERIOD Numeric 2 GL170 GL500
Element: Last Post PeriThe period the transaction was last GL70.1 GL70.2
processed. GL70.3 GL70.5
GL70.6 GL75.1
RJC-LP-YEAR Numeric 4 GL170 GL500
Element: Last Post YearContains the fiscal year for the data GL70.1 GL70.2
stored on this record. GL70.3 GL70.5
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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-ENTRY-DEBITS Signed 18.2 AP125 AP126
Element: Entry Debits AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-ENTRY-CREDITS Signed 18.2 AP125 AP126
Element: Entry Credits AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-TRAN-ND Numeric 1 AP125 AP126
Trans Number of The number of decimals assigned to a AP20.1 AP20.2
Decimals particular account as determined by the AP20.3 AP20.4
account currency. AP20.5 AP20.7
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-UNIT-DEBITS Signed 15.2 AP125 AP126
Element: Unit Debits The total positive detail unit amounts. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-UNIT-CREDITS Signed 15.2 AP125 AP126
Element: Unit Credits The total negative detail unit amounts. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-AUTO-DEBITS Signed 18.2 AP125 AP126
Element: Auto Debits AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-AUTO-CREDITS Signed 18.2 AP125 AP126
Element: Auto Credits AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-AUTO-UNIT-DB Signed 15.2 AP125 AP126
Element: Auto Unit DebiThe total positive detail auto AP20.1 AP20.2
reversing amounts. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
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 GL70.1
GL70.2 GL70.3
GL70.6 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-AUTO-UNIT-CR Signed 15.2 AP125 AP126
Element: Auto Unit CredThe total negative detail auto AP20.1 AP20.2
reversing amounts. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
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 GL70.1
GL70.2 GL70.3
GL70.6 MA41.1
MA41.2 MA41.4
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. AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-LAST-CMT-SEQ Numeric 4 AP125 AP126
Element: Last Cmt Seq The sequence number of the last comment AP20.1 AP20.2
for the journal entry. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
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 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-BASE-DEBITS Signed 18.2 AP125 AP126
Element: Base Debits AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BASE-CREDITS Signed 18.2 AP125 AP126
Element: Base Credits AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BASE-AUTO-DB Signed 18.2 AP125 AP126
Element: Base Auto Debits AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BASE-AUTO-CR Signed 18.2 AP125 AP126
Element: Base Auto Credits AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.2 MA61.1
MA70.1 MA75.1
MAI1.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.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
MA41.7 MA43.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-BASERATE Signed 14.7 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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
GL146 GL170
GL197 GL270
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 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
MA41.1 MA41.2
MA41.4 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. AP21.1 AP23.1
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 GL70.2
MA41.1 MA41.2
MA41.4 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
AP21.1 AP23.1
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 GL70.2
GL70.6 MA41.1
MA41.2 MA41.4
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
AP21.1 AP23.1
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 GL70.2
MA41.1 MA41.2
MA41.4 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
AP21.1 AP23.1
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 GL70.2
MA41.1 MA41.2
MA41.4 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 AP21.1 AP23.1
represents that the entry originated AP25.1 AP25.2
from another system. AP26.1 AP27.1
AP30.2 AP30.4
Y = Yes GL146 GL197
N = No GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 MA41.1
MA41.2 MA41.4
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.
RJC-TRANS-DAY Numeric 2 GL70.2 GL70.6
Element: Day This field contains the journal entry
transaction day.
RJC-BLANK Derived
Element: Blankam This field consists of blank spaces. It
is used to provide column headings on
Drill Arounds.
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
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
GL110 GL146
GL170 GL179
GL197 GL238
GL270 GL275
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
...
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
|