MLAMOUNTS – Multi-Book Ledger Amounts

System: Multi-Ledger (ML)
Prefix: MLA
Primary key: LEDGER, COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields: 79
Updated by: 17 programs
Referenced by: 10 programs

MLAMOUNTS is the Multi-Book Ledger Amounts table in Lawson Multi-Ledger (prefix MLA). It is indexed by LEDGER, COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (MLASET1); alternate indexes: MLASET10, MLASET2, MLASET3, MLASET4, MLASET5, MLASET6 and MLASET7. It is related 1:1 to GLCHARTDTL, GLSYSTEM, GLMASTER and MLCOLEDGER and 1:M to MLAMOUNTS, MLTRANS, MLCONSOL and MLCUAMOUNT. It is updated by GL120, ML110, ML146, ML167, ML190, ML199, ML300, ML325 and 9 more and referenced by GL20.2, ML195, ML196, ML290, ML291, ML320, ML90.1, ML90.4 and 2 more. The table has 79 fields, 8 indexes and 11 documented relations.

About MLAMOUNTS

The Multi-Book Ledger Amounts-Period file contains beginning and period account balances by accounting unit, account, and subaccount.

Fields (79)

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

Field / column	Type	Description & values	Updated by
`MLA-LEDGER` PK LEDGER	Alpha 15	The ledger associated with the balance record. The ledger must be defined in ML10.	ML110, ML146, ML167, ML190, ML199, ML325, ML330, ML40.1 +6 more
`MLA-COMPANY` PK COMPANY	Numeric 4	The company into which transactions are to be interfaced.	ML146, ML167, ML190, ML199, ML325, ML327, ML330, ML40.1 +6 more
`MLA-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	The fiscal year for the transactions to be interfaced. Defaults to the current fiscal year.	ML146, ML167, ML190, ML199, ML325, ML327, ML330, ML40.1 +6 more
`MLA-VAR-LEVELS` VAR_LEVELS	Alpha 30	A level that represents the location of an accounting unit in an organization's level structure.	GL120, ML146, ML167, ML190, ML199, ML325, ML327, ML330 +7 more
`MLA-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	The short-hand notation representing the variable level. It must defined in the General Ledger as a posting accounting unit.	ML146, ML167, ML190, ML199, ML325, ML327, ML330, ML40.1 +6 more
`MLA-ACCOUNT` PK ACCOUNT	Numeric 6	This field, along with the accounting unit and subaccount, make up the location (account) where amounts and other account information are stored.	ML146, ML167, ML190, ML199, ML325, ML327, ML330, ML40.1 +6 more
`MLA-SUB-ACCOUNT` PK SUB_ACCOUNT	Numeric 4	This field, along with the accounting unit and account, make up the location (account) where amounts and other account information are stored.	ML146, ML167, ML190, ML199, ML325, ML327, ML330, ML40.1 +6 more
`MLA-CHART-NAME` CHART_NAME	Alpha 12	The chart of accounts assigned to the ledger	ML146, ML167, ML190, ML199, ML325, ML327, ML330, ML40.1 +6 more
`MLA-DB-BEG-BAL` DB_BEG_BAL	Signed 18.2	The debit beginning balance.	ML110, ML167, ML199, ML291, ML325
`MLA-CR-BEG-BAL` CR_BEG_BAL	Signed 18.2	The credit beginning balance.	ML110, ML167, ML199, ML291, ML325
`MLA-DB-AMOUNT` DB_AMOUNT	Signed 18.2 Occurs 13 Times ×13	The debit amount.	ML110, ML146, ML167, ML190, ML291, ML325, ML330, ML40.1 +6 more
`MLA-CR-AMOUNT` CR_AMOUNT	Signed 18.2 Occurs 13 Times ×13	The credit amount.	ML110, ML146, ML167, ML190, ML291, ML325, ML330, ML40.1 +6 more
`MLA-ACTIVITY-FLAG` ACTIVITY_FLAG	Alpha 1 Occurs 13 Times ×13	The field indicates whether there was activity to this account.	ML146, ML167, ML190, ML325, ML40.1, ML40.2, ML40.3, ML40.7 +3 more
`MLA-MAINT-DATE` MAINT_DATE	Numeric 8 (yyyymmdd)	The date the record was last changed.	GL120, ML146, ML167, ML190, ML199, ML330, ML40.1, ML40.2 +5 more
`MLA-MAINT-TIME` MAINT_TIME	Numeric 6 (hhmmss)	The time the record was last changed.	GL120, ML146, ML167, ML190, ML199, ML330, ML40.1, ML40.2 +5 more
`MLA-CPAMT-DR` CPAMT_DR	Derived	The current period debit amount.	—
`MLA-CPAMT-CR` CPAMT_CR	Derived	The current period credit amount.	—
`MLA-CPAMT` CPAMT	Derived	The total current period amount.	—
`MLA-CYBAMT` CYBAMT	Derived	The current year beginning amount.	—
`MLA-CUR-PD-SUM-DR` CUR_PD_SUM_DR	Derived	The current period summary debit amount.	—
`MLA-CUR-PD-SUM-CR` CUR_PD_SUM_CR	Derived	The current period summary credit amount.	—
`MLA-CUR-PD-SUM` CUR_PD_SUM	Derived	The current period summary amount.	—
`MLA-CYDAMT` CYDAMT	Derived	The current year-to-date amount.	—
`MLA-CYPAMT1-DR` CYPAMT1_DR	Derived	The current year period 1 debit amount	—
`MLA-CYPAMT1-CR` CYPAMT1_CR	Derived	The current year period 1 credit amount	—
`MLA-CYPAMT1` CYPAMT1	Derived	The current year period 1 amount.	—
`MLA-CYPYTD1` CYPYTD1	Derived	Current year period year to date period 1.	—
`MLA-CYPAMT2-DR` CYPAMT2_DR	Derived	The current year period 2 debit amount	—
`MLA-CYPAMT2-CR` CYPAMT2_CR	Derived	The current year period 2 credit amount	—
`MLA-CYPAMT2` CYPAMT2	Derived	The current year period 2 amount.	—
`MLA-CYPYTD2` CYPYTD2	Derived	Current year period year to date period 2.	—
`MLA-CYPAMT3-DR` CYPAMT3_DR	Derived	The current year period 3 debit amount	—
`MLA-CYPAMT3-CR` CYPAMT3_CR	Derived	The current year period 3 credit amount	—
`MLA-CYPAMT3` CYPAMT3	Derived	The current year period 3 amount.	—
`MLA-CYPYTD3` CYPYTD3	Derived	Current year period year to date period 3.	—
`MLA-CYPAMT4-DR` CYPAMT4_DR	Derived	The current year period 4 debit amount	—
`MLA-CYPAMT4-CR` CYPAMT4_CR	Derived	The current year period 4 credit amount	—
`MLA-CYPAMT4` CYPAMT4	Derived	The current year period 4 amount.	—
`MLA-CYPYTD4` CYPYTD4	Derived	Current year period year to date period 4.	—
`MLA-CYPAMT5-DR` CYPAMT5_DR	Derived	The current year period 5 debit amount	—
`MLA-CYPAMT5-CR` CYPAMT5_CR	Derived	The current year period 5 credit amount	—
`MLA-CYPAMT5` CYPAMT5	Derived	The current year period 5 amount.	—
`MLA-CYPYTD5` CYPYTD5	Derived	Current year period year to date period 5.	—
`MLA-CYPAMT6-DR` CYPAMT6_DR	Derived	The current year period 6 debit amount	—
`MLA-CYPAMT6-CR` CYPAMT6_CR	Derived	The current year period 6 credit amount	—
`MLA-CYPAMT6` CYPAMT6	Derived	The current year period 6 amount.	—
`MLA-CYPYTD6` CYPYTD6	Derived	Current year period year to date period 6.	—
`MLA-CYPAMT7-DR` CYPAMT7_DR	Derived	The current year period 7 debit amount	—
`MLA-CYPAMT7-CR` CYPAMT7_CR	Derived	The current year period 7 credit amount	—
`MLA-CYPAMT7` CYPAMT7	Derived	The current year period 7 amount.	—
`MLA-CYPYTD7` CYPYTD7	Derived	Current year period year to date period 7.	—
`MLA-CYPAMT8-DR` CYPAMT8_DR	Derived	The current year period 8 debit amount	—
`MLA-CYPAMT8-CR` CYPAMT8_CR	Derived	The current year period 8 credit amount	—
`MLA-CYPAMT8` CYPAMT8	Derived	The current year period 8 amount.	—
`MLA-CYPYTD8` CYPYTD8	Derived	Current year period year to date period 8.	—
`MLA-CYPAMT9-DR` CYPAMT9_DR	Derived	The current year period 9 debit amount	—
`MLA-CYPAMT9-CR` CYPAMT9_CR	Derived	The current year period 9 credit amount	—
`MLA-CYPAMT9` CYPAMT9	Derived	The current year period 9 amount.	—
`MLA-CYPYTD9` CYPYTD9	Derived	Current year period year to date period 9.	—
`MLA-CYPAMT10-DR` CYPAMT10_DR	Derived	The current year period 10 debit amount	—
`MLA-CYPAMT10-CR` CYPAMT10_CR	Derived	The current year period 10 credit amount	—
`MLA-CYPAMT10` CYPAMT10	Derived	The current year period 10 amount.	—
`MLA-CYPYTD10` CYPYTD10	Derived	Current year period year to date period 10.	—
`MLA-CYPAMT11-DR` CYPAMT11_DR	Derived	The current year period 11 debit amount	—
`MLA-CYPAMT11-CR` CYPAMT11_CR	Derived	The current year period 11 credit amount	—
`MLA-CYPAMT11` CYPAMT11	Derived	The current year period 11 amount.	—
`MLA-CYPYTD11` CYPYTD11	Derived	Current year period year to date period 11.	—
`MLA-CYPAMT12-DR` CYPAMT12_DR	Derived	The current year period 12 debit amount	—
`MLA-CYPAMT12-CR` CYPAMT12_CR	Derived	The current year period 12 credit amount	—
`MLA-CYPAMT12` CYPAMT12	Derived	The current year period 12 amount.	—
`MLA-CYPYTD12` CYPYTD12	Derived	Current year period year to date period 12.	—
`MLA-CYPAMT13-DR` CYPAMT13_DR	Derived	The current year period 13 debit amount	—
`MLA-CYPAMT13-CR` CYPAMT13_CR	Derived	The current year period 13 credit amount	—
`MLA-CYPAMT13` CYPAMT13	Derived	The current year period 13 amount.	—
`MLA-CYPYTD13` CYPYTD13	Derived	Current year period year to date period 13.	—
`MLA-BLANK` BLANK	Derived	This derived field is always blank. It is used in the Drill Around feature for column headings. .~$3 MLAMOUNTS CPAMT-THOU	—
`MLA-CPAMT-THOU` CPAMT_THOU	Derived	The current period base amount divided by 1,000.	—
`MLA-CYDAMT-THOU` CYDAMT_THOU	Derived	The current period amount divided by 1000.	—
`MLA-PARENT-VAR-LEV` PARENT_VAR_LEV	Alpha 30	The variable level address of the parent accounting unit.	GL120, ML146, ML167, ML190, ML199, ML325, ML327, ML330 +7 more

