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.

Field / column	Type	Description & values	Updated by
`MLE-COMPANY` PK COMPANY	Numeric 4	This 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 15	This 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 2	This 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 4	This is the current fiscal year for the ledger/company combination.	GL500, ML10.1, ML12.1, ML199
`MLE-UPDATING` UPDATING	Numeric 2	This 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 4	This field contains the last closed fiscal year.	—
`MLE-ACTIVE-STATUS` ACTIVE_STATUS	Alpha 1	This 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 5	This field contains the company base currency code established in Company (GL10.1 ).	—
`MLE-CURR-CODE-1` CURR_CODE_1	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	—
`MLE-CURR-CODE-2` CURR_CODE_2	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	—

Indexes (2)

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

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Coledger	GLSYSTEM	Required	`MLE-COMPANY` → `GLS-COMPANY`
Glsystem	GLSYSTEM	Required	`MLE-COMPANY` → `GLS-COMPANY`
Mlcalmap	MLCALMAP	Required	`MLE-LEDGER` → `MCM-LEDGER`, `MLE-COMPANY` → `MCM-COMPANY`, `MLE-FISCAL-YEAR` → `MCM-FISCAL-YEAR`

Programs

Updated by (16)

GL500 Fiscal Year Change
ML10.1 Ledger Setup
ML110 Ledger Company Copy Delete
ML12.1 Ledger Calendar Map
ML146 Batch Ledger Journal Control
ML170 Ledger Recurring Journal Interface
ML190 Ledger Journal Posting
ML199 Ledger Period Closing
ML40.1 Ledger Journal Entry
ML40.2 Define Ledger Journal
ML40.3 Ledger Speed Entry
ML40.7 Ledger Totals
ML40.8 Ledger Journal Entry
ML44.1 Ledger Report Currency Entry
ML45.1 Ledger Journal Control
ML75.1 Ledger Recurring Journal Control

Referenced by (225)

