Multi-Book Ledger Consolidated

This file contains consolidated account balances for the MLAMOUNTS, MLCUAMOUNT, and MLUNITS. Consolidated balances are kept for summary level accounting units. The purpose of this file is for reporting summary balances. This file also stores consolidated summary level account balances for the report currencies.
UPDATED BY

MLRV.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
MCN-FISCAL-YEAR Element: Year	Numeric 4 This is the fiscal year of the consolidated record.
MCN-LEVEL-DEPTH Element: Level Depth	Numeric 1 The summary level depth. "0" = Company Level. "1" = Level 1. "2" = Level 2. "3" = Level 3. "4" = Level 4. 0 = Company 1 = Level 1 2 = Level 2 3 = Level 3 4 = Level 4
MCN-TRANS-TYPE Element: Trans Type	Alpha 1 This is the type of transaction. The consolidated records are stored for amounts, units, transaction currency , currency one, and currency two. A = Amounts U = Units C = Currency Y = Currency One Z = Currency Two
MCN-LEDGER Element: Ledger	Alpha 15 The ledger associated with the consolidation record.
MCN-COMPANY Element: Company	Numeric 4 The company associated to the ledger.
MCN-VAR-LEVELS Element: Var Levels	Alpha 30 The variable level address of the summary accounting unit associated with this reord.
MCN-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.
MCN-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.
MCN-CURRENCY-CODE Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1).
MCN-DB-BEG-BAL Element: Intl Amt	Signed 18.2 The debit beginning balance in base currency
MCN-CR-BEG-BAL Element: Intl Amt	Signed 18.2 The credit beginning balance in base currency
MCN-DB-AMOUNT Element: Intl Amt	Signed 18.2 Occurs 13 Times The debit amount.
MCN-CR-AMOUNT Element: Intl Amt	Signed 18.2 Occurs 13 Times The credit amount.
MCN-ACCT-ND Element: Acct Nd	Numeric 1 Number of decimal positions in the account amounts.
MCN-CHART-NAME Element: Chart Name	Alpha 12 This is the chart of accounts when you assigned to your company structure in the General Ledger system.
MCN-CPAMT-DR Element: Cpamt Dr	Derived This is the current period debit amount.
MCN-CPAMT-CR Element: Cpamt Cr	Derived This is the current period credit amount.
MCN-CPAMT Element: Cpamt	Derived This is the total current period amount.
MCN-CYBAMT Element: Cybamt	Derived This is the total current year beginning balance.
MCN-CUR-PD-SUM-C-D Element: Cur Pd Sum C D	Derived This is the current period summary debit amount.
MCN-CUR-PD-SUM-C-C Element: Cur Pd Sum C C	Derived This is the current period summary credit amount.
MCN-CUR-PD-SUM-C Element: Cur Pd Sum C	Derived This is the total current period summary amount.
MCN-CYDAMT Element: Cydamt	Derived This is the current year-to-date amount.
MCN-CPAMT-THOU Element: Cpamt Thou	Derived This is current period amount divided by 1000.
MCN-CYDAMT-THOU Element: Cydamt Thou	Derived This is the current year-to-date amount divided by 1000.
MCN-BLANK Element: Blank	Derived This derived field is always blank. It is used in the Drill Around feature for column headings.
MCN-CYPAMT1-DR Element: Cypamt1 Dr	Derived Current year period debit amount period 1.
MCN-CYPAMT1-CR Element: Cypamt1 Cr	Derived Current year period credit amount period 1.
MCN-CYPAMT1 Element: Cypamt1	Derived Current year period amount period 1.
MCN-CYPYTD1 Element: Cypamt1	Derived Current year period year to date period 1.
MCN-CYPAMT2-DR Element: Cypamt2 Dr	Derived Current year period debit amount period 2.
MCN-CYPAMT2-CR Element: Cypamt2 Cr	Derived Current year period credit amount period 2.
MCN-CYPAMT2 Element: Cypamt2	Derived Current year period amount period 2.
MCN-CYPYTD2 Element: Cypamt2	Derived Current year period year to date period 2.
MCN-CYPAMT3-DR Element: Cypamt3 Dr	Derived Current year period debit amount period 3.
MCN-CYPAMT3-CR Element: Cypamt3 Cr	Derived Current year period credit amount period 3.
MCN-CYPAMT3 Element: Cypamt3	Derived Current year period amount period 3.
MCN-CYPYTD3 Element: Cypamt3	Derived Current year period year to date period 3.
MCN-CYPAMT4-DR Element: Cypamt4 Dr	Derived Current year period debit amount period 4.
MCN-CYPAMT4-CR Element: Cypamt4 Cr	Derived Current year period credit amount period 4.
MCN-CYPAMT4 Element: Cypamt4	Derived Current year period amount period 4.
MCN-CYPYTD4 Element: Cypamt4	Derived Current year period year to date period 4.
MCN-CYPAMT5-DR Element: Cypamt5 Dr	Derived Current year period debit amount period 5.
MCN-CYPAMT5-CR Element: Cypamt5 Cr	Derived Current year period credit amount period 5.
MCN-CYPAMT5 Element: Cypamt5	Derived Current year period amount period 5.
MCN-CYPYTD5 Element: Cypamt5	Derived Current year period year to date period 5.
MCN-CYPAMT6-DR Element: Cypamt6 Dr	Derived Current year period debit amount period 6.
MCN-CYPAMT6-CR Element: Cypamt6 Cr	Derived Current year period credit amount period 6.
MCN-CYPAMT6 Element: Cypamt6	Derived Current year period amount period 6.
MCN-CYPYTD6 Element: Cypamt6	Derived Current year period year to date period 6.
MCN-CYPAMT7-DR Element: Cypamt7 Dr	Derived Current year period debit amount period 7.
MCN-CYPAMT7-CR Element: Cypamt7 Cr	Derived Current year period credit amount period 7.
MCN-CYPAMT7 Element: Cypamt7	Derived Current year period amount period 7.
MCN-CYPYTD7 Element: Cypamt7	Derived Current year period year to date period 7.
MCN-CYPAMT8-DR Element: Cypamt8 Dr	Derived Current year period debit amount period 8.
MCN-CYPAMT8-CR Element: Cypamt8 Cr	Derived Current year period credit amount period 8.
MCN-CYPAMT8 Element: Cypamt8	Derived Current year period amount period 8.
MCN-CYPYTD8 Element: Cypamt8	Derived Current year period year to date period 8.
MCN-CYPAMT9-DR Element: Cypamt9 Dr	Derived Current year period debit amount period 9.
MCN-CYPAMT9-CR Element: Cypamt9 Cr	Derived Current year period credit amount period 9.
MCN-CYPAMT9 Element: Cypamt9	Derived Current year period amount period 9.
MCN-CYPYTD9 Element: Cypamt9	Derived Current year period year to date period 9.
MCN-CYPAMT10-DR Element: Cypamt10 Dr	Derived Current year period debit amount period 10.
MCN-CYPAMT10-CR Element: Cypamt10 Cr	Derived Current year period credit amount period 10.
MCN-CYPAMT10 Element: Cypamt10	Derived Current year period amount period 10.
MCN-CYPYTD10 Element: Cypamt10	Derived Current year period year to date period 10.
MCN-CYPAMT11-DR Element: Cypamt11 Dr	Derived Current year period debit amount period 11.
MCN-CYPAMT11-CR Element: Cypamt11 Cr	Derived Current year period credit amount period 11.
MCN-CYPAMT11 Element: Cypamt11	Derived Current year period amount period 11.
MCN-CYPYTD11 Element: Cypamt11	Derived Current year period year to date period 11.
MCN-CYPAMT12-DR Element: Cypamt12 Dr	Derived Current year period debit amount period 12.
MCN-CYPAMT12-CR Element: Cypamt12 Cr	Derived Current year period credit amount period 12.
MCN-CYPAMT12 Element: Cypamt12	Derived Current year period amount period 12.
MCN-CYPYTD12 Element: Cypamt12	Derived Current year period year to date period 12.
MCN-CYPAMT13-DR Element: Cypamt13 Dr	Derived Current year period debit amount period 13.
MCN-CYPAMT13-CR Element: Cypamt13 Cr	Derived Current year period credit amount period 13.
MCN-CYPAMT13 Element: Cypamt13	Derived Current year period amount period 13.
MCN-CYPYTD13 Element: Cypamt13	Derived Current year period year to date period 13.
MCN-PARENT-VAR-LEV Element: Parent Var Lev	Alpha 30 The variable level address of the parent accounting unit.

MLCONSOL FILE INDEX

MLCONSOL FILE RELATIONS

ONE TO ONE RELATIONS

MLCONSOL FILE RELATIONS

ONE TO MANY RELATIONS

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