RJCONTROL – Recurring Journal Control

System: General Ledger (GL)
Prefix: RJC
Primary key: COMPANY, JE-TYPE, REC-GROUP
Fields: 47
Updated by: 46 programs
Referenced by: 28 programs

RJCONTROL is the Recurring Journal Control table in Lawson General Ledger (prefix RJC). It is indexed by COMPANY, JE-TYPE, REC-GROUP (RJCSET1). It is related 1:1 to APAPDHIST, APDISTRIB, GLSYSTEM, GLTRANS and RJBRIDGE and 1:M to RJCNTRLAU, RJSCHEDULE and RJTRANS. It is updated by AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 38 more and referenced by CA00.1, CA00.2, CA05.1, CA05.2, CA10.1, CA10.2, CA10.4, CA10.6 and 20 more. The table has 47 fields, 1 index and 8 documented relations.

About RJCONTROL

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.

Fields (47)

Column = COBOL field name without the RJC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / column	Type	Description & values	Updated by
#`RJC-COMPANY` PK COMPANY	Numeric 4	The company number as defined in GL10.1 (Company).	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +33 more
#`RJC-JE-TYPE` PK JE_TYPE	Alpha 1	The type of journal entry. Valid values are Normal and Intercompany. `N` Normal `I` Intercompany	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +32 more
#`RJC-REC-GROUP` PK REC_GROUP	Numeric 8	The recurring journal entry number.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +32 more
#`RJC-STATUS` STATUS	Numeric 1	This field displays the status of the transaction. `1` Released `0` Unreleased	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-LINE-NBR` LINE_NBR	Numeric 6	This field contains the line number.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +33 more
#`RJC-NBR-LINES` NBR_LINES	Numeric 6	This is the number of detail lines.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +33 more
#`RJC-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The recurring journal description.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-AUTO-ZERO` AUTO_ZERO	Alpha 1	This field is used to determine if amounts are to be zeroed out after processing. `N` No `Y` Yes `R` Rates Only	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-POST-PERIOD` POST_PERIOD	Alpha 1 Occurs 13 Times ×13	The accounting periods you want to process the recurring journal entry in.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-LP-PERIOD` LP_PERIOD	Numeric 2	The period the transaction was last processed.	GL170, GL500, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
#`RJC-LP-YEAR` LP_YEAR	Numeric 4	Contains the fiscal year for the data stored on this record.	GL170, GL500, GL70.1, GL70.2, GL70.3, GL70.5, GL70.6, GL75.1
#`RJC-BEG-PERIOD` BEG_PERIOD	Numeric 2	This is the beginning period that the transaction is posted to.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-BEG-YEAR` BEG_YEAR	Numeric 4	This is the beginning year that the transaction is posted to.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-END-PERIOD` END_PERIOD	Numeric 2	This is the ending period that the transaction is posted to.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-END-YEAR` END_YEAR	Numeric 4	This is the ending year that the transaction is posted to.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-ENTRY-DEBITS` ENTRY_DEBITS	Signed 18.2	—	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-ENTRY-CREDITS` ENTRY_CREDITS	Signed 18.2	—	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-TRAN-ND` TRAN_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-UNIT-DEBITS` UNIT_DEBITS	Signed 15.2	The total positive detail unit amounts.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-UNIT-CREDITS` UNIT_CREDITS	Signed 15.2	The total negative detail unit amounts.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-AUTO-DEBITS` AUTO_DEBITS	Signed 18.2	—	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-AUTO-CREDITS` AUTO_CREDITS	Signed 18.2	—	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-AUTO-UNIT-DB` AUTO_UNIT_DB	Signed 15.2	The total positive detail auto reversing amounts.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +33 more
#`RJC-AUTO-UNIT-CR` AUTO_UNIT_CR	Signed 15.2	The total negative detail auto reversing amounts.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +33 more
#`RJC-POSTING-DAY` POSTING_DAY	Numeric 2	This is the day the transaction is posted in the Lawson General Ledger system. If this field is left blank, the period end-date defaults.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-OPERATOR` OPERATOR	Alpha 10	This field is used to store the login ID of the person who entered the record.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-LAST-CMT-SEQ` LAST_CMT_SEQ	Numeric 4	The sequence number of the last comment for the journal entry.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +29 more
#`RJC-BASE-ZONE` BASE_ZONE	Alpha 15	The zone within the Lawson General Ledger system where the transaction originates.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-BASE-DEBITS` BASE_DEBITS	Signed 18.2	—	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-BASE-CREDITS` BASE_CREDITS	Signed 18.2	—	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-BASE-AUTO-DB` BASE_AUTO_DB	Signed 18.2	—	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-BASE-AUTO-CR` BASE_AUTO_CR	Signed 18.2	—	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +36 more
#`RJC-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This is the recurring journal entry base currency code. If left blank, the company base currency defaults.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-BASERATE` BASERATE	Signed 14.7	The exchange rate at the time the journal entry was made. If left blank, the current exchange rate will default.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +37 more
#`RJC-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two-character code assigned to a transaction that identifies where the transaction was created.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +30 more
#`RJC-AUTO-REV` AUTO_REV	Alpha 1	When the Auto Reversal field is set to "Y," the Lawson General Ledger Closing program GL199 creates an opposite entry for this transaction in the next period.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +30 more
#`RJC-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference number associated with the transaction.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +31 more
#`RJC-DOCUMENT-NBR` DOCUMENT_NBR	Alpha 27	The document number assigned to the recurring journal entry.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +30 more
#`RJC-NET-BASE-AMT` NET_BASE_AMT	Derived	The net base amount.	—
#`RJC-NET-BASE-AREV` NET_BASE_AREV	Derived	Net base auto-reversed amount.	—
#`RJC-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	The journal book assigned to the transaction.	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +30 more
#`RJC-BRIDGE-FLAG` BRIDGE_FLAG	Alpha 1	This field determines the origin of the Recurring Entry. A No value represents that the entry was created through GL70 (Recurring Journal). A Yes value represents that the entry originated from another system. `Y` Yes `N` No	AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +29 more
#`RJC-TRAN-DESC-DFLT` TRAN_DESC_DFLT	Alpha 1	This field determines the description that appears for each transaction line. `J` Journal Header `P` Prior Transaction Line	GL70.2
#`RJC-MX-VALUE` MX_VALUE	Alpha 32 Occurs 3 Times ×3	The attribute value associated with the recurring journal.	GL70.2
#`RJC-TRANS-DAY` TRANS_DAY	Numeric 2	This field contains the journal entry transaction day.	GL70.2, GL70.6
#`RJC-BLANK` BLANK	Derived	This field consists of blank spaces. It is used to provide column headings on Drill Arounds.	—

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`RJCSET1`	`COMPANY` `JE-TYPE` `REC-GROUP`	Primary		AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (5) — lookups and parents

