MLUNITS – ML Units

System: Multi-Ledger (ML)
Prefix: MLU
Primary key: LEDGER, COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields: 76
Updated by: 16 programs
Referenced by: 8 programs

MLUNITS is the ML Units table in Lawson Multi-Ledger (prefix MLU). It is indexed by LEDGER, COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (MLUSET1); alternate indexes: MLUSET2, MLUSET3, MLUSET4, MLUSET5, MLUSET6 and MLUSET7. It is related 1:1 to GLMASTER, GLCHARTDTL, GLSYSTEM and MLLEDGER and 1:M to MLUNITS and MLCONSOL. It is updated by GL120, ML110, ML146, ML167, ML190, ML199, ML300, ML325 and 8 more and referenced by ML195, ML290, ML291, ML320, ML90.1, ML90.4, MLRV.1 and RW80.1. The table has 76 fields, 7 indexes and 6 documented relations.

About MLUNITS

The Multi Book Ledger Units file contains debit and credit unit balance information including the ledger, company, fiscal year, accounting unit, and account records.

Fields (76)

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

Field / column	Type	Description & values	Updated by
`MLU-LEDGER` PK LEDGER	Alpha 15	The ledger being posted to.	ML110, ML146, ML167, ML190, ML199, ML325, ML330, ML40.1 +6 more
`MLU-COMPANY` PK COMPANY	Numeric 4	This is the company the ledger is linked to .~$3 MLUNITS FISCAL-YEAR This is the fiscal year the unit amounts are posted to.	ML146, ML167, ML190, ML199, ML325, ML330, ML40.1, ML40.2 +5 more
`MLU-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	Contains the fiscal year for the data stored on this record.	ML146, ML167, ML190, ML199, ML325, ML330, ML40.1, ML40.2 +5 more
`MLU-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	This is the accounting unit with which unit amounts are associated.	ML146, ML167, ML190, ML199, ML325, ML330, ML40.1, ML40.2 +5 more
`MLU-ACCOUNT` PK ACCOUNT	Numeric 6	This is the account with which unit amounts are associated.	ML146, ML167, ML190, ML199, ML325, ML330, ML40.1, ML40.2 +5 more
`MLU-SUB-ACCOUNT` PK SUB_ACCOUNT	Numeric 4	This is the subaccount with which unit amounts are associated.	ML146, ML167, ML190, ML199, ML325, ML330, ML40.1, ML40.2 +5 more
`MLU-VAR-LEVELS` VAR_LEVELS	Alpha 30	This is the variable level with which unit amounts are associated. A level represents the location of an accounting unit in an organization's level structure.	GL120, ML146, ML167, ML190, ML199, ML325, ML330, ML40.1 +6 more
`MLU-CHART-NAME` CHART_NAME	Alpha 12	This is the chart of account with which the company is associated.	ML146, ML167, ML190, ML199, ML325, ML330, ML40.1, ML40.2 +5 more
`MLU-DB-BEG-BAL` DB_BEG_BAL	Signed 18.2	The debit unit beginning balance.	ML110, ML167, ML199, ML291, ML325
`MLU-CR-BEG-BAL` CR_BEG_BAL	Signed 18.2	The credit unit beginning balance.	ML110, ML167, ML199, ML291, ML325
`MLU-DB-UNITS` DB_UNITS	Signed 15.2 Occurs 13 Times ×13	The debit unit amount.	ML110, ML146, ML167, ML190, ML291, ML325, ML330, ML40.1 +6 more
`MLU-CR-UNITS` CR_UNITS	Signed 15.2 Occurs 13 Times ×13	The credit unit amount.	ML110, ML146, ML167, ML190, ML291, ML325, ML330, ML40.1 +6 more
`MLU-ACTIVITY-FLAG` ACTIVITY_FLAG	Alpha 1 Occurs 13 Times ×13	When activity for this period has occurred a "Y" will be inserted. Not required.	ML146, ML167, ML190, ML325, ML40.1, ML40.2, ML40.3, ML40.7 +3 more
`MLU-MAINT-DATE` MAINT_DATE	Numeric 8 (yyyymmdd)	The date the unit record was last changed.	GL120, ML146, ML167, ML190, ML199, ML330, ML40.1, ML40.2 +5 more
`MLU-MAINT-TIME` MAINT_TIME	Numeric 6 (hhmmss)	The time the unit record was last changed.	GL120, ML146, ML167, ML190, ML199, ML330, ML40.1, ML40.2 +5 more
`MLU-CYBUNT` CYBUNT	Derived	The current year beginning unit balance.	—
`MLU-CPUNT-DR` CPUNT_DR	Derived	The current period debit unit amount.	—
`MLU-CPUNT-CR` CPUNT_CR	Derived	The current period credit unit amount.	—
`MLU-CPUNT` CPUNT	Derived	The current period net unit amount.	—
`MLU-CUR-PD-SUM-U-D` CUR_PD_SUM_U_D	Derived	The current period summary debit units.	—
`MLU-CUR-PD-SUM-U-C` CUR_PD_SUM_U_C	Derived	The current period summary credit units.	—
`MLU-CYDUNT` CYDUNT	Derived	The current year-to-date units.	—
`MLU-CYPUNT1-DR` CYPUNT1_DR	Derived	The current year period 1 debit unit amount.	—
`MLU-CYPUNT2-DR` CYPUNT2_DR	Derived	The current year period 2 debit unit amount.	—
`MLU-CYPUNT3-DR` CYPUNT3_DR	Derived	The current year period 3 debit unit amount.	—
`MLU-CYPUNT4-DR` CYPUNT4_DR	Derived	The current year period 4 debit unit amount.	—
`MLU-CYPUNT5-DR` CYPUNT5_DR	Derived	The current year period 5 debit unit amount.	—
`MLU-CYPUNT6-DR` CYPUNT6_DR	Derived	The current year period 6 debit unit amount.	—
`MLU-CYPUNT7-DR` CYPUNT7_DR	Derived	The current year period 7 debit unit amount.	—
`MLU-CYPUNT8-DR` CYPUNT8_DR	Derived	The current year period 8 debit unit amount.	—
`MLU-CYPUNT9-DR` CYPUNT9_DR	Derived	The current year period 9 debit unit amount.	—
`MLU-CYPUNT10-DR` CYPUNT10_DR	Derived	The current year period 10 debit unit amount.	—
`MLU-CYPUNT11-DR` CYPUNT11_DR	Derived	The current year period 11 debit unit amount.	—
`MLU-CYPUNT12-DR` CYPUNT12_DR	Derived	The current year period 12 debit unit amount.	—
`MLU-CYPUNT13-DR` CYPUNT13_DR	Derived	The current year period 13 debit unit amount.	—
`MLU-CYPUNT1-CR` CYPUNT1_CR	Derived	The current year period 1 credit unit amount.	—
`MLU-CYPUNT2-CR` CYPUNT2_CR	Derived	The current year period 2 credit unit amount.	—
`MLU-CYPUNT3-CR` CYPUNT3_CR	Derived	The current year period 3 credit unit amount.	—
`MLU-CYPUNT4-CR` CYPUNT4_CR	Derived	The current year period 4 credit unit amount.	—
`MLU-CYPUNT5-CR` CYPUNT5_CR	Derived	The current year period 5 credit unit amount.	—
`MLU-CYPUNT6-CR` CYPUNT6_CR	Derived	The current year period 6 credit unit amount.	—
`MLU-CYPUNT7-CR` CYPUNT7_CR	Derived	The current year period 7 credit unit amount.	—
`MLU-CYPUNT8-CR` CYPUNT8_CR	Derived	The current year period 8 credit unit amount.	—
`MLU-CYPUNT9-CR` CYPUNT9_CR	Derived	The current year period 9 credit unit amount.	—
`MLU-CYPUNT10-CR` CYPUNT10_CR	Derived	The current year period 10 credit unit amount.	—
`MLU-CYPUNT11-CR` CYPUNT11_CR	Derived	The current year period 11 credit unit amount.	—
`MLU-CYPUNT12-CR` CYPUNT12_CR	Derived	The current year period 12 credit unit amount.	—
`MLU-CYPUNT13-CR` CYPUNT13_CR	Derived	The current year period 13 credit unit amount.	—
`MLU-CYPUNT1` CYPUNT1	Derived	The current year period 1 net unit amount.	—
`MLU-CYPUNT2` CYPUNT2	Derived	The current year period 2 net unit amount.	—
`MLU-CYPUNT3` CYPUNT3	Derived	The current year period 3 net unit amount.	—
`MLU-CYPUNT4` CYPUNT4	Derived	The current year period 4 net unit amount.	—
`MLU-CYPUNT5` CYPUNT5	Derived	The current year period 5 net unit amount.	—
`MLU-CYPUNT6` CYPUNT6	Derived	The current year period 6 net unit amount.	—
`MLU-CYPUNT7` CYPUNT7	Derived	The current year period 7 net unit amount.	—
`MLU-CYPUNT8` CYPUNT8	Derived	The current year period 8 net unit amount.	—
`MLU-CYPUNT9` CYPUNT9	Derived	The current year period 9 net unit amount.	—
`MLU-CYPUNT10` CYPUNT10	Derived	The current year period 10 net unit amount.	—
`MLU-CYPUNT11` CYPUNT11	Derived	The current year period 11 net unit amount.	—
`MLU-CYPUNT12` CYPUNT12	Derived	The current year period 12 net unit amount.	—
`MLU-CYPUNT13` CYPUNT13	Derived	The current year period 13 net unit amount.	—
`MLU-CYPYTD1` CYPYTD1	Derived	Current year period year to date period 1.	—
`MLU-CYPYTD2` CYPYTD2	Derived	Current year period year to date period 2.	—
`MLU-CYPYTD3` CYPYTD3	Derived	Current year period year to date period 3.	—
`MLU-CYPYTD4` CYPYTD4	Derived	Current year period year to date period 4.	—
`MLU-CYPYTD5` CYPYTD5	Derived	Current year period year to date period 5.	—
`MLU-CYPYTD6` CYPYTD6	Derived	Current year period year to date period 6.	—
`MLU-CYPYTD7` CYPYTD7	Derived	Current year period year to date period 7.	—
`MLU-CYPYTD8` CYPYTD8	Derived	Current year period year to date period 8.	—
`MLU-CYPYTD9` CYPYTD9	Derived	Current year period year to date period 9.	—
`MLU-CYPYTD10` CYPYTD10	Derived	Current year period year to date period 10.	—
`MLU-CYPYTD11` CYPYTD11	Derived	Current year period year to date period 11.	—
`MLU-CYPYTD12` CYPYTD12	Derived	Current year period year to date period 12.	—
`MLU-CYPYTD13` CYPYTD13	Derived	Current year period year to date period 13.	—
`MLU-BLANKAM` BLANKAM	Derived	This field consists of blank spaces. It is used to provide column headings on drill arounds.	—
`MLU-PARENT-VAR-LEV` PARENT_VAR_LEV	Alpha 30	The variable level address of the parent accounting unit.	GL120, ML146, ML167, ML190, ML199, ML325, ML40.1, ML40.2 +5 more

