MLRJCNTRL – ML Recurring Control

System: Multi-Ledger (ML)
Prefix: MRC
Primary key: LEDGER, COMPANY, JE-TYPE, REC-GROUP
Fields: 47
Updated by: 8 programs
Referenced by: 6 programs

MLRJCNTRL is the ML Recurring Control table in Lawson Multi-Ledger (prefix MRC). It is indexed by LEDGER, COMPANY, JE-TYPE, REC-GROUP (MRCSET1). It is related 1:1 to GLSYSTEM, MLCOLEDGER and MLRJTRANS. It is updated by ML110, ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6 and ML75.1 and referenced by ML270, ML275, ML40.1, ML40.3, MLCC.1 and MLIT.1. The table has 47 fields, 1 index and 3 documented relations.

About MLRJCNTRL

This file contains recurring journal entry control information defined in Ledger Recurring Journal (ML70.1). This information is used to process the recurring journal entry detail records.

Fields (47)

Column = COBOL field name without the MRC- 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
#`MRC-LEDGER` PK LEDGER	Alpha 15	The ledger being posted to.	ML110, ML70.2, ML70.6, MLCC.1
#`MRC-COMPANY` PK COMPANY	Numeric 4	The company for which recurring journal entries are posted. It must be linked to the ledger on Ledger Setup (ML10.1).	ML70.2, ML70.6, MLCC.1
#`MRC-JE-TYPE` PK JE_TYPE	Alpha 1	The type of journal entry. Valid values are Normal and Intercompany.	ML70.2, ML70.6, MLCC.1
#`MRC-REC-GROUP` PK REC_GROUP	Numeric 8	The recurring journal entry number.	ML70.2, ML70.6, MLCC.1
#`MRC-STATUS` STATUS	Numeric 1	This field contains the recurring journal entry status.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-LINE-NBR` LINE_NBR	Numeric 6	This field contains the recurring journal entry line number.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRC-NBR-LINES` NBR_LINES	Numeric 6	This field contains the number of detail lines in the recurring journal entry.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRC-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the recurring journal entry line description.	ML70.2, ML70.6
#`MRC-AUTO-ZERO` AUTO_ZERO	Alpha 1	This field is used to determine if amounts are to be zeroed out after processing.	ML70.2, ML70.6
#`MRC-POST-PERIOD` POST_PERIOD	Alpha 1 Occurs 13 Times ×13	These fields contain the periods you want the allocation to be processed in.	ML70.2, ML70.6
#`MRC-LP-PERIOD` LP_PERIOD	Numeric 2	The period the transaction was last processed.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-LP-YEAR` LP_YEAR	Numeric 4	The year the transaction was last processed.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-BEG-PERIOD` BEG_PERIOD	Numeric 2	This is the beginning period the transaction is to be posted to.	ML70.2, ML70.6
#`MRC-BEG-YEAR` BEG_YEAR	Numeric 4	This is the beginning year the transaction is to be posted to.	ML70.2, ML70.6
#`MRC-END-PERIOD` END_PERIOD	Numeric 2	This is the ending period the transaction is to be posted to.	ML70.2, ML70.6
#`MRC-END-YEAR` END_YEAR	Numeric 4	This is the ending year the transaction is to be posted to.	ML70.2, ML70.6
#`MRC-ENTRY-DEBITS` ENTRY_DEBITS	Signed 18.2	The total debit (positive) detail amounts.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-ENTRY-CREDITS` ENTRY_CREDITS	Signed 18.2	The total credit (negative) detail amounts.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal positions for the transaction currency.	ML70.2, ML70.6
#`MRC-UNIT-DEBITS` UNIT_DEBITS	Signed 15.2	The total debit (positive) detail unit amounts.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-UNIT-CREDITS` UNIT_CREDITS	Signed 15.2	The total credit (negative) detail unit amounts.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-AUTO-DEBITS` AUTO_DEBITS	Signed 18.2	The total debit (positive) detail auto reversing amounts.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-AUTO-CREDITS` AUTO_CREDITS	Signed 18.2	The total credit (negative) detail auto reversing amounts.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-AUTO-UNIT-DB` AUTO_UNIT_DB	Signed 15.2	The total debit (positive) detail auto reversing unit amounts.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRC-AUTO-UNIT-CR` AUTO_UNIT_CR	Signed 15.2	The total credit (negative) detail auto reversing unit amounts.	ML70.1, ML70.2, ML70.3, ML70.6
#`MRC-POSTING-DAY` POSTING_DAY	Numeric 2	This is the day the transaction is to be posted in the Lawson Multi-Ledger application. If this field is left blank, the period end date defaults.	ML70.2, ML70.6
#`MRC-OPERATOR` OPERATOR	Alpha 10	This field is used to store the user id of the period who entered the record.	ML70.2, ML70.6
#`MRC-LAST-CMT-SEQ` LAST_CMT_SEQ	Numeric 4	The sequence number of the last comment for the journal entry.	—
#`MRC-BASE-ZONE` BASE_ZONE	Alpha 15	The zone within the Lawson General Ledger application where the transaction is originating.	ML70.2, ML70.6
#`MRC-BASE-DEBITS` BASE_DEBITS	Signed 18.2	The total debit (positive) detail amount in the company base currency.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-BASE-CREDITS` BASE_CREDITS	Signed 18.2	The total credit (negative) detail amount in the company base currency.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-BASE-AUTO-DB` BASE_AUTO_DB	Signed 18.2	The total debit (positive) detail auto reversing amount in the company base currency.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-BASE-AUTO-CR` BASE_AUTO_CR	Signed 18.2	The total credit (negative) detail auto reversing amount in the company base currency.	ML170, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions for the base currency.	ML70.2, ML70.6
#`MRC-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	The transaction currency code.	ML70.2, ML70.6
#`MRC-BASERATE` BASERATE	Signed 14.7	This field displays the exchange rate between the transaction currency and the base currency. If this field is left blank, the program retrieves the exchange rate in effect for the transaction date from the applicable exchange rate table.	ML170, ML270, ML70.1, ML70.2, ML70.3, ML70.5, ML70.6, ML75.1
#`MRC-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two character code assigned to a transaction to identify where the transaction was created.	ML70.2
#`MRC-AUTO-REV` AUTO_REV	Alpha 1	When the Auto Reversal field is set to Yes, Ledger Period Closing (ML199) creates an opposite entry for this transaction in the next period.	ML70.2
#`MRC-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference number associated with the transaction.	ML70.2, ML70.6
#`MRC-DOCUMENT-NBR` DOCUMENT_NBR	Alpha 27	The document number associated with the transaction.	ML70.2
#`MRC-NET-BASE-AMT` NET_BASE_AMT	Derived	The net base amount.	—
#`MRC-NET-BASE-AREV` NET_BASE_AREV	Derived	The net base auto-reverse amount.	—
#`MRC-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	The journal book associated with the transaction.	ML70.2
#`MRC-BRIDGE-FLAG` BRIDGE_FLAG	Alpha 1	This field determines the origin of the recurring entry. A No value indicates that the entry was created through Ledger Recurring Journal) ML70.1). A Yes value indicates that the entry originated from another application. Currently, only GL70.1 can create recurring journal entries.	—
#`MRC-TRAN-DESC-DFLT` TRAN_DESC_DFLT	Alpha 1	This field determines the default description that appears for each transaction line.	ML70.2
#`MRC-MX-VALUE` MX_VALUE	Alpha 32 Occurs 3 Times ×3	This field contains the attribute value (or values) associated with the transaction.	ML70.2
#`MRC-TRANS-DAY` TRANS_DAY	Numeric 2	This field contains the journal entry transaction day.	ML70.2, ML70.6

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
`MRCSET1`	`LEDGER` `COMPANY` `JE-TYPE` `REC-GROUP`	Primary		ML110, ML170, ML270, ML275, ML40.1, ML40.3, ML70.1, ML70.2 +6 more

