 |
Lawson Insight Technical Documentation |
|
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
AP30.2 AP30.4 AP32.2 GL110 GL146 GL170
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RJC-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
GL70.2 GL70.6
GLCC.1
RJC-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 GL70.2
GL70.6 GLCC.1
RJC-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 GL70.2
GL70.6 GLCC.1
RJC-STATUS Numeric 1 AP30.2 AP30.4
Status This field displays the status of the AP32.2 GL146
transaction. GL170 GL40.1
1 = Released GL40.2 GL40.3
0 = Unreleased GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-LINE-NBR Numeric 6 AP30.2 AP30.4
Line Number This field contains the line number. AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6
RJC-NBR-LINES Numeric 6 AP30.2 AP30.4
Number Lines This is the number of detail lines. AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6
RJC-DESCRIPTION Alpha 30 (Lower Case) AP30.2 AP30.4
Description The recurring journal description. AP32.2 GL146
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-AUTO-ZERO Alpha 1 AP30.2 AP30.4
Auto Zero This field is used to determine if AP32.2 GL146
amounts are to be zeroed out after GL40.1 GL40.2
processing. GL40.3 GL40.7
N = No GL40.8 GL44.1
Y = Yes GL45.1 GL70.2
R = Rates Only GL70.6
RJC-POST-PERIOD Alpha 1 Occurs 13 Times AP30.2 AP30.4
Post Period The accounting periods you want to AP32.2 GL146
process the recurring journal entry in. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-LP-PERIOD Numeric 2 GL170 GL500
Last Post Period The period the transaction was last GL70.6 GL75.1
processed.
RJC-LP-YEAR Numeric 4 GL170 GL500
Last Post Year The year the transaction was last GL70.6 GL75.1
processed.
RJC-BEG-PERIOD Numeric 2 AP30.2 AP30.4
Beginning Period This is the beginning period that the AP32.2 GL146
transaction is posted to. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-BEG-YEAR Numeric 4 AP30.2 AP30.4
Beginning Year This is the beginning year that the AP32.2 GL146
transaction is posted to. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-END-PERIOD Numeric 2 AP30.2 AP30.4
End Period This is the ending period that the AP32.2 GL146
transaction is posted to. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-END-YEAR Numeric 4 AP30.2 AP30.4
End Year This is the ending year that the AP32.2 GL146
transaction is posted to. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-ENTRY-DEBITS Signed 15.2 AP30.2 AP30.4
Entry Debits The total positive detail amounts. AP32.2 GL146
GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-ENTRY-CREDITS Signed 15.2 AP30.2 AP30.4
Entry Credits The total negative detail amounts. AP32.2 GL146
GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-TRAN-ND Numeric 1 AP30.2 AP30.4
Trans Number of The number of decimal positions defined AP32.2 GL146
Decimals for the transaction currency. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-UNIT-DEBITS Signed 15.2 AP30.2 AP30.4
Unit Debits The total positive detail unit amounts. AP32.2 GL146
GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-UNIT-CREDITS Signed 15.2 AP30.2 AP30.4
Unit Credits The total negative detail unit amounts. AP32.2 GL146
GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-AUTO-DEBITS Signed 15.2 AP30.2 AP30.4
Auto Debits The total positive detail auto AP32.2 GL146
reversing amounts. GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-AUTO-CREDITS Signed 15.2 AP30.2 AP30.4
Auto Credits The total negative detail auto AP32.2 GL146
reversing amounts. GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-AUTO-UNIT-DB Signed 15.2 AP30.2 AP30.4
Auto Unit Debits The total positive detail auto AP32.2 GL146
reversing units amounts. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6
RJC-AUTO-UNIT-CR Signed 15.2 AP30.2 AP30.4
Auto Unit Credits The total negative detail auto AP32.2 GL146
reversing unit amounts. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.6
RJC-POSTING-DAY Numeric 2 AP30.2 AP30.4
Posting Day This is the day the transaction is AP32.2 GL146
posted in the Lawson General Ledger GL40.1 GL40.2
system. If this field is left blank, the GL40.3 GL40.7
period end-date defaults. GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-OPERATOR Alpha 10 AP30.2 AP30.4
Operator This field is used to store the login AP32.2 GL146
ID of the person who entered the record. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-LAST-CMT-SEQ Numeric 4 AP30.2 AP30.4
Last Comment The sequence number of the last comment AP32.2 GL146
Sequence Number for the journal entry. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
RJC-BASE-ZONE Alpha 15 AP30.2 AP30.4
Base Zone The zone within the Lawson General AP32.2 GL146
Ledger system where the transaction GL40.1 GL40.2
originates. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-BASE-DEBITS Signed 15.2 AP30.2 AP30.4
Base Debits The total positive detail amount in the AP32.2 GL146
company base currency. GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-BASE-CREDITS Signed 15.2 AP30.2 AP30.4
Base Credits The total negative detail amount in the AP32.2 GL146
company base currency. GL170 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-BASE-AUTO-DB Signed 15.2 AP30.2 AP30.4
Base Auto Debits The total positive detail auto AP32.2 GL146
reversing amount in the company base GL170 GL40.1
currency. GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-BASE-AUTO-CR Signed 15.2 AP30.2 AP30.4
Base Auto Credits The total negative detail auto AP32.2 GL146
reversing amount in the company base GL170 GL40.1
currency. GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.6
GL75.1
RJC-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 GL70.2
GL70.6
RJC-CURRENCY-CODE Alpha 5 AP30.2 AP30.4
Currency Code This is the recurring journal entry AP32.2 GL146
base currency code. If left blank, the GL40.1 GL40.2
company base currency defaults. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-BASERATE Signed 12.6 AP30.2 AP30.4
Base Rate The exchange rate at the time the AP32.2 GL146
journal entry was made. If left blank, GL170 GL270
the current exchange rate will default. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6 GL75.1
RJC-SOURCE-CODE Alpha 2 AP30.2 AP30.4
Source Code A two-character code assigned to a AP32.2 GL146
transaction that identifies where the GL40.1 GL40.2
transaction was created. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
RJC-AUTO-REV Alpha 1 AP30.2 AP30.4
Auto Reverse When the Auto Reversal field is set to AP32.2 GL146
"Y," the Lawson General Ledger Closing GL40.1 GL40.2
program GL199 creates an opposite entry GL40.3 GL40.7
for this transaction in the next period. GL40.8 GL44.1
GL45.1 GL70.2
RJC-REFERENCE Alpha 10 (Lower Case) AP30.2 AP30.4
Reference The reference number associated with AP32.2 GL146
the transaction. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
GL70.6
RJC-DOCUMENT-NBR Alpha 27 AP30.2 AP30.4
Document Number The document number assigned to the AP32.2 GL146
recurring journal entry. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
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 AP30.2 AP30.4
Journal Book Number The journal book assigned to the AP32.2 GL146
transaction. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL70.2
RJC-BRIDGE-FLAG Alpha 1 AP30.2 AP30.4
Bridge Flag This field determines the origin of the AP32.2 GL146
Recurring Entry. A No value represents GL40.1 GL40.2
that the entry was created through GL70 GL40.3 GL40.7
(Recurring Journal). A Yes value GL40.8 GL44.1
represents that the entry originated GL45.1
from another system.
Y = Yes
N = No
RJC-TRAN-DESC-DFLT Alpha 1 GL70.2
Tran Description This 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
Matrix Value The attribute value associated with the
recurring journal.
RJCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RJCSET1 COMPANY AP30.2 AP30.4
JE-TYPE AP32.2 GL110
REC-GROUP GL146 GL170
GL179 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
GLCC.1 GL38.2
IFGT.1
RJCONTROL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apapdhist Orig APAPDHIST Required
When RJC-OBJ-TYPE = "APDST"
RJB-OBJ-ID -> AH2-DST-OBJ-ID
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
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
|