Indexes (7)

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

Index	Keys	Flags	Used in
`MLUSET1`	`LEDGER`, `COMPANY`, `FISCAL-YEAR`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`	Primary	GL120, ML110, ML146, ML167, ML190, ML199, ML290, ML291 +12 more
`MLUSET2`	`FISCAL-YEAR`, `LEDGER`, `COMPANY`, `VAR-LEVELS`, `ACCOUNT`, `SUB-ACCOUNT`, `ACCT-UNIT`	KeyChange	GL120, RW80.1, ML195, ML291, ML325, MLRV.1
`MLUSET3`	`LEDGER`, `COMPANY`, `ACCOUNT`, `SUB-ACCOUNT`, `VAR-LEVELS`, `ACCT-UNIT`, `FISCAL-YEAR`	KeyChange	—
`MLUSET4`	`FISCAL-YEAR`, `VAR-LEVELS`, `ACCOUNT`, `SUB-ACCOUNT`, `LEDGER`, `COMPANY`, `ACCT-UNIT`	KeyChange	MLRV.1
`MLUSET5`	`FISCAL-YEAR`, `ACCOUNT`, `SUB-ACCOUNT`, `VAR-LEVELS`, `LEDGER`, `COMPANY`, `ACCT-UNIT`	KeyChange	MLRV.1
`MLUSET6`	`FISCAL-YEAR`, `LEDGER`, `COMPANY`, `ACCOUNT`, `SUB-ACCOUNT`, `VAR-LEVELS`, `ACCT-UNIT`	KeyChange	ML199, ML290, ML320, ML325, ML330, MLRV.1
`MLUSET7`	`PARENT-VAR-LEV`, `LEDGER`, `COMPANY`, `ACCOUNT`, `SUB-ACCOUNT`, `FISCAL-YEAR`, `ACCT-UNIT`		—

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Acct Au	GLMASTER	Required	`MLU-COMPANY` → `GLM-COMPANY (GLMSET2)`, `MLU-ACCT-UNIT` → `GLM-ACCT-UNIT`, `MLU-ACCOUNT` → `GLM-ACCOUNT`, `MLU-SUB-ACCOUNT` → `GLM-SUB-ACCOUNT`
Chart Detail	GLCHARTDTL	Required	`MLU-CHART-NAME` → `GDT-CHART-NAME`, `MLU-ACCOUNT` → `GDT-ACCOUNT`, `MLU-SUB-ACCOUNT` → `GDT-SUB-ACCOUNT`
Company	GLSYSTEM	Required	`MLU-COMPANY` → `GLS-COMPANY`
Mlledger	MLLEDGER	Required	`MLU-LEDGER` → `MLL-LEDGER`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Annual Units	MLUNITS			`MLU-LEDGER` → `MLU-LEDGER`, `MLU-COMPANY` → `MLU-COMPANY`, `MLU-ACCOUNT` → `MLU-ACCOUNT`, `MLU-SUB-ACCOUNT` → `MLU-SUB-ACCOUNT`, `MLU-VAR-LEVELS` → `MLU-VAR-LEVELS`, `MLU-ACCT-UNIT` → `MLU-ACCT-UNIT`, → `MLU-FISCAL-YEAR`
Mlunit Parent	MLCONSOL			`MLU-PARENT-VAR-LEV` → `MCN-VAR-LEVELS`, `"U"` → `MCN-TRANS-TYPE`, `MLU-LEDGER` → `MCN-LEDGER`, `MLU-COMPANY` → `MCN-COMPANY`, `MLU-ACCOUNT` → `MCN-ACCOUNT`, `MLU-SUB-ACCOUNT` → `MCN-SUB-ACCOUNT`, `MLU-FISCAL-YEAR` → `MCN-FISCAL-YEAR`, → `MCN-LEVEL-DEPTH`, → `MCN-CURRENCY-CODE`

Programs

Updated by (16)

GL120 Level Reorganization
ML110 Ledger Company Copy Delete
ML146 Batch Ledger Journal Control
ML167 Ledger Balance Interface
ML190 Ledger Journal Posting
ML199 Ledger Period Closing
ML300 Ledger History Delete
ML325 Ledger AMOUNTS, UNITS Rebuild
ML330 Ledger Undistributed RE Rebuil
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

Referenced by (8)

ML195 Ledger Translation Calculation
ML290 Ledger Report
ML291 Ledger Trial Balance
ML320 Ledger Consolidation File Creation
ML90.1 Ledger Transaction Analysis
ML90.4 Reconcile Ledger Transactions
MLRV.1 General Ledger Report
RW80.1 Drill Around