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 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 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 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
GL70.2 GL70.6
GLCC.1 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 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 GL70.2
GL70.6 GLCC.1
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-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 GL70.2
GL70.6 GLCC.1
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-STATUS Numeric 1 AP125 AP126
Element: Status This field displays the status of the AP25.1 AP25.2
transaction. AP26.1 AP27.1
1 = Released AP30.2 AP30.4
0 = Unreleased 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
RJC-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the line 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 GL70.1
GL70.2 GL70.3
GL70.6 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. 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-DESCRIPTION Alpha 30 (Lower Case) AP125 AP126
Element: Description The recurring journal description. 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 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 AP25.1 AP25.2
amounts are to be zeroed out after AP26.1 AP27.1
processing. AP30.2 AP30.4
N = No GL146 GL197
Y = Yes GL40.1 GL40.2
R = Rates Only GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6 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 AP25.1 AP25.2
process the recurring journal entry in. 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 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 YearThe year the transaction was last GL70.1 GL70.2
processed. GL70.3 GL70.5
GL70.6 GL75.1
RJC-BEG-PERIOD Numeric 2 AP125 AP126
Element: Beginning PeriThis is the beginning period that the AP25.1 AP25.2
transaction 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 GL70.2
GL70.6 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BEG-YEAR Numeric 4 AP125 AP126
Element: Beginning YearThis is the beginning year that the AP25.1 AP25.2
transaction 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 GL70.2
GL70.6 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 AP25.1 AP25.2
transaction 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 GL70.2
GL70.6 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 AP25.1 AP25.2
transaction 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 GL70.2
GL70.6 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-ENTRY-DEBITS Signed 18.2 AP125 AP126
Element: Entry Debits The total positive detail amounts. 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
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-ENTRY-CREDITS Signed 18.2 AP125 AP126
Element: Entry Credits The total negative detail amounts. 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
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-TRAN-ND Numeric 1 AP125 AP126
Trans Number of The number of decimal positions defined AP25.1 AP25.2
Decimals for the transaction 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 GL70.2
GL70.6 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. 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
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. 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
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-AUTO-DEBITS Signed 18.2 AP125 AP126
Element: Auto Debits The total positive detail auto AP25.1 AP25.2
reversing amounts. 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
RJC-AUTO-CREDITS Signed 18.2 AP125 AP126
Element: Auto Credits The total negative detail auto AP25.1 AP25.2
reversing amounts. 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
RJC-AUTO-UNIT-DB Signed 15.2 AP125 AP126
Element: Auto Unit DebiThe total positive detail auto AP25.1 AP25.2
reversing units amounts. 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 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 AP25.1 AP25.2
reversing unit amounts. 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 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 AP25.1 AP25.2
posted in the Lawson General Ledger AP26.1 AP27.1
system. If this field is left blank, the AP30.2 AP30.4
period end-date defaults. GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-OPERATOR Alpha 10 AP125 AP126
Element: Operator This field is used to store the login AP25.1 AP25.2
ID of the person who entered the record. 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 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-LAST-CMT-SEQ Numeric 4 AP125 AP126
Last Comment The sequence number of the last comment AP25.1 AP25.2
Sequence Number for the journal entry. 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
RJC-BASE-ZONE Alpha 15 AP125 AP126
Element: Base Zone The zone within the Lawson General AP25.1 AP25.2
Ledger system where the transaction AP26.1 AP27.1
originates. AP30.2 AP30.4
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-BASE-DEBITS Signed 18.2 AP125 AP126
Element: Base Debits The total positive detail amount in the AP25.1 AP25.2
company base currency. 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
RJC-BASE-CREDITS Signed 18.2 AP125 AP126
Element: Base Credits The total negative detail amount in the AP25.1 AP25.2
company base currency. 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
RJC-BASE-AUTO-DB Signed 18.2 AP125 AP126
Element: Base Auto DebiThe total positive detail auto AP25.1 AP25.2
reversing amount in the company base AP26.1 AP27.1
currency. 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
RJC-BASE-AUTO-CR Signed 18.2 AP125 AP126
Element: Base Auto CredThe total negative detail auto AP25.1 AP25.2
reversing amount in the company base AP26.1 AP27.1
currency. 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
RJC-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 GL70.2
GL70.6 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-CURRENCY-CODE Alpha 5 AP125 AP126
Element: Currency Code This is the recurring journal entry AP25.1 AP25.2
base currency code. If left blank, the AP26.1 AP27.1
company base currency defaults. AP30.2 AP30.4
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6 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 AP25.1 AP25.2
journal entry was made. If left blank, AP26.1 AP27.1
the current exchange rate will default. 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 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 AP25.1 AP25.2
transaction that identifies where the AP26.1 AP27.1
transaction was created. AP30.2 AP30.4
GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.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 AP25.1 AP25.2
"Y," the Lawson General Ledger Closing AP26.1 AP27.1
program GL199 creates an opposite entry AP30.2 AP30.4
for this transaction in the next period. GL146 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
MA61.1 MA70.1
MA75.1 MAI1.1
RJC-REFERENCE Alpha 10 (Lower Case) AP125 AP126
Element: Reference The reference number associated with AP25.1 AP25.2
the 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 GL70.2
GL70.6 MA61.1
MA70.1 MA75.1
MAI1.1
RJC-DOCUMENT-NBR Alpha 27 AP125 AP126
Element: Document NumbeThe document number assigned to the AP25.1 AP25.2
recurring journal entry. 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
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 AP25.1 AP25.2
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 GL70.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 AP25.1 AP25.2
Recurring Entry. A No value represents AP26.1 AP27.1
that the entry was created through GL70 AP30.2 AP30.4
(Recurring Journal). A Yes value GL146 GL197
represents that the entry originated GL40.1 GL40.2
from another system. GL40.3 GL40.7
GL40.8 GL44.1
Y = Yes GL45.1 MA61.1
N = No 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: Posting Day This field contains the journal entry
transaction day.
RJC-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
RJCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJCSET1 COMPANY AP125 AP126
JE-TYPE AP25.1 AP25.2
REC-GROUP 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
GL45.1 GL500
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 GL75.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
|