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.
REFERENCED BY
ML191 | ML291 | ML196 | ML320 | RW80.1 | ML290 |
MLRV.1 | ML90.1 | ML90.4 |
GL120 | GL310 | ML110 | ML146 | ML167 | ML190 |
ML199 | ML300 | ML327 | ML330 | ML40.1 | ML40.2 |
ML40.3 | ML40.7 | ML40.8 | ML44.1 | ML45.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. |
|
||||||||||||||
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. |
|
||||||||||||||
MCA-RPT1-CR-BBAL Element: Intl Amt | Signed 18.2 This is the beginning credit balance for report 1 currency amounts. |
|
||||||||||||||
MCA-RPT2-DB-BBAL Element: Intl Amt | Signed 18.2 This is the beginning debit balance for report 2 currency amounts. |
|
||||||||||||||
MCA-RPT2-CR-BBAL Element: Intl Amt | Signed 18.2 This is the beginning credit balance for report 2 currency amounts. |
|
||||||||||||||
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. |
|
||||||||||||||
MCA-RPT1-CR-AMT Element: Intl Amt | Signed 18.2 Occurs 13 Times This is the total credit report 1 currency amount. |
|
||||||||||||||
MCA-RPT2-DB-AMT Element: Intl Amt | Signed 18.2 Occurs 13 Times This is the total debit report 2 currency amount. |
|
||||||||||||||
MCA-RPT2-CR-AMT Element: Intl Amt | Signed 18.2 Occurs 13 Times This is the total credit report 2 currency amount. |
|
||||||||||||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MCASET1 |
FISCAL-YEAR LEDGER COMPANY AMT-TYPE VAR-LEVELS ACCOUNT SUB-ACCOUNT ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||
MCASET2 |
FISCAL-YEAR LEDGER COMPANY AMT-TYPE CURRENCY-CODE ACCOUNT SUB-ACCOUNT VAR-LEVELS ACCT-UNIT |
|
| ||||||||||||||||||||||||
MCASET3 |
AMT-TYPE FISCAL-YEAR LEDGER COMPANY VAR-LEVELS ACCOUNT SUB-ACCOUNT ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||
MCASET4 |
AMT-TYPE FISCAL-YEAR LEDGER COMPANY ACCOUNT SUB-ACCOUNT VAR-LEVELS ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||
MCASET5 |
LEDGER COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT AMT-TYPE CURRENCY-CODE FISCAL-YEAR VAR-LEVELS |
|
| ||||||||||||||||||||||||
MCASET6 |
AMT-TYPE FISCAL-YEAR VAR-LEVELS ACCOUNT SUB-ACCOUNT LEDGER COMPANY ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||
MCASET7 |
AMT-TYPE FISCAL-YEAR ACCOUNT SUB-ACCOUNT VAR-LEVELS LEDGER COMPANY ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||
MCASET9 |
PARENT-VAR-LEV AMT-TYPE LEDGER COMPANY ACCOUNT SUB-ACCOUNT FISCAL-YEAR ACCT-UNIT VAR-LEVELS CURRENCY-CODE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Chart Detail | GLCHARTDTL |
Required
| |||||||||||||||||||||
Company | GLSYSTEM |
Not Required
| |||||||||||||||||||||
Cucodes | CUCODES |
Required
| |||||||||||||||||||||
Glnames | GLNAMES |
Required
| |||||||||||||||||||||
Mla Sibling | MLAMOUNTS |
Required
| |||||||||||||||||||||
Mlcoledger | MLCOLEDGER |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Consol Parent1 | MLCONSOL |
| ||||||||||||||||||||||||||||||
Consol Parent2 | MLCONSOL |
| ||||||||||||||||||||||||||||||
Curr 1 | MLCUAMOUNT |
| ||||||||||||||||||||||||||||||
Curr 2 | MLCUAMOUNT |
| ||||||||||||||||||||||||||||||
Mltrans 1 Prd | MLTRANS |
| ||||||||||||||||||||||||||||||
Mltrans 1 Year | MLTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.