AC121 Budget Calculation
AC123 Budget Copy
AC130 Allocation Calculation
AC191 Accounting Unit Balance Post
AC20.1 Life Only Budget
AC20.2 Annual Budget
AC20.3 Period Budget
AC20.4 Activity Budgets by Activity
AC20.5 Activity Budgets by Account Category
AC32.1 Allocation Pool
AC37.1 Allocation Group
AC490 Activity Reconciliation
ACVW.1 Build GL Accounting Unit View
AD191 Cost of Funds
AM180 Depreciation Calculation and Listing
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
API1.1 Add Invoice
API2.1 Add Invoice
ATVW.1 Build Account Category View
BR44.1 Mass Transaction Transfer
CA10.5 Allocation Calculation
CA110 Allocation Calculation
CB222 Cash Position Reconciliation
DR100 Distribution Requirements Report
FB100 Budget Calculation - Computes
FB11.1 Budget Edit Group
FB111 Budget Edit Group Build
FB160 Budget Edit Group Interface
FB20.1 Period Budget, Rate
FB20.6 Period Budget, Amounts
FB20.7 Period Budget, Units
FB21.1 Budget by Period
FB211 Budget Edit Group Listing
FB296 Budget Audit
FB60.1 Budget Edit Group Interface Maintenance
FB95.1 Budget Analysis
FB95.2 Account, Period
FB95.3 Account, Year to Date
FB95.4 Accounting Unit, Period
FB95.5 Accounting Unit, Year to Date
FB95.6 Totals
GL110 Company Copy Delete
GL120 Level Reorganization
GL165 Transaction Interface
GL298 GL Commitment Analysis Report
GL299 GL and AC History commitment
GL310 Report Currency Purge
GL65.1 Transaction Interface Maintenance
GL90.6 Compare Transaction Analysis
GL94.1 Commitment Analysis
GL94.2 Account
GL94.3 Account Totals
GL94.4 Accounting Unit
GL94.5 Accounting Unit Totals
GL94.6 Commitment Account Detail
GL94.7 Commitment Accounting Unit Detail
GL95.1 Account Analysis
GL95.2 Fiscal Year Summary
GL95.3 Totals
GL95.4 Chart Query
GL95.5 Periods versus Year to Date
GL95.6 Year to Date Current Year versus Last Year
GL95.7 Periods Current Year versus Last Year
GL95.8 Year to Date Actual versus Budget
GL95.9 Periods Actual versus Budget
GL96.1 Accounting Units
GL96.2 Year to Date Current Year versus Last Year
GL96.3 Periods Current Year versus Last Year
GL96.4 Year to Date Actual versus Budget
GL96.5 Periods Actual versus Budget
GL97.1 Accounts
GL97.2 Year to Date Current Year versus Last Year
GL97.3 Periods Current Year versus Last Year
GL97.4 Year to Date Actual versus Budget
GL97.5 Periods Actual versus Budget
GL97.6 Year to Date Account Currencies
GL97.7 Periods Account Currencies
GL97.8 Fiscal Year Summary
GL97.9 Totals
GL98.1 Companies
GL98.2 Year to Date Current Year versus Last Year
GL98.3 Periods Current Year versus Last Year
GL98.4 Year to Date Actual versus Budget
GL98.5 Periods Actual versus Budget
GL99.1 Organization Query
GL99.2 Periods versus Year to Date
GL99.3 Year to Date Current Year versus Last Year
GL99.4 Periods Current Year versus Last Year
GL99.5 Year to Date Actual versus Budget
GL99.6 Periods Actual versus Budget
GLAV.1 Build GL Accounting Unit View
GLCV.1 General Ledger Chart View Build
GLVW.1 Build GL Accounting Unit View
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC222 Unreleased Documents
IC83.1 Par Location Counts
IFAC.1 General Ledger Account Edit
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
MAI1.1 Invoke for MAMATCH Object
ML145 Ledger Journal Hold Release
ML165 Ledger Transaction Interface
ML167 Ledger Balance Interface
ML191 Ledger Currency Revaluation
ML195 Ledger Translation Calculation
ML196 Ledger Report Currency Translation
ML210 Ledger Listing
ML212 ML Calendar Map Listing
ML240 Ledger Journal Edit Listing
ML241 Ledger Period Transaction List
ML245 Ledger Journal Control Report
ML250 Ledger Report Listing
ML267 Ledger Balance Interface List
ML270 Ledger Recurring Jrnl Edit Lis
ML275 Ledger Recurring Jrnl Cntrl Rp
ML290 Ledger Report
ML291 Ledger Trial Balance
ML292 Ledger Balance Sheet
ML293 Ledger Income Statement
ML300 Ledger History Delete
ML320 Ledger Consolidation File Creation
ML325 Ledger AMOUNTS, UNITS Rebuild
ML327 Ledger Report Currency Rebuild
ML330 Ledger Undistributed RE Rebuil
ML41.1 Ledger Journal Analysis
ML41.3 Filter
ML41.4 Ledger Workflow Journal Entry Update
ML42.1 Ledger Journal Entry Log
ML50.1 Ledger Report Setup
ML50.2 Define Ledger Report
ML50.4 Filters
ML50.5 Copy
ML65.1 Ledger Transaction Interface Maintenance
ML65.3 Report Currency Entry
ML67.1 Ledger Balance Interface Maintenace
ML70.1 Ledger Recurring Journal
ML70.2 Define Recurring Journal
ML70.3 Amounts Only
ML70.5 Filter
ML70.6 Ledger Recurring Copy
ML90.1 Ledger Transaction Analysis
ML90.2 Ledger Transaction Totals
ML90.3 Filter
ML90.4 Reconcile Ledger Transactions
ML90.5 Nulls
ML94.1 Ytd Ml and Gl Actuals
ML94.2 Period ML and GL Actuals
ML94.3 YTD ML and GL Actuals
ML94.4 Period ML and GL Actuals
ML95.1 Ledger Account Analysis
ML95.2 Fiscal Year Summary
ML95.3 Totals
ML95.4 Ledger Chart Query
ML95.5 Periods vs. YTD
ML95.6 YTD Current Year vs. Last Year
ML95.7 Periods Current Year vs. Last Year
ML95.8 YTD Actual vs. Budget
ML95.9 Periods Actual vs. Budget
ML96.1 Accounting Units
ML96.2 YTD Current Year vs. Last Year
ML96.3 Periods Current Year vs. Last Year
ML96.4 YTD Actual vs. Budget
ML96.5 Periods Actual vs. Budget
ML97.1 Accounts
ML97.2 YTD Current Year vs. Last Year
ML97.3 Periods Current Year vs. Last Year
ML97.4 YTD Actual vs. Budget
ML97.5 Periods Actual vs. Budget
ML97.6 YTD Account Currencies
ML97.7 Periods Account Currencies
ML97.8 Fiscal Year Summary
ML97.9 Totals
ML98.1 Companies
ML98.2 YTD Current Year vs. Last Year
ML98.3 Periods Current Year vs. Last Year
ML98.4 YTD Actual vs. Budget
ML98.5 Periods Actual vs. Budget
ML99.1 Organization Query
ML99.2 Periods vs. YTD
ML99.3 YTD Current Year vs. Last Year
ML99.4 Periods Current Year vs. Last Year
ML99.5 YTD Actual vs. Budget
ML99.6 Periods Actual vs. Budget
MLFC.1 General Ledger Account Edit
MLIT.1 General Ledger Account Edit
RQ10.1 Requisition
RQ10.3 Select and Copy
RQ11.1 Kit Accessories
RQ13.2 Direct Line Approval
RQ35.1 Requisition Returns
RQ500 Requisition Interface
RQIB.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQIJ.1 Requisition Copy
RW100 Report Generation
RW230 Ratio Listing
RW270 Total Name Listing
RW30.1 Ratio Definition
RW70.1 Total Names
RW80.1 Drill Around
SLVW.1 Build SL Accounting Unit View
SNOA.1 RETRIEVE ACTUALS
SNRA.1 RETRIEVE ACTUALS
SNSA.1 RETRIEVE ACTUALS