MLCONTROL – Multi Book Ledger Control

System: Multi-Ledger (ML)
Prefix: MLC
Primary key: LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE
Fields: 65
Updated by: 21 programs
Referenced by: 9 programs

MLCONTROL is the Multi Book Ledger Control table in Lawson Multi-Ledger (prefix MLC). It is indexed by LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE (MLCSET1); alternate indexes: MLCSET2, MLCSET3, MLCSET4, MLCSET5 and MLCSET6. It is related 1:1 to GLSYSTEM, GLSCCAT, GLSRCCODE, MLLEDGER, MLCALMAP, MLCUCNTRL, MXCATDEF and GLCODES and 1:M to MLJELOG and MLTRANS. It is updated by ML110, ML145, ML146, ML167, ML170, ML190, ML191, ML196 and 13 more and referenced by ML240, ML241, ML245, ML270, ML290, ML90.1, ML90.2, MLCC.1 and 1 more. The table has 65 fields, 6 indexes and 17 documented relations.

About MLCONTROL

The Multi Book Ledger Control file contains journal entry control information. This information is used to process the journal entry detail records.

Fields (65)

Column = COBOL field name without the MLC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`MLC-LEDGER` PK LEDGER	Alpha 15	The ledger into which the transactions are to be interfaced.	ML110, ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML41.4 +3 more
`MLC-COMPANY` PK COMPANY	Numeric 4	The company into which the transactions are to be interfaced.	ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML41.4, ML45.1 +2 more
`MLC-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	This is the current fiscal year. This field is updated by Ledger Period Closing (ML199).	ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML41.4, ML45.1 +2 more
`MLC-ACCT-PERIOD` PK ACCT_PERIOD	Numeric 2	This is the current accounting period. This field is updated by Ledger Period Closing (ML199).	ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML41.4, ML45.1 +2 more
`MLC-CONTROL-GROUP` PK CONTROL_GROUP	Numeric 8	This field displays the journal entry number used for process control of the journal entry detail.	ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML41.4, ML45.1 +2 more
`MLC-SYSTEM` PK SYSTEM	Alpha 2	A two-character code representing an application used within the Lawson system. (for example, GL = General Ledger, AP = Accounts Payable)	ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML41.4, ML45.1 +2 more
`MLC-JE-TYPE` PK JE_TYPE	Alpha 1	The journal entry type.(Normal or Intercompany).	ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML41.4, ML45.1 +2 more
`MLC-JE-TYPE-1` JE_TYPE_1	Derived	Displays the derived journal entry type.	—
`MLC-JE-SEQUENCE` PK JE_SEQUENCE	Numeric 2	Displays the derived journal type.	ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +9 more
`MLC-STATUS` STATUS	Numeric 1	This contains the processing cycle status of the assigned journal entry. `0` Unreleased `1` Released `2` Post In Progress `3` Load In Process `4` Quick Posted `5` Posted `9` History	ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +7 more
`MLC-STATUS-1` STATUS_1	Derived	This field displays the journal entry status.	—
`MLC-CNTRL-AMOUNT` CNTRL_AMOUNT	Signed 18.2	Displays the total journal entry amount.	ML146, ML190, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8, ML44.1 +1 more
`MLC-ENTRY-DB` ENTRY_DB	Signed 18.2	Displays the total journal entry debit amount.	ML146, ML167, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-ENTRY-CR` ENTRY_CR	Signed 18.2	Displays the total journal entry credit amount.	ML146, ML167, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal positions defined for the transaction currency.	ML167, ML191, ML196, ML199, ML40.2, ML40.5, ML41.3, ML45.1 +1 more
`MLC-UNIT-CNTRL-DB` UNIT_CNTRL_DB	Signed 15.2	The journal entry total for positive detail unit balances.	ML190
`MLC-UNIT-CNTRL-CR` UNIT_CNTRL_CR	Signed 15.2	The journal entry total for negative detail unit balances.	ML190
`MLC-UNIT-ENTRY-DB` UNIT_ENTRY_DB	Signed 15.2	Displays the total debit units for the journal entry.	ML146, ML167, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-UNIT-ENTRY-CR` UNIT_ENTRY_CR	Signed 15.2	Displays the total credit units for the journal entry.	ML146, ML167, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-AUTO-UNIT-DB` AUTO_UNIT_DB	Signed 15.2	The total positive detail auto reversing units amounts.	ML146, ML190, ML191, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more
`MLC-AUTO-UNIT-CR` AUTO_UNIT_CR	Signed 15.2	The total negative detail auto reversing units amounts.	ML146, ML190, ML191, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more
`MLC-DATE` DATE	Numeric 8 (yyyymmdd)	This field displays the system date when the journal entry record was created.	ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML45.1, MLIT.1
`MLC-LINE-NBR` LINE_NBR	Numeric 6	This field contains the journal entry line number.	ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +6 more
`MLC-NBR-LINES` NBR_LINES	Numeric 6	This field contains the number of detail lines for the journal entry.	ML146, ML167, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3 +5 more
`MLC-OPERATOR` OPERATOR	Alpha 10	This field is used to store the user ID of the person who created the journal entry.	ML146, ML167, ML191, ML196, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-REL-OPERATOR` REL_OPERATOR	Alpha 10	This field is used to store the user ID of the person who released the journal entry.	ML199, ML40.6, MLIT.1
`MLC-RELEASED-FLAG` RELEASED_FLAG	Alpha 1	This flag is set to Yes when a journal entry is released. If the journal entry is unreleased, this flag will not be reset; instead it serves as an indicator that the journal entry has been released at one-time.	ML190, ML199, ML40.6, MLIT.1
`MLC-HOLD-CODE` HOLD_CODE	Alpha 4	This field displays the journal hold code defined using Journal Hold Code (GL12.1). If a hold code exists for a journal entry, the journal entry cannot be posted until the hold code is removed.	ML145, ML146, ML199, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8 +3 more
`MLC-PER-DATE-FLAG` PER_DATE_FLAG	Alpha 1	This field indicates whether the period or date is derived. Valid entries are: `P` Period `D` Date	ML40.2, ML40.6, ML45.1, MLIT.1
`MLC-POSTING-DATE` POSTING_DATE	Numeric 8 (yyyymmdd)	This field displays the date assigned to the journal entry for posting.	ML146, ML167, ML191, ML196, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-LAST-CMT-SEQ` LAST_CMT_SEQ	Numeric 4	The sequence number for the last comment for the journal entry.	ML190, ML199
`MLC-LAST-LOG-SEQ` LAST_LOG_SEQ	Numeric 6	The last sequence control number.	ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
`MLC-BASE-ZONE` BASE_ZONE	Alpha 15	The base zone as assigned for interzone balance processing.	ML146, ML167, ML191, ML196, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-BASE-DEBITS` BASE_DEBITS	Signed 18.2	The total positive detail amount in the company base currency.	ML146, ML167, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-BASE-CREDITS` BASE_CREDITS	Signed 18.2	The total negative detail amount in the company base currency.	ML146, ML167, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-BASE-AUTO-DB` BASE_AUTO_DB	Signed 18.2	The total positive detail auto reversing amount in the company base currency.	ML146, ML190, ML191, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more
`MLC-BASE-AUTO-CR` BASE_AUTO_CR	Signed 18.2	The total negative detail auto reversing amount in the company base currency.	ML146, ML190, ML191, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more
`MLC-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML45.1, MLIT.1
`MLC-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field displays the transaction currency code. The company base currency code established in Company (GL10.1) defaults.	ML167, ML191, ML196, ML199, ML40.2, ML45.1, MLIT.1
`MLC-BASERATE` BASERATE	Signed 14.7	The exchange rate to convert the transaction currency to the base currency.	ML167, ML191, ML196, ML199, ML40.2, ML40.6, ML45.1, MLIT.1
`MLC-NET-BASE-AMT` NET_BASE_AMT	Derived	The net amount in the base currency.	—
`MLC-NET-BASE-AREV` NET_BASE_AREV	Derived	The net reversed in the base currency.	—
`MLC-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	The journal entry description.	ML146, ML167, ML191, ML196, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-AUTO-REV` AUTO_REV	Alpha 1	Auto reversal is the process of reversing the transaction. If you select auto reverse, the Ledger Period Closing (ML199) creates a reversing journal entry in the next period for this transaction.	ML146, ML199, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7, ML40.8 +3 more
`MLC-SOURCE-CODE` SOURCE_CODE	Alpha 2	A two-character code assigned to a transaction to identify where the transaction was created.	ML146, ML196, ML199, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8 +2 more
`MLC-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference you enter for this journal entry appears on inquiries and reports.	ML146, ML167, ML191, ML196, ML199, ML40.1, ML40.2, ML40.3 +6 more
`MLC-DOCUMENT-NBR` DOCUMENT_NBR	Alpha 27	The document number assigned to the journal entry.	ML146, ML199, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8, ML44.1 +2 more
`MLC-EFFECT-DATE` EFFECT_DATE	Numeric 8 (yyyymmdd)	The actual date of the transaction.	ML199, ML40.2
`MLC-JRNL-BOOK-NBR` JRNL_BOOK_NBR	Alpha 12	If the company uses journal books, this field displays the journal book assigned to the transaction.	ML146, ML190, ML199, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more
`MLC-JBK-SEQ-NBR` JBK_SEQ_NBR	Numeric 10	The journal book sequence number The number assigned to a journal book when it is added or interfaced to the ML system. Used only when Auto Journal Book Seq Nbr is set to Yes on Company (GL10.1).	ML40.2, ML40.6, MLIT.1
`MLC-TRAN-DESC-DFLT` TRAN_DESC_DFLT	Alpha 1	The transaction description default. Indicates if the new journal entry is a journal entry header or prior transaction line. Valid values are: `J` Journal Entry `P` Prior Transaction Line	ML146, ML199, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8, ML44.1 +1 more
`MLC-MX-VALUE` MX_VALUE	Alpha 32 Occurs 3 Times ×3	Valid transaction attributes display in this field	ML199, ML40.2
`MLC-MX-CATEGORY-1` MX_CATEGORY_1	Derived	The first attribute category associated with the transaction.	—
`MLC-MX-CATEGORY-2` MX_CATEGORY_2	Derived	The second attribute category associated with the transaction.	—
`MLC-MX-CATEGORY-3` MX_CATEGORY_3	Derived	The third attribute category associated with the transaction.	—
`MLC-MX-DESC-1` MX_DESC_1	Derived	The description for the first attribute	—
`MLC-MX-DESC-2` MX_DESC_2	Derived	The description for the second attribute	—
`MLC-MX-DESC-3` MX_DESC_3	Derived	The description for the third attribute	—
`MLC-CLOSE-SEQ` CLOSE_SEQ	Numeric 2	Contains the closing sequence number.	ML146, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6, ML40.7 +4 more
`MLC-JE-APPROVE-FLG` JE_APPROVE_FLG	Alpha 1	This field indicates if the journal entry is released.	ML146, ML170, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8, ML41.4 +3 more
`MLC-WF-JE-CTRL-NBR` WF_JE_CTRL_NBR	Derived	The workflow journal entry number.	—
`MLC-AUTO-REV-PD` AUTO_REV_PD	Numeric 2	The period auto-reverse flag.	ML146, ML199, ML40.1, ML40.2, ML40.3, ML40.7, ML40.8, ML44.1 +2 more
`MLC-REVERSE` REVERSE	Alpha 1	—	ML190
`MLC-HOLD-REM-OPER` HOLD_REM_OPER	Alpha 10	This field is used to store the login id of the person who entered the record.	ML145, ML40.2, ML45.1
`MLC-BLANK` BLANK	Derived	This field consists of blank spaces. It is used to provide column headings on Drill Arounds.	—

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`MLCSET1`	`LEDGER`, `COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`	Primary		ML110, ML146, ML167, ML170, ML190, ML191, ML196, ML199 +22 more (list truncated in source)
`MLCSET2`	`LEDGER`, `COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `STATUS`, `SYSTEM`, `CONTROL-GROUP`, `JE-TYPE`, `JE-SEQUENCE`	KeyChange		ML110, ML146, ML199, ML240, ML45.1
`MLCSET3`	`LEDGER`, `COMPANY`, `SYSTEM`, `FISCAL-YEAR`, `ACCT-PERIOD`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`	KeyChange, Subset	Where STATUS = 3	ML167
`MLCSET4`	`LEDGER`, `COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`	Subset	Where STATUS = Zeroes	ML240, ML40.1, ML40.2
`MLCSET5`	`LEDGER`, `COMPANY`, `HOLD-CODE`, `FISCAL-YEAR`, `ACCT-PERIOD`, `STATUS`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`	KeyChange, Subset	Where HOLD-CODE != Spaces	ML145, ML45.1
`MLCSET6`	`LEDGER`, `COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `CLOSE-SEQ`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`	KeyChange		ML199

Relations

One to one (13) — lookups and parents

Relation	Table	Rules	Field map
Company	GLSYSTEM	Required	`MLC-COMPANY` → `GLS-COMPANY`
Glsccat 1	GLSCCAT	Not Required	`MLC-SOURCE-CODE` → `GSC-SOURCE-CODE`, `1` → `GSC-SEQ-NBR`
Glsccat 2	GLSCCAT	Not Required	`MLC-SOURCE-CODE` → `GSC-SOURCE-CODE`, `2` → `GSC-SEQ-NBR`
Glsccat 3	GLSCCAT	Not Required	`MLC-SOURCE-CODE` → `GSC-SOURCE-CODE`, `3` → `GSC-SEQ-NBR`
Glsrccode	GLSRCCODE	Not Required	`MLC-SOURCE-CODE` → `GSR-SOURCE-CODE`
Ledger	MLLEDGER	Required	`MLC-LEDGER` → `MLL-LEDGER`
Mlcalmap	MLCALMAP	Required	`MLC-LEDGER` → `MCM-LEDGER`, `MLC-COMPANY` → `MCM-COMPANY`, `MLC-FISCAL-YEAR` → `MCM-FISCAL-YEAR`
Mlcucntrl One	MLCUCNTRL	Not Required	`MLC-LEDGER` → `MCC-LEDGER`, `MLC-COMPANY` → `MCC-COMPANY`, `MLC-FISCAL-YEAR` → `MCC-FISCAL-YEAR`, `MLC-ACCT-PERIOD` → `MCC-ACCT-PERIOD`, `MLC-SYSTEM` → `MCC-SYSTEM`, `MLC-JE-TYPE` → `MCC-JE-TYPE`, `MLC-CONTROL-GROUP` → `MCC-CONTROL-GROUP`, `MLC-JE-SEQUENCE` → `MCC-JE-SEQUENCE`, `1` → `MCC-AMT-TYPE`, `GLS-CURR-CODE-1` → `MCC-CURRENCY-CODE`
Mlcucntrl Two	MLCUCNTRL	Not Required	`MLC-LEDGER` → `MCC-LEDGER`, `MLC-COMPANY` → `MCC-COMPANY`, `MLC-FISCAL-YEAR` → `MCC-FISCAL-YEAR`, `MLC-ACCT-PERIOD` → `MCC-ACCT-PERIOD`, `MLC-SYSTEM` → `MCC-SYSTEM`, `MLC-JE-TYPE` → `MCC-JE-TYPE`, `MLC-CONTROL-GROUP` → `MCC-CONTROL-GROUP`, `MLC-JE-SEQUENCE` → `MCC-JE-SEQUENCE`, `2` → `MCC-AMT-TYPE`, `GLS-CURR-CODE-2` → `MCC-CURRENCY-CODE`
Mxcatdef 1	MXCATDEF	Required	`GSC-MATRIX-CAT` → `MXC-MATRIX-CAT`
Mxcatdef 2	MXCATDEF	Not Required	`GSC-MATRIX-CAT` → `MXC-MATRIX-CAT`
Mxcatdef 3	MXCATDEF	Not Required	`GSC-MATRIX-CAT` → `MXC-MATRIX-CAT`
System	GLCODES	Not Required	`MLC-COMPANY` → `GCD-COMPANY`, `MLC-SYSTEM` → `GCD-SYSTEM`

One to many (4) — child tables

Relation	Table	Rules	Field map
Mljelog	MLJELOG		`MLC-LEDGER` → `MJL-LEDGER`, `MLC-COMPANY` → `MJL-COMPANY`, `MLC-FISCAL-YEAR` → `MJL-FISCAL-YEAR`, `MLC-ACCT-PERIOD` → `MJL-ACCT-PERIOD`, `MLC-SYSTEM` → `MJL-SYSTEM`, `MLC-JE-TYPE` → `MJL-JE-TYPE`, `MLC-CONTROL-GROUP` → `MJL-CONTROL-GROUP`, `MLC-JE-SEQUENCE` → `MJL-JE-SEQUENCE`, → `MJL-LINE-NBR`, → `MJL-LOG-SEQ-NBR`
Mljelog Cntrl	MLJELOG		`MLC-LEDGER` → `MJL-LEDGER`, `MLC-COMPANY` → `MJL-COMPANY`, `MLC-FISCAL-YEAR` → `MJL-FISCAL-YEAR`, `MLC-ACCT-PERIOD` → `MJL-ACCT-PERIOD`, `MLC-SYSTEM` → `MJL-SYSTEM`, `MLC-JE-TYPE` → `MJL-JE-TYPE`, `MLC-CONTROL-GROUP` → `MJL-CONTROL-GROUP`, `MLC-JE-SEQUENCE` → `MJL-JE-SEQUENCE`, `Zeroes` → `MJL-LINE-NBR`, → `MJL-LOG-SEQ-NBR`
Mljelog Line	MLJELOG		`MLC-LEDGER` → `MJL-LEDGER`, `MLC-COMPANY` → `MJL-COMPANY`, `MLC-FISCAL-YEAR` → `MJL-FISCAL-YEAR`, `MLC-ACCT-PERIOD` → `MJL-ACCT-PERIOD`, `MLC-SYSTEM` → `MJL-SYSTEM`, `MLC-JE-TYPE` → `MJL-JE-TYPE`, `MLC-CONTROL-GROUP` → `MJL-CONTROL-GROUP`, `MLC-JE-SEQUENCE` → `MJL-JE-SEQUENCE`, → `MJL-LINE-NBR`, → `MJL-LOG-SEQ-NBR`
Mltrans	MLTRANS	Delete Cascades	`MLC-LEDGER` → `MLT-LEDGER`, `MLC-COMPANY` → `MLT-COMPANY`, `MLC-FISCAL-YEAR` → `MLT-FISCAL-YEAR`, `MLC-ACCT-PERIOD` → `MLT-ACCT-PERIOD`, `MLC-SYSTEM` → `MLT-SYSTEM`, `MLC-JE-TYPE` → `MLT-JE-TYPE`, `MLC-CONTROL-GROUP` → `MLT-CONTROL-GROUP`, `MLC-JE-SEQUENCE` → `MLT-JE-SEQUENCE`, → `MLT-LINE-NBR`, → `MLT-OBJ-ID`

Programs

Updated by (21)

ML110 Ledger Company Copy Delete
ML145 Ledger Journal Hold Release
ML146 Batch Ledger Journal Control
ML167 Ledger Balance Interface
ML170 Ledger Recurring Journal Interface
ML190 Ledger Journal Posting
ML191 Ledger Currency Revaluation
ML196 Ledger Report Currency Translation
ML199 Ledger Period Closing
ML300 Ledger History Delete
ML40.1 Ledger Journal Entry
ML40.2 Define Ledger Journal
ML40.3 Ledger Speed Entry
ML40.6 Ledger Journal Copy
ML40.7 Ledger Totals
ML40.8 Ledger Journal Entry
ML41.4 Ledger Workflow Journal Entry Update
ML44.1 Ledger Report Currency Entry
ML45.1 Ledger Journal Control
ML75.1 Ledger Recurring Journal Control
MLIT.1 General Ledger Account Edit

Referenced by (9)

ML240 Ledger Journal Edit Listing
ML241 Ledger Period Transaction List
ML245 Ledger Journal Control Report
ML270 Ledger Recurring Jrnl Edit Lis
ML290 Ledger Report
ML90.1 Ledger Transaction Analysis
ML90.2 Ledger Transaction Totals
MLCC.1 Print interface for Glp65pd
MLJR.1 Interface JE Report