ML Ledger Currency Amount

The Multi Book Ledger Currency Amount file contains a partial chart of accounts for non-base currency transactions. All Lawson subsystems verify the existence of non-base currency accounts against this file. This file also maintains monthly activity and beginning balances for all non-base currency, posting level accounting units. Ledger Journal Posting (ML190) updates this file, and Currency Revaluation (ML191) revalues the balance sheet accounts. Non-base currency, balance sheet accounts used in revaluation are designated as type 2 amounts. Type 1 amounts are non-base currency account amounts and are not revalued.
UPDATED BY

GL120

GL310

RW80.1

MLRV.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
MCA-LEDGER Element: Ledger	Alpha 15 The ledger associated with the currency amount record.
MCA-COMPANY Element: Company	Numeric 4 The company associated to the ledger.
MCA-FISCAL-YEAR Element: Year	Numeric 4 The fiscal year of the currency amount record.
MCA-AMT-TYPE Element: Amt Type	Numeric 1 The amount type can be either account currency, transaction currency, report currency one, or report currency two. 1 = Account Currency Balance 2 = Transaction Balances 3 = Currency One Balance 4 = Currency Two Balance
MCA-VAR-LEVELS Element: Var Levels	Alpha 30 The variable level address of the posting accounting unit associated with this record.	GL120
MCA-ACCOUNT Element: Account	Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
MCA-SUB-ACCOUNT Element: Sub Acct	Numeric 4 This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.
MCA-ACCT-UNIT Element: Acct Unit	Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
MCA-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company currency code corresponding to the amount type.
MCA-CHART-NAME Element: Chart Name	Alpha 12 This is the chart of accounts assigned to the General Ledger company.
MCA-CURR-ND Element: Acct Nd	Numeric 1 This field defines the number of positions for nonbase currency amounts.
MCA-BASE-ND Element: Base Nd	Numeric 1 This field defines the number of positions for base currency amounts.
MCA-DB-BEG-BAL Element: Intl Amt	Signed 18.2 This is the beginning debit balance for nonbase amounts.
MCA-CR-BEG-BAL Element: Intl Amt	Signed 18.2 This is the beginning credit balance for nonbase amounts.
MCA-BASE-DB-BBAL Element: Intl Amt	Signed 18.2 This is the beginning debit balance for base amounts.
MCA-BASE-CR-BBAL Element: Intl Amt	Signed 18.2 This is the beginning credit balance for nonbase amounts.
MCA-RPT1-DB-BBAL Element: Intl Amt	Signed 18.2 This is the beginning debit balance for report 1 currency amounts.	GL310
MCA-RPT1-CR-BBAL Element: Intl Amt	Signed 18.2 This is the beginning credit balance for report 1 currency amounts.	GL310
MCA-RPT2-DB-BBAL Element: Intl Amt	Signed 18.2 This is the beginning debit balance for report 2 currency amounts.	GL310
MCA-RPT2-CR-BBAL Element: Intl Amt	Signed 18.2 This is the beginning credit balance for report 2 currency amounts.	GL310
MCA-DB-AMOUNT Element: Intl Amt	Signed 18.2 Occurs 13 Times This is the total debit nonbase currency amount.
MCA-CR-AMOUNT Element: Intl Amt	Signed 18.2 Occurs 13 Times This is the total credit nonbase currency amount.
MCA-BASE-DB-AMT Element: Intl Amt	Signed 18.2 Occurs 13 Times This is the total debit base currency amount.
MCA-BASE-CR-AMT Element: Intl Amt	Signed 18.2 Occurs 13 Times This is the total credit base currency amount.
MCA-RPT1-DB-AMT Element: Intl Amt	Signed 18.2 Occurs 13 Times This is the total debit report 1 currency amount.	GL310
MCA-RPT1-CR-AMT Element: Intl Amt	Signed 18.2 Occurs 13 Times This is the total credit report 1 currency amount.	GL310
MCA-RPT2-DB-AMT Element: Intl Amt	Signed 18.2 Occurs 13 Times This is the total debit report 2 currency amount.	GL310
MCA-RPT2-CR-AMT Element: Intl Amt	Signed 18.2 Occurs 13 Times This is the total credit report 2 currency amount.	GL310
MCA-MAINT-DATE Element: Maint Date	Numeric 8 (yyyymmdd) This is the date the records were last updated.
MCA-MAINT-TIME Element: Sys Time	Numeric 6 (hhmmss) This is the time the records were last updated.
MCA-CPAMT-DR Element: Cpamt Dr	Derived This is the nonbase currency debit amount for the current period.
MCA-CPAMT-CR Element: Cpamt Cr	Derived This is the nonbase currency credit amount for the current period.
MCA-CPAMT Element: Cpamt	Derived This is the net nonbase currency amount for the current period.
MCA-CUR-PD-SUM-A-D Element: Cur Pd Sum A D	Derived This is the summary debit amount for the current period.
MCA-CUR-PD-SUM-A-C Element: Cur Pd Sum A C	Derived This is the summary credit amount for the current period.
MCA-CYBAMT Element: Cybamt	Derived This is the beginning base amount for the current year.
MCA-CYDAMT Element: Cydamt	Derived This is the year-to-date base amount.
MCA-CYPAMT1-DR Element: Cypamt1 Dr	Derived This is the period 1 base debit amount.
MCA-CYPAMT1-CR Element: Cypamt1 Cr	Derived This is the period 1 base credit amount.
MCA-CYPYTD1 Element: Cypamt1	Derived Current year period year to date period 1.
MCA-CYPAMT2-DR Element: Cypamt2 Dr	Derived This is the period 2 base debit amount.
MCA-CYPAMT2-CR Element: Cypamt2 Cr	Derived This is the period 2 base credit amount.
MCA-CYPYTD2 Element: Cypamt2	Derived Current year period year to date period 2.
MCA-CYPAMT3-DR Element: Cypamt3 Dr	Derived This is the period 3 base debit amount.
MCA-CYPAMT3-CR Element: Cypamt3 Cr	Derived This is the period 3 base credit amount.
MCA-CYPYTD3 Element: Cypamt3	Derived Current year period year to date period 3.
MCA-CYPAMT4-DR Element: Cypamt4 Dr	Derived This is the period 4 base debit amount.
MCA-CYPAMT4-CR Element: Cypamt4 Cr	Derived This is the period 4 base credit amount.
MCA-CYPYTD4 Element: Cypamt4	Derived Current year period year to date period 4.
MCA-CYPAMT5-DR Element: Cypamt5 Dr	Derived This is the period 5 base debit amount.
MCA-CYPAMT5-CR Element: Cypamt5 Cr	Derived This is the period 5 base credit amount.
MCA-CYPYTD5 Element: Cypamt5	Derived Current year period year to date period 5.
MCA-CYPAMT6-DR Element: Cypamt6 Dr	Derived This is the period 6 base debit amount.
MCA-CYPAMT6-CR Element: Cypamt6 Cr	Derived This is the period 6 base credit amount.
MCA-CYPYTD6 Element: Cypamt6	Derived Current year period year to date period 6.
MCA-CYPAMT7-DR Element: Cypamt7 Dr	Derived This is the period 7 base debit amount.
MCA-CYPAMT7-CR Element: Cypamt7 Cr	Derived This is the period 7 base credit amount.
MCA-CYPYTD7 Element: Cypamt7	Derived Current year period year to date period 7.
MCA-CYPAMT8-DR Element: Cypamt8 Dr	Derived This is the period 8 base debit amount.
MCA-CYPAMT8-CR Element: Cypamt8 Cr	Derived This is the period 8 base credit amount.
MCA-CYPYTD8 Element: Cypamt8	Derived Current year period year to date period 8.
MCA-CYPAMT9-DR Element: Cypamt9 Dr	Derived This is the period 9 base debit amount.
MCA-CYPAMT9-CR Element: Cypamt9 Cr	Derived This is the period 9 base credit amount.
MCA-CYPYTD9 Element: Cypamt9	Derived Current year period year to date period 9.
MCA-CYPAMT10-DR Element: Cypamt10 Dr	Derived This is the period 10 base debit amount.
MCA-CYPAMT10-CR Element: Cypamt10 Cr	Derived This is the period 10 base credit amount.
MCA-CYPYTD10 Element: Cypamt10	Derived Current year period year to date period 10.
MCA-CYPAMT11-DR Element: Cypamt11 Dr	Derived This is the period 11 base debit amount.
MCA-CYPAMT11-CR Element: Cypamt11 Cr	Derived This is the period 11 base credit amount.
MCA-CYPYTD11 Element: Cypamt11	Derived Current year period year to date period 11.
MCA-CYPAMT12-DR Element: Cypamt12 Dr	Derived This is the period 12 base debit amount.
MCA-CYPAMT12-CR Element: Cypamt12 Cr	Derived This is the period 12 base credit amount.
MCA-CYPYTD12 Element: Cypamt12	Derived Current year period year to date period 12.
MCA-CYPAMT13-DR Element: Cypamt13 Dr	Derived This is the period 13 base debit amount.
MCA-CYPAMT13-CR Element: Cypamt13 Cr	Derived This is the period 13 base credit amount.
MCA-CYPYTD13 Element: Cypamt13	Derived Current year period year to date period 13.
MCA-CPCUR-DR Element: Cpcur Dr	Derived This is the current period nonbase debit amount.
MCA-CPCUR-CR Element: Cpcur Cr	Derived This is the current period nonbase credit amount.
MCA-CPCUR Element: Cpcur	Derived This is the current period nonbase net amount.
MCA-CUR-PD-SUM-C-D Element: Cur Pd Sum C D	Derived This is the current period nonbase summary debit amount.
MCA-CUR-PD-SUM-C-C Element: Cur Pd Sum C C	Derived This is the current period nonbase summary credit amount.
MCA-CYBCUR Element: Cybcur	Derived This the nonbase currency current year beginning balance.
MCA-CYDCUR Element: Cydcur	Derived This the nonbase currency current year-to-date amount.
MCA-CYPCUR1-DR Element: Cypcur1 Dr	Derived This is the period 1 nonbase debit amount.
MCA-CYPCUR1-CR Element: Cypcur1 Cr	Derived This is the period 1 nonbase credit amount.
MCA-CURYTD1 Element: Cypcur1	Derived Currency current year period year to date period 1.
MCA-CYPCUR2-DR Element: Cypcur2 Dr	Derived This is the period 2 nonbase debit amount.
MCA-CYPCUR2-CR Element: Cypcur2 Cr	Derived This is the period 2 nonbase credit amount.
MCA-CURYTD2 Element: Cypcur2	Derived Currency current year period year to date period 2.
MCA-CYPCUR3-DR Element: Cypcur3 Dr	Derived This is the period 3 nonbase debit amount.
MCA-CYPCUR3-CR Element: Cypcur3 Cr	Derived This is the period 3 nonbase credit amount.
MCA-CURYTD3 Element: Cypcur3	Derived Currency current year period year to date period 3.
MCA-CYPCUR4-DR Element: Cypcur4 Dr	Derived This is the period 4 nonbase debit amount.
MCA-CYPCUR4-CR Element: Cypcur4 Cr	Derived This is the period 4 nonbase credit amount.
MCA-CURYTD4 Element: Cypcur4	Derived Currency current year period year to date period 4.
MCA-CYPCUR5-DR Element: Cypcur5 Dr	Derived This is the period 5 nonbase debit amount.
MCA-CYPCUR5-CR Element: Cypcur5 Cr	Derived This is the period 5 nonbase credit amount.
MCA-CURYTD5 Element: Cypcur5	Derived Currency current year period year to date period 5.
MCA-CYPCUR6-DR Element: Cypcur6 Dr	Derived This is the period 6 nonbase debit amount.
MCA-CYPCUR6-CR Element: Cypcur6 Cr	Derived This is the period 6 nonbase credit amount.
MCA-CURYTD6 Element: Cypcur6	Derived Currency current year period year to date period 6.
MCA-CYPCUR7-DR Element: Cypcur7 Dr	Derived This is the period 6 nonbase debit amount.
MCA-CYPCUR7-CR Element: Cypcur7 Cr	Derived This is the period 7 nonbase credit amount.
MCA-CURYTD7 Element: Cypcur7	Derived Currency current year period year to date period 7.
MCA-CYPCUR8-DR Element: Cypcur8 Dr	Derived This is the period 8 nonbase debit amount.
MCA-CYPCUR8-CR Element: Cypcur8 Cr	Derived This is the period 8 nonbase credit amount.
MCA-CURYTD8 Element: Cypcur8	Derived Currency current year period year to date period 8.
MCA-CYPCUR9-DR Element: Cypcur9 Dr	Derived This is the period 9 nonbase debit amount.
MCA-CYPCUR9-CR Element: Cypcur9 Cr	Derived This is the period 9 nonbase credit amount.
MCA-CURYTD9 Element: Cypcur9	Derived Currency current year period year to date period 9.
MCA-CYPCUR10-DR Element: Cypcur10 Dr	Derived This is the period 10 nonbase debit amount.
MCA-CYPCUR10-CR Element: Cypcur10 Cr	Derived This is the period 10 nonbase credit amount.
MCA-CURYTD10 Element: Cypcur10	Derived Currency current year period year to date period 10.
MCA-CYPCUR11-DR Element: Cypcur11 Dr	Derived This is the period 11 nonbase debit amount.
MCA-CYPCUR11-CR Element: Cypcur11 Cr	Derived This is the period 11 nonbase credit amount.
MCA-CURYTD11 Element: Cypcur11	Derived Currency current year period year to date period 11.
MCA-CYPCUR12-DR Element: Cypcur12 Dr	Derived This is the period 12 nonbase debit amount.
MCA-CYPCUR12-CR Element: Cypcur12 Cr	Derived This is the period 12 nonbase credit amount.
MCA-CURYTD12 Element: Cypcur12	Derived Currency current year period year to date period 12.
MCA-CYPCUR13-DR Element: Cypcur13 Dr	Derived This is the period 13 nonbase debit amount.
MCA-CYPCUR13-CR Element: Cypcur13 Cr	Derived This is the period 13 nonbase credit amount.
MCA-CURYTD13 Element: Cypcur13	Derived Currency current year period year to date period 13.
MCA-BLANK Element: Blank	Derived This derived field is always blank. It is used in the Drill Around feature for column headings.
MCA-PARENT-VAR-LEV Element: Parent Var Lev	Alpha 30 The variable level address of the parent accounting unit.	GL120

MLCUAMOUNT FILE INDEX

MLCUAMOUNT FILE RELATIONS

ONE TO ONE RELATIONS

MLCUAMOUNT FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.