MLCOLEDGER – Multi Book Ledger Co Ledger

System
Multi-Ledger (ML)
Prefix
MLE
Primary key
COMPANY, LEDGER
Fields
11
Updated by
16 programs
Referenced by
225 programs

MLCOLEDGER is the Multi Book Ledger Co Ledger table in Lawson Multi-Ledger (prefix MLE). It is indexed by COMPANY, LEDGER (MLESET1); alternate indexes: MLESET2. It is related 1:1 to GLSYSTEM and MLCALMAP. It is updated by GL500, ML10.1, ML110, ML12.1, ML146, ML170, ML190, ML199 and 8 more and referenced by AC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 and 217 more. The table has 11 fields, 2 indexes and 3 documented relations.

About MLCOLEDGER

The Multi Book Ledger Company Ledger file stores information on the company ledger combination, including the current period and fiscal year.

Fields (11)

Column = COBOL field name without the MLE- 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
#MLE-COMPANY PK
COMPANY		Numeric 4This is the company to which the ledger is linked to. One company can be associated with multiple ledgers. One ledger can be associated with multiple companies. ML maintains separate records for each unique company/ledger combination.ML10.1
#MLE-NAME
NAME		Alpha 30 (Lower Case)This is the company name.ML10.1
#MLE-LEDGER PK
LEDGER		Alpha 15This is the ledger. The ledger must be associated with the company on ML10. One company can be associated with multiple ledgers. One ledger can be associated with multiple companies. ML maintains separate records for each unique company/ledger combination.ML10.1, ML110
#MLE-ACCT-PERIOD
ACCT_PERIOD		Numeric 2This is the current accounting period for the ledger/company combination. It is updated by the Ledger Period Closing (ML199).GL500, ML10.1, ML12.1, ML199
#MLE-FISCAL-YEAR
FISCAL_YEAR		Numeric 4This is the current fiscal year for the ledger/company combination.GL500, ML10.1, ML12.1, ML199
#MLE-UPDATING
UPDATING		Numeric 2This is set with a value when an update program is running in GL. The value determines the program that is running. No other updates may take place while this field is not blank.ML110, ML146, ML170, ML190, ML199, ML40.1, ML40.2, ML40.3 +5 more
#MLE-LST-YR-CLOSED
LST_YR_CLOSED		Numeric 4This field contains the last closed fiscal year.—
#MLE-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1This field contains the status of the ledger. A ledger must be Active for transactions to be posted to it.ML10.1
#MLE-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
#MLE-CURR-CODE-1
CURR_CODE_1		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
#MLE-CURR-CODE-2
CURR_CODE_2		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—

Indexes (2)

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
MLESET1
  1. COMPANY
  2. LEDGER
PrimaryAC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source)
MLESET2
  1. LEDGER
  2. COMPANY
AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +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)
GLSYSTEMMLCALMAPMLCOLEDGER

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ColedgerGLSYSTEMRequired
MLE-COMPANY→GLS-COMPANY
GlsystemGLSYSTEMRequired
MLE-COMPANY→GLS-COMPANY
MlcalmapMLCALMAPRequired
MLE-LEDGER→MCM-LEDGER
MLE-COMPANY→MCM-COMPANY
MLE-FISCAL-YEAR→MCM-FISCAL-YEAR

Programs

Updated by (16)

Referenced by (225)