Indexes (8)

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

Index	Keys	Flags	Used in
`MLASET1`	`LEDGER`, `COMPANY`, `FISCAL-YEAR`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`	Primary	GL120, ML110, ML146, ML167, ML190, ML195, ML199, ML290 +15 more
`MLASET10`	`PARENT-VAR-LEV`, `LEDGER`, `COMPANY`, `ACCOUNT`, `SUB-ACCOUNT`, `FISCAL-YEAR`, `ACCT-UNIT`		—
`MLASET2`	`FISCAL-YEAR`, `LEDGER`, `COMPANY`, `VAR-LEVELS`, `ACCOUNT`, `SUB-ACCOUNT`, `ACCT-UNIT`	KeyChange	RW80.1, ML195, ML196, ML290, ML291, ML325, MLRV.1
`MLASET3`	`LEDGER`, `COMPANY`, `ACCT-UNIT`, `ACCOUNT`, `SUB-ACCOUNT`, `FISCAL-YEAR`		GL120, GL20.2
`MLASET4`	`FISCAL-YEAR`, `LEDGER`, `COMPANY`, `ACCOUNT`, `SUB-ACCOUNT`, `VAR-LEVELS`, `ACCT-UNIT`	KeyChange	ML199, ML290, ML320, ML325, MLRV.1
`MLASET5`	`FISCAL-YEAR`, `VAR-LEVELS`, `ACCOUNT`, `SUB-ACCOUNT`, `LEDGER`, `COMPANY`, `ACCT-UNIT`	KeyChange	MLRV.1
`MLASET6`	`FISCAL-YEAR`, `ACCOUNT`, `SUB-ACCOUNT`, `VAR-LEVELS`, `LEDGER`, `COMPANY`, `ACCT-UNIT`	KeyChange	MLRV.1
`MLASET7`	`LEDGER`, `COMPANY`, `FISCAL-YEAR`, `ACCOUNT`, `SUB-ACCOUNT`, `ACCT-UNIT`		ML325, ML330

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Chart Detail	GLCHARTDTL	Required	`MLA-CHART-NAME` → `GDT-CHART-NAME`, `MLA-ACCOUNT` → `GDT-ACCOUNT`, `MLA-SUB-ACCOUNT` → `GDT-SUB-ACCOUNT`
Company	GLSYSTEM	Required	`MLA-COMPANY` → `GLS-COMPANY`
Glmaster	GLMASTER	Required	`MLA-COMPANY` → `GLM-COMPANY`, `MLA-ACCT-UNIT` → `GLM-ACCT-UNIT`, `MLA-ACCOUNT` → `GLM-ACCOUNT`, `MLA-SUB-ACCOUNT` → `GLM-SUB-ACCOUNT`
Mlcoledger	MLCOLEDGER	Required	`MLA-LEDGER` → `MLE-LEDGER`, `MLA-COMPANY` → `MLE-COMPANY`

One to many (7) — child tables

Relation	Table	Field map
Annual Amounts	MLAMOUNTS	`MLA-LEDGER` → `MLA-LEDGER`, `MLA-COMPANY` → `MLA-COMPANY`, `MLA-ACCT-UNIT` → `MLA-ACCT-UNIT`, `MLA-ACCOUNT` → `MLA-ACCOUNT`, `MLA-SUB-ACCOUNT` → `MLA-SUB-ACCOUNT`, → `MLA-FISCAL-YEAR`
Company Trans	MLTRANS	`MLA-LEDGER` → `MLT-LEDGER`, `MLA-COMPANY` → `MLT-TO-COMPANY`, `MLA-FISCAL-YEAR` → `MLT-FISCAL-YEAR`, `MLE-ACCT-PERIOD` → `MLT-ACCT-PERIOD`, `MLA-ACCOUNT` → `MLT-ACCOUNT`, `MLA-SUB-ACCOUNT` → `MLT-SUB-ACCOUNT`, → `MLT-ACCT-UNIT`, → `MLT-OBJ-ID`
Consol Parent	MLCONSOL	`MLA-PARENT-VAR-LEV` → `MCN-VAR-LEVELS`, `"A"` → `MCN-TRANS-TYPE`, `MLA-LEDGER` → `MCN-LEDGER`, `MLA-COMPANY` → `MCN-COMPANY`, `MLA-ACCOUNT` → `MCN-ACCOUNT`, `MLA-SUB-ACCOUNT` → `MCN-SUB-ACCOUNT`, `MLA-FISCAL-YEAR` → `MCN-FISCAL-YEAR`, → `MCN-LEVEL-DEPTH`, → `MCN-CURRENCY-CODE`
Mca Curr 1	MLCUAMOUNT	`MLA-PARENT-VAR-LEV` → `MCA-PARENT-VAR-LEV`, `3` → `MCA-AMT-TYPE`, `MLA-LEDGER` → `MCA-LEDGER`, `MLA-COMPANY` → `MCA-COMPANY`, `MLA-ACCOUNT` → `MCA-ACCOUNT`, `MLA-SUB-ACCOUNT` → `MCA-SUB-ACCOUNT`, `MLA-FISCAL-YEAR` → `MCA-FISCAL-YEAR`, `MLA-ACCT-UNIT` → `MCA-ACCT-UNIT`, `MLA-VAR-LEVELS` → `MCA-VAR-LEVELS`, → `MCA-CURRENCY-CODE`
Mca Curr 2	MLCUAMOUNT	`MLA-PARENT-VAR-LEV` → `MCA-PARENT-VAR-LEV`, `4` → `MCA-AMT-TYPE`, `MLA-LEDGER` → `MCA-LEDGER`, `MLA-COMPANY` → `MCA-COMPANY`, `MLA-ACCOUNT` → `MCA-ACCOUNT`, `MLA-SUB-ACCOUNT` → `MCA-SUB-ACCOUNT`, `MLA-FISCAL-YEAR` → `MCA-FISCAL-YEAR`, `MLA-ACCT-UNIT` → `MCA-ACCT-UNIT`, `MLA-VAR-LEVELS` → `MCA-VAR-LEVELS`, → `MCA-CURRENCY-CODE`
Trans One Prd	MLTRANS	`MLA-LEDGER` → `MLT-LEDGER`, `MLA-COMPANY` → `MLT-TO-COMPANY`, `MLA-FISCAL-YEAR` → `MLT-FISCAL-YEAR`, `MLE-ACCT-PERIOD` → `MLT-ACCT-PERIOD`, `MLA-ACCT-UNIT` → `MLT-ACCT-UNIT`, `MLA-ACCOUNT` → `MLT-ACCOUNT`, `MLA-SUB-ACCOUNT` → `MLT-SUB-ACCOUNT`, → `MLT-OBJ-ID`
Trans One Prds	MLTRANS	`MLA-LEDGER` → `MLT-LEDGER`, `MLA-COMPANY` → `MLT-TO-COMPANY`, `MLA-ACCOUNT` → `MLT-ACCOUNT`, `MLA-SUB-ACCOUNT` → `MLT-SUB-ACCOUNT`, `MLA-ACCT-UNIT` → `MLT-ACCT-UNIT`, `MLE-FISCAL-YEAR` → `MLT-FISCAL-YEAR`, → `MLT-ACCT-PERIOD`, → `MLT-OBJ-ID`

Programs

Updated by (17)

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
ML327 Ledger Report Currency 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 (10)

GL20.2 Posting Accounts
ML195 Ledger Translation Calculation
ML196 Ledger Report Currency Translation
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