MLCONSOL

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.

REFERENCED BY
ML195


UPDATED BY
ML110 ML146 ML167 ML190 ML199 ML300
ML320 ML40.1 ML40.2 ML40.3 ML40.7 ML40.8
ML44.1 ML45.1 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.
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
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
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
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
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MCN-LEDGER
Element: Ledger
Alpha 15
The ledger associated with the consolidation record.
ML110 ML146
ML167 ML190
ML199 ML320
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
MCN-COMPANY
Element: Company
Numeric 4
The company associated to the ledger.
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MCN-VAR-LEVELS
Element: Var Levels
Alpha 30
The variable level address of the summary accounting unit associated with this reord.
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
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.
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
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.
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MCN-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1).
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MCN-DB-BEG-BAL
Element: Intl Amt
Signed 18.2
The debit beginning balance in base currency
ML110 ML167
ML199 ML320
MCN-CR-BEG-BAL
Element: Intl Amt
Signed 18.2
The credit beginning balance in base currency
ML110 ML167
ML199 ML320
MCN-DB-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The debit amount.
ML110 ML146
ML167 ML190
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MCN-CR-AMOUNT
Element: Intl Amt
Signed 18.2 Occurs 13 Times
The credit amount.
ML110 ML146
ML167 ML190
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MCN-ACCT-ND
Element: Acct Nd
Numeric 1
Number of decimal positions in the account amounts.
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
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.
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
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.
ML146 ML167
ML190 ML199
ML320 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1


MLCONSOL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MCNSET1 FISCAL-YEAR
LEVEL-DEPTH
TRANS-TYPE
LEDGER
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
CURRENCY-CODE
ML110 ML146
ML167 ML190
ML195 ML199
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 MLRV.1
MCNSET2 FISCAL-YEAR
LEVEL-DEPTH
TRANS-TYPE
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
CURRENCY-CODE
ML195 ML199
ML320 MLRV.1
MCNSET3 FISCAL-YEAR
LEVEL-DEPTH
TRANS-TYPE
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
LEDGER
COMPANY
CURRENCY-CODE
MLRV.1
MCNSET4 FISCAL-YEAR
LEVEL-DEPTH
TRANS-TYPE
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
LEDGER
COMPANY
CURRENCY-CODE
MLRV.1
MCNSET5 LEDGER
COMPANY
TRANS-TYPE
FISCAL-YEAR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
CURRENCY-CODE
LEVEL-DEPTH
ML110 ML300
MCNSET8 PARENT-VAR-LEV
TRANS-TYPE
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
LEVEL-DEPTH
VAR-LEVELS
CURRENCY-CODE
MCNSET9 VAR-LEVELS
TRANS-TYPE
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
LEVEL-DEPTH
CURRENCY-CODE


MLCONSOL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Chart Details GLCHARTDTL Required
MCN-CHART-NAME->GDT-CHART-NAME (GDTSET2)
MCN-ACCOUNT->GDT-ACCOUNT
MCN-SUB-ACCOUNT->GDT-SUB-ACCOUNT
Glsystem GLSYSTEM Required
MCN-COMPANY->GLS-COMPANY


MLCONSOL FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Base MLCONSOL
MCN-VAR-LEVELS->MCN-VAR-LEVELS
"A"->MCN-TRANS-TYPE
MCN-LEDGER->MCN-LEDGER
MCN-COMPANY->MCN-COMPANY
MCN-ACCOUNT->MCN-ACCOUNT
MCN-SUB-ACCOUNT->MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR->MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH->MCN-LEVEL-DEPTH
  MCN-CURRENCY-CODE
Cam Children 1 MLCUAMOUNT
MCN-VAR-LEVELS->MCA-PARENT-VAR-LEV
3->MCA-AMT-TYPE
MCN-LEDGER->MCA-LEDGER
MCN-COMPANY->MCA-COMPANY
MCN-ACCOUNT->MCA-ACCOUNT
MCN-SUB-ACCOUNT->MCA-SUB-ACCOUNT
MCN-FISCAL-YEAR->MCA-FISCAL-YEAR
  MCA-ACCT-UNIT
  MCA-VAR-LEVELS
  MCA-CURRENCY-CODE