Relation Table Rules Condition Field map

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`

One to many (3) — child tables

Relation Table Rules Condition Field map

Rjcntrlau1

RJCNTRLAU

`RJC-COMPANY`	→	`RCU-COMPANY`
`RJC-JE-TYPE`	→	`RCU-JE-TYPE`
`RJC-REC-GROUP`	→	`RCU-REC-GROUP`
—	→	`RCU-ACTION`
—	→	`RCU-DATE`
—	→	`RCU-TIME`
—	→	`RCU-UNIQUE-I-D`

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`

Programs

Updated by (46)

AP125 Batch Release
AP126 Mass Invoice Release
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
AP30.2 Distribution Adjustments
AP30.4 Invoice Cancel
GL110 Company Copy Delete
GL146 Batch Journal Control
GL170 Recurring Journal Interface
GL197 Period, Year End GL Commitments Processing
GL40.1 Journal Entry
GL40.2 Define Journal
GL40.3 Speed Entry
GL40.7 Totals
GL40.8 Journal Entry
GL44.1 Report Currency Entry
GL45.1 Journal Control
GL500 Fiscal Year Change
GL70.1 Recurring Journal
GL70.2 Define Recurring Journal
GL70.3 Amounts Only
GL70.5 Filter
GL70.6 Recurring Copy
GL75.1 Recurring Journal Control
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA61.1 Match Invoice Approval
MA70.1 Invoice Unmatch
MA75.1 PO Invoice Cancel
MAI1.1 Invoke for MAMATCH Object

Referenced by (28)

CA00.1 Allocation Group
CA00.2 Allocation Groups
CA05.1 Allocation Code
CA05.2 Define Allocation Code
CA10.1 Allocation
CA10.2 Define Allocation
CA10.4 Line Copy
CA10.6 Allocation Copy
CA10.7 Allocation Detail
CA15.1 Allocation Control
CA15.2 Allocation Group Control
CA160 Allocation Code Interface
GL145 Journal Entry Hold Release
GL148 Zone Rebalancing
GL167 Balance Interface
GL179 Recurring Journal Closing
GL190 Journal Posting
GL191 Currency Revaluation
GL196 Report Currency Translation
GL199 Period Closing
GL238 Split Distribution Report
GL270 Recurring Journal Edit Listing
GL275 Recurring Journal Control Report
GL300 General Ledger History Delete
GL38.2 Recurring Journal Schedule
GL41.4 Workflow Journal Entry Update
GLCC.1 Print interface for Glp65pd
IFGT.1 GLTRANS Interface

RJCONTROL – Recurring Journal Control

About RJCONTROL

Fields (47) Copy as SQL

Indexes (1)

Relations

One to one (5) — lookups and parents

One to many (3) — child tables

Programs

Updated by (46)

Referenced by (28)

Fields (47)