Relations

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

One to one (3) — lookups and parents

Relation Table Rules Condition Field map

Company

GLSYSTEM

Required

MRC-COMPANY → GLS-COMPANY

Mlcoledger

MLCOLEDGER

Required

`MRC-LEDGER`	→	`MLE-LEDGER`
`MRC-COMPANY`	→	`MLE-COMPANY`

Mlrjtrans

MLRJTRANS

Not Required, Delete Cascades

`MRC-LEDGER`	→	`MRT-LEDGER`
`MRC-COMPANY`	→	`MRT-COMPANY`
`MRC-REC-GROUP`	→	`MRT-REC-GROUP`
`MRC-JE-TYPE`	→	`MRT-JE-TYPE`
`MRC-LINE-NBR`	→	`MRT-LINE-NBR`

Programs

Updated by (8)

ML110 Ledger Company Copy Delete
ML170 Ledger Recurring Journal Interface
ML70.1 Ledger Recurring Journal
ML70.2 Define Recurring Journal
ML70.3 Amounts Only
ML70.5 Filter
ML70.6 Ledger Recurring Copy
ML75.1 Ledger Recurring Journal Control

Referenced by (6)

ML270 Ledger Recurring Jrnl Edit Lis
ML275 Ledger Recurring Jrnl Cntrl Rp
ML40.1 Ledger Journal Entry
ML40.3 Ledger Speed Entry
MLCC.1 Print interface for Glp65pd
MLIT.1 General Ledger Account Edit

MLRJCNTRL – ML Recurring Control

About MLRJCNTRL

Fields (47) Copy as SQL

Indexes (1)

Relations

One to one (3) — lookups and parents

Programs

Updated by (8)

Referenced by (6)

Fields (47)