Cam Children 2 MLCUAMOUNT
MCN-VAR-LEVELS->MCA-PARENT-VAR-LEV
4->MCA-AMT-TYPE
MCN-LEDGER->MCA-LEDGER
MCN-COMPANY->MCA-COMPANY
MCN-ACCOUNT->MCA-ACCOUNT
MCN-SUB-ACCOUNT->MCA-SUB-ACCOUNT
MCN-FISCAL-YEAR->MCA-FISCAL-YEAR
  MCA-ACCT-UNIT
  MCA-VAR-LEVELS
  MCA-CURRENCY-CODE
Children MLCONSOL
MCN-VAR-LEVELS->MCN-PARENT-VAR-LEV
MCN-TRANS-TYPE->MCN-TRANS-TYPE
MCN-LEDGER->MCN-LEDGER
MCN-COMPANY->MCN-COMPANY
MCN-ACCOUNT->MCN-ACCOUNT
MCN-SUB-ACCOUNT->MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR->MCN-FISCAL-YEAR
  MCN-LEVEL-DEPTH
  MCN-VAR-LEVELS
  MCN-CURRENCY-CODE
Curr 1 MLCONSOL
MCN-VAR-LEVELS->MCN-VAR-LEVELS
"Y"->MCN-TRANS-TYPE
MCN-LEDGER->MCN-LEDGER
MCN-COMPANY->MCN-COMPANY
MCN-ACCOUNT->MCN-ACCOUNT
MCN-SUB-ACCOUNT->MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR->MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH->MCN-LEVEL-DEPTH
  MCN-CURRENCY-CODE
Curr 2 MLCONSOL
MCN-VAR-LEVELS->MCN-VAR-LEVELS
"Z"->MCN-TRANS-TYPE
MCN-LEDGER->MCN-LEDGER
MCN-COMPANY->MCN-COMPANY
MCN-ACCOUNT->MCN-ACCOUNT
MCN-SUB-ACCOUNT->MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR->MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH->MCN-LEVEL-DEPTH
  MCN-CURRENCY-CODE
Gam Children MLAMOUNTS
MCN-VAR-LEVELS->MLA-PARENT-VAR-LEV
MCN-LEDGER->MLA-LEDGER
MCN-COMPANY->MLA-COMPANY
MCN-ACCOUNT->MLA-ACCOUNT
MCN-SUB-ACCOUNT->MLA-SUB-ACCOUNT
MCN-FISCAL-YEAR->MLA-FISCAL-YEAR
  MLA-ACCT-UNIT
Glnames GLNAMES Required
MCN-COMPANY->GLN-COMPANY
MCN-VAR-LEVELS->GLN-VAR-LEVELS
  GLN-ACCT-UNIT
Mlu Children MLUNITS
MCN-VAR-LEVELS->MLU-PARENT-VAR-LEV
MCN-LEDGER->MLU-LEDGER
MCN-COMPANY->MLU-COMPANY
MCN-ACCOUNT->MLU-ACCOUNT
MCN-SUB-ACCOUNT->MLU-SUB-ACCOUNT
MCN-FISCAL-YEAR->MLU-FISCAL-YEAR
  MLU-ACCT-UNIT
Parent MLCONSOL
MCN-PARENT-VAR-LEV->MCN-VAR-LEVELS
MCN-TRANS-TYPE->MCN-TRANS-TYPE
MCN-LEDGER->MCN-LEDGER
MCN-COMPANY->MCN-COMPANY
MCN-ACCOUNT->MCN-ACCOUNT
MCN-SUB-ACCOUNT->MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR->MCN-FISCAL-YEAR
  MCN-LEVEL-DEPTH
  MCN-CURRENCY-CODE


File created: Thu Jun 09 11:21:12 2016

Home
Contact Us



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