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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MLC-LEDGER PK
LEDGER		Alpha 15The 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 4The 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 4This 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 2This 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 8This 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 2A 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 1The 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		DerivedDisplays the derived journal entry type.—
#MLC-JE-SEQUENCE PK
JE_SEQUENCE		Numeric 2Displays the derived journal type.ML146, ML167, ML190, ML191, ML196, ML199, ML40.1, ML40.2 +9 more
#MLC-STATUS SET2 SET5
STATUS		Numeric 1This 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		DerivedThis field displays the journal entry status.—
#MLC-CNTRL-AMOUNT
CNTRL_AMOUNT		Signed 18.2Displays 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.2Displays 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.2Displays 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 1The 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.2The journal entry total for positive detail unit balances.ML190
#MLC-UNIT-CNTRL-CR
UNIT_CNTRL_CR		Signed 15.2The journal entry total for negative detail unit balances.ML190
#MLC-UNIT-ENTRY-DB
UNIT_ENTRY_DB		Signed 15.2Displays 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.2Displays 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.2The 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.2The 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 6This 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 6This 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 10This 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 10This 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 1This 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 SET5
HOLD_CODE		Alpha 4This 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 1This 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 4The sequence number for the last comment for the journal entry.ML190, ML199
#MLC-LAST-LOG-SEQ
LAST_LOG_SEQ		Numeric 6The last sequence control number.ML146, ML190, ML191, ML199, ML40.1, ML40.2, ML40.3, ML40.6 +5 more
#MLC-BASE-ZONE
BASE_ZONE		Alpha 15The 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.2The 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.2The 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.2The 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.2The 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 1The 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 5This 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.7The 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		DerivedThe net amount in the base currency.—
#MLC-NET-BASE-AREV
NET_BASE_AREV		DerivedThe 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 1Auto 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 2A 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 27The 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 12If 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 10The 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 1The 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 ×3Valid transaction attributes display in this fieldML199, ML40.2
#MLC-MX-CATEGORY-1
MX_CATEGORY_1		DerivedThe first attribute category associated with the transaction.—
#MLC-MX-CATEGORY-2
MX_CATEGORY_2		DerivedThe second attribute category associated with the transaction.—
#MLC-MX-CATEGORY-3
MX_CATEGORY_3		DerivedThe third attribute category associated with the transaction.—
#MLC-MX-DESC-1
MX_DESC_1		DerivedThe description for the first attribute—
#MLC-MX-DESC-2
MX_DESC_2		DerivedThe description for the second attribute—
#MLC-MX-DESC-3
MX_DESC_3		DerivedThe description for the third attribute—
#MLC-CLOSE-SEQ SET6
CLOSE_SEQ		Numeric 2Contains 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 1This 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		DerivedThe workflow journal entry number.—
#MLC-AUTO-REV-PD
AUTO_REV_PD		Numeric 2The 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 10This field is used to store the login id of the person who entered the record.ML145, ML40.2, ML45.1
#MLC-BLANK
BLANK		DerivedThis field consists of blank spaces. It is used to provide column headings on Drill Arounds.—

Indexes (6)

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.

IndexKeysFlagsConditionUsed in
MLCSET1
  1. LEDGER
  2. COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. SYSTEM
  6. JE-TYPE
  7. CONTROL-GROUP
  8. JE-SEQUENCE
PrimaryML110, ML146, ML167, ML170, ML190, ML191, ML196, ML199 +22 more (list truncated in source)
MLCSET2
  1. LEDGER
  2. COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. STATUS
  6. SYSTEM
  7. CONTROL-GROUP
  8. JE-TYPE
  9. JE-SEQUENCE
KeyChangeML110, ML146, ML199, ML240, ML45.1
MLCSET3
  1. LEDGER
  2. COMPANY
  3. SYSTEM
  4. FISCAL-YEAR
  5. ACCT-PERIOD
  6. JE-TYPE
  7. CONTROL-GROUP
  8. JE-SEQUENCE
KeyChange, SubsetWhere STATUS = 3ML167
MLCSET4
  1. LEDGER
  2. COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. SYSTEM
  6. JE-TYPE
  7. CONTROL-GROUP
  8. JE-SEQUENCE
SubsetWhere STATUS = ZeroesML240, ML40.1, ML40.2
MLCSET5
  1. LEDGER
  2. COMPANY
  3. HOLD-CODE
  4. FISCAL-YEAR
  5. ACCT-PERIOD
  6. STATUS
  7. SYSTEM
  8. JE-TYPE
  9. CONTROL-GROUP
  10. JE-SEQUENCE
KeyChange, SubsetWhere HOLD-CODE != SpacesML145, ML45.1
MLCSET6
  1. LEDGER
  2. COMPANY
  3. FISCAL-YEAR
  4. ACCT-PERIOD
  5. CLOSE-SEQ
  6. SYSTEM
  7. JE-TYPE
  8. CONTROL-GROUP
  9. JE-SEQUENCE
KeyChangeML199

Relations

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

One to one (13) — lookups and parents

RelationTableRulesConditionField map
CompanyGLSYSTEMRequired
MLC-COMPANY→GLS-COMPANY
Glsccat 1GLSCCATNot Required
MLC-SOURCE-CODE→GSC-SOURCE-CODE
1→GSC-SEQ-NBR
Glsccat 2GLSCCATNot Required
MLC-SOURCE-CODE→GSC-SOURCE-CODE
2→GSC-SEQ-NBR
Glsccat 3GLSCCATNot Required
MLC-SOURCE-CODE→GSC-SOURCE-CODE
3→GSC-SEQ-NBR
GlsrccodeGLSRCCODENot Required
MLC-SOURCE-CODE→GSR-SOURCE-CODE
LedgerMLLEDGERRequired
MLC-LEDGER→MLL-LEDGER
MlcalmapMLCALMAPRequired
MLC-LEDGER→MCM-LEDGER
MLC-COMPANY→MCM-COMPANY
MLC-FISCAL-YEAR→MCM-FISCAL-YEAR
Mlcucntrl OneMLCUCNTRLNot 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 TwoMLCUCNTRLNot 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 1MXCATDEFRequired
GSC-MATRIX-CAT→MXC-MATRIX-CAT
Mxcatdef 2MXCATDEFNot Required
GSC-MATRIX-CAT→MXC-MATRIX-CAT
Mxcatdef 3MXCATDEFNot Required
GSC-MATRIX-CAT→MXC-MATRIX-CAT
SystemGLCODESNot Required
MLC-COMPANY→GCD-COMPANY
MLC-SYSTEM→GCD-SYSTEM

One to many (4) — child tables

RelationTableRulesConditionField map
MljelogMLJELOG
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 CntrlMLJELOG
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 LineMLJELOG
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
MltransMLTRANSDelete 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)

Referenced by (9)