Multi-Ledger – Lawson ML tables and programs
Multi-Ledger (ML) in Lawson S3 v10 MSP6 has 26 tables, 84 online screens and 32 batch programs.
Tables (26)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| MCMBOD | MBD | No description in the Lawson data dictionary | LEDGER, COMPANY, FISCAL-YEAR | 9 |
| MLAMOUNTS | MLA | Multi-Book Ledger Amounts | LEDGER, COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 79 |
| MLCALMAP | MCM | Multi-Book Ledger Calendar Map | LEDGER, COMPANY, FISCAL-YEAR | 63 |
| MLCLSAUDIT | MCL | Multi-Book Ledger Close Audit | LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, CLOSE-SEQ | 8 |
| MLCOLEDGER | MLE | Multi Book Ledger Co Ledger | COMPANY, LEDGER | 11 |
| MLCONSOL | MCN | Multi Book Ledger Consolidated | FISCAL-YEAR, LEVEL-DEPTH, TRANS-TYPE, LEDGER, COMPANY, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, CURRENCY-CODE | 79 |
| MLCONTROL | MLC | Multi Book Ledger Control | LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE | 65 |
| MLCUAMOUNT | MCA | ML Ledger Currency Amount | FISCAL-YEAR, LEDGER, COMPANY, AMT-TYPE, VAR-LEVELS, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT, CURRENCY-CODE | 124 |
| MLCUCNTRL | MCC | Ml Ledger Currency Control | LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, AMT-TYPE, CURRENCY-CODE | 14 |
| MLGROUP | MLG | ML Group | LEDGER-GROUP | 3 |
| MLGRPDTL | MGD | Multi Ledger Group Detail | LEDGER-GROUP, LEDGER | 2 |
| MLJELOG | MJL | Multi Ledger Journal Entry Log | LEDGER, COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, LINE-NBR, LOG-SEQ-NBR | 22 |
| MLLEDGER | MLL | Multi Book Ledger | LEDGER | 3 |
| MLMASTREL | MMR | ML Balance Interface | LEDGER, COMPANY, FISCAL-YEAR, OLD-COMPANY, OLD-ACCT-NBR, TRAN-CURR | 23 |
| MLMONITOR | MLN | ML Monitor | PROGRAM, LEDGER, COMPANY, PROGRAM-KEY | 10 |
| MLMXVALUE | MLV | ML Attribute Value | OBJ-ID, MATRIX-CAT | 3 |
| MLRJCNTRL | MRC | ML Recurring Control | LEDGER, COMPANY, JE-TYPE, REC-GROUP | 47 |
| MLRJMXVAL | MRM | ML Recurring Attribute Values | LEDGER, COMPANY, REC-GROUP, JE-TYPE, LINE-NBR, MATRIX-CAT | 7 |
| MLRJTRANS | MRT | ML Recurring Transactions | LEDGER, COMPANY, REC-GROUP, JE-TYPE, LINE-NBR | 21 |
| MLRPTDEF | MLR | Multi Ledger Report Definition | LEDGER, COMPANY, REPORT-NAME | 16 |
| MLRPTSEL | MRS | ML Report Selection | LEDGER, COMPANY, REPORT-NAME, OR-GROUP, ITEM-NUMBER, SEQUENCE-NBR | 9 |
| MLSYSJE | MSJ | ML Company Journal Entry | LEDGER, COMPANY, SYSTEM, FISCAL-YEAR, ACCT-PERIOD | 7 |
| MLTRANS | MLT | ML Transactions | OBJ-ID | 54 |
| MLTRANSREL | MTR | ML Transaction Interface | RUN-GROUP, SEQ-NUMBER | 37 |
| MLULPOST | MUP | ML Post Acct Unit Total | LEDGER, COMPANY | 4 |
| MLUNITS | MLU | ML Units | LEDGER, COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | 76 |
Online screens (84)
| Screen | Description | Updates | References |
|---|---|---|---|
| ML10.1 | Ledger Setup | 4 | 6 |
| ML11.1 | Ledger Group | 2 | 4 |
| ML11.2 | Define Ledger Group | 1 | 1 |
| ML12.1 | Ledger Calendar Map | 3 | 8 |
| ML12.2 | Backposting Control | 2 | 6 |
| ML15.1 | Ledger MLMONITOR Maintenance | 1 | 0 |
| ML40.1 | Ledger Journal Entry | 25 | 64 |
| ML40.2 | Define Ledger Journal | 26 | 64 |
| ML40.3 | Ledger Speed Entry | 24 | 61 |
| ML40.4 | Ledger Additional Information | 1 | 8 |
| ML40.5 | Ledger Other Totals | 1 | 9 |
| ML40.6 | Ledger Journal Copy | 10 | 13 |
| ML40.7 | Ledger Totals | 24 | 61 |
| ML40.8 | Ledger Journal Entry | 25 | 63 |
| ML41.1 | Ledger Journal Analysis | 1 | 9 |
| ML41.3 | Filter | 1 | 9 |
| ML41.4 | Ledger Workflow Journal Entry Update | 2 | 7 |
| ML42.1 | Ledger Journal Entry Log | 1 | 8 |
| ML44.1 | Ledger Report Currency Entry | 25 | 62 |
| ML45.1 | Ledger Journal Control | 27 | 64 |
| ML45.3 | Filter | 0 | 1 |
| ML50.1 | Ledger Report Setup | 2 | 8 |
| ML50.2 | Define Ledger Report | 3 | 7 |
| ML50.4 | Filters | 3 | 15 |
| ML50.5 | Copy | 3 | 7 |
| ML65.1 | Ledger Transaction Interface Maintenance | 3 | 31 |
| ML65.3 | Report Currency Entry | 1 | 7 |
| ML67.1 | Ledger Balance Interface Maintenace | 2 | 9 |
| ML70.1 | Ledger Recurring Journal | 6 | 19 |
| ML70.2 | Define Recurring Journal | 8 | 19 |
| ML70.3 | Amounts Only | 6 | 19 |
| ML70.5 | Filter | 4 | 12 |
| ML70.6 | Ledger Recurring Copy | 5 | 17 |
| ML75.1 | Ledger Recurring Journal Control | 6 | 14 |
| ML90.1 | Ledger Transaction Analysis | 1 | 15 |
| ML90.2 | Ledger Transaction Totals | 1 | 10 |
| ML90.3 | Filter | 1 | 9 |
| ML90.4 | Reconcile Ledger Transactions | 2 | 13 |
| ML90.5 | Nulls | 1 | 10 |
| ML94.1 | Ytd Ml and Gl Actuals | 3 | 24 |
| ML94.2 | Period ML and GL Actuals | 3 | 24 |
| ML94.3 | YTD ML and GL Actuals | 3 | 24 |
| ML94.4 | Period ML and GL Actuals | 3 | 24 |
| ML95.1 | Ledger Account Analysis | 3 | 24 |
| ML95.2 | Fiscal Year Summary | 3 | 24 |
| ML95.3 | Totals | 3 | 24 |
| ML95.4 | Ledger Chart Query | 13 | 33 |
| ML95.5 | Periods vs. YTD | 3 | 24 |
| ML95.6 | YTD Current Year vs. Last Year | 3 | 24 |
| ML95.7 | Periods Current Year vs. Last Year | 3 | 24 |
| ML95.8 | YTD Actual vs. Budget | 3 | 24 |
| ML95.9 | Periods Actual vs. Budget | 3 | 24 |
| ML96.1 | Accounting Units | 3 | 24 |
| ML96.2 | YTD Current Year vs. Last Year | 3 | 24 |
| ML96.3 | Periods Current Year vs. Last Year | 3 | 24 |
| ML96.4 | YTD Actual vs. Budget | 3 | 24 |
| ML96.5 | Periods Actual vs. Budget | 3 | 24 |
| ML97.1 | Accounts | 3 | 24 |
| ML97.2 | YTD Current Year vs. Last Year | 3 | 24 |
| ML97.3 | Periods Current Year vs. Last Year | 3 | 24 |
| ML97.4 | YTD Actual vs. Budget | 3 | 24 |
| ML97.5 | Periods Actual vs. Budget | 3 | 24 |
| ML97.6 | YTD Account Currencies | 3 | 24 |
| ML97.7 | Periods Account Currencies | 3 | 24 |
| ML97.8 | Fiscal Year Summary | 3 | 24 |
| ML97.9 | Totals | 3 | 24 |
| ML98.1 | Companies | 3 | 24 |
| ML98.2 | YTD Current Year vs. Last Year | 3 | 24 |
| ML98.3 | Periods Current Year vs. Last Year | 3 | 24 |
| ML98.4 | YTD Actual vs. Budget | 3 | 24 |
| ML98.5 | Periods Actual vs. Budget | 3 | 24 |
| ML99.1 | Organization Query | 13 | 33 |
| ML99.2 | Periods vs. YTD | 3 | 24 |
| ML99.3 | YTD Current Year vs. Last Year | 3 | 24 |
| ML99.4 | Periods Current Year vs. Last Year | 3 | 24 |
| ML99.5 | YTD Actual vs. Budget | 3 | 24 |
| ML99.6 | Periods Actual vs. Budget | 3 | 24 |
| MLBD.1 | ML BOD Maintenance | 1 | 1 |
| MLBD.2 | ML BOD Inquiry | 0 | 2 |
| MLCC.1 | Print interface for Glp65pd | 0 | 2 |
| MLFC.1 | General Ledger Account Edit | 1 | 7 |
| MLIT.1 | General Ledger Account Edit | 10 | 18 |
| MLJR.1 | Interface JE Report | 0 | 3 |
| MLRV.1 | General Ledger Report | 0 | 7 |
Batch programs (32)
| Program | Description | Updates | References |
|---|---|---|---|
| ML110 | Ledger Company Copy Delete | 23 | 7 |
| ML111 | Backposting Control Mass Upd | 2 | 4 |
| ML145 | Ledger Journal Hold Release | 3 | 14 |
| ML146 | Batch Ledger Journal Control | 27 | 63 |
| ML165 | Ledger Transaction Interface | 4 | 30 |
| ML167 | Ledger Balance Interface | 25 | 62 |
| ML170 | Ledger Recurring Journal Interface | 7 | 22 |
| ML190 | Ledger Journal Posting | 30 | 62 |
| ML191 | Ledger Currency Revaluation | 10 | 27 |
| ML195 | Ledger Translation Calculation | 13 | 65 |
| ML196 | Ledger Report Currency Translation | 17 | 64 |
| ML199 | Ledger Period Closing | 29 | 59 |
| ML210 | Ledger Listing | 1 | 5 |
| ML211 | Ledger Group Listing | 1 | 2 |
| ML212 | ML Calendar Map Listing | 1 | 3 |
| ML240 | Ledger Journal Edit Listing | 2 | 18 |
| ML241 | Ledger Period Transaction List | 2 | 13 |
| ML245 | Ledger Journal Control Report | 2 | 12 |
| ML250 | Ledger Report Listing | 2 | 12 |
| ML265 | Ledger Transaction Interface Listing | 1 | 3 |
| ML267 | Ledger Balance Interface List | 2 | 11 |
| ML270 | Ledger Recurring Jrnl Edit Lis | 2 | 18 |
| ML275 | Ledger Recurring Jrnl Cntrl Rp | 2 | 13 |
| ML290 | Ledger Report | 3 | 23 |
| ML291 | Ledger Trial Balance | 2 | 19 |
| ML292 | Ledger Balance Sheet | 12 | 27 |
| ML293 | Ledger Income Statement | 12 | 28 |
| ML300 | Ledger History Delete | 11 | 10 |
| ML320 | Ledger Consolidation File Creation | 4 | 13 |
| ML325 | Ledger AMOUNTS, UNITS Rebuild | 5 | 14 |
| ML327 | Ledger Report Currency Rebuild | 5 | 14 |
| ML330 | Ledger Undistributed RE Rebuil | 17 | 61 |
Other tables used by Multi-Ledger programs (134)
ACACTIVITY, ACDETAILAU, ACHEADERAU, ACMILESTN, ADDRDATA, AMACCTAU, AMACCTGPAU, AMASTTYPAU, AMAUGRPAU, AMDICT2, AMDIVISNAU, AMSYSOPTAU, AUMXVALUAU, AUMXVALUE, AUMXVLDTAU, CAALOCGPAU, CADETAILAU, CAHEADER, CAHEADERAU, CATRANS, CMPUTE, CMPUTEAU, CUACCT, CUACCTAU, CUAMOUNT, CUCODES, CUCODESAU, CUCONV, CUCONVAU, CURELAT, CURELATAU, CUTABLE, CUTABLEAU, CUTRANSL, CUTRNSLAU, FBADJCODAU, FBCNTRLAU, FBDETAIL, FBDETAILAU, FBFNDHDRAU, FBFUNDAMT, FBFUNDDTL, FBHEADER, FBHEADERAU, FBHSTHDRAU, FBINTBUAU, FBSPREADAU, FBTRANSAU, GLACCTREL, GLACMXVLAU, GLADDRESS, GLAMOUNTS, GLAUTMXVAU, GLCBOD, GLCGCPY, GLCHART, GLCHARTDTL, GLCHARTSUM, GLCHTDTLAU, GLCODES, GLCOMMIT, GLCOMPREL, GLCONTROL, GLCPYGRP, GLESACCT, GLHOLDCODE, GLINTCO, GLMASTER, GLMASTERAU, GLNAMES, GLNAMESAU, GLSCCAT, GLSRCCODE, GLSYSTEM, GLSYSTEMAU, GLTRANS, GLUNITS, GLZONE, GTMXVALUAU, INSTCTRYCD, JBKOPCODE, JBKSEQNBR, JBKSYSCODE, JBOOKHDR, MACAPDTL, MXCATDEF, MXCATDEFAU, MXELEMENT, MXELEMNTAU, MXLISTDTL, MXLISTHDR, MXLISTMBR, MXLSTDTLAU, MXLSTHDRAU, MXOBJCAT, MXOBJCATAU, MXTMPDTLAU, MXTMPHDRAU, MXTPEFDTAU, MXTPHEDTAU, MXVALIDATE, MXVALIDAU, MXVEWDTLAU, MXVEWHDRAU, MXVIEWDTL, MXVIEWHDR, RADEFINAU, RADEFINE, RATOTALAU, RATOTALS, RJBRIDGE, RJMXVALUAU, RJMXVALUE, RJSCHEDULE, RJTRANS, RWDICT, RWFORMAT, RWFORMATAU, RWGRPDET, RWGRPDETAU, RWHEADAU, RWHEADER, RWREQSTAU, RWREQUEST, RWROWDET, RWROWDTAU, RWUSER, RWUSERAU, SUBCKPOINT, SYSTEMCODE, TRCODES, ULPOST, ULTOTALS, WFSETUP