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 | MLRV.1 |
ML110 | ML146 | ML167 | ML190 | ML199 | ML300 |
ML320 | ML40.1 | ML40.2 | ML40.3 | ML40.7 | ML40.8 |
ML44.1 | ML45.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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MCNSET1 |
FISCAL-YEAR LEVEL-DEPTH TRANS-TYPE LEDGER COMPANY VAR-LEVELS ACCOUNT SUB-ACCOUNT CURRENCY-CODE |
|
| ||||||||||||||||||||
MCNSET2 |
FISCAL-YEAR LEVEL-DEPTH TRANS-TYPE LEDGER COMPANY ACCOUNT SUB-ACCOUNT VAR-LEVELS CURRENCY-CODE |
|
| ||||||||||||||||||||
MCNSET3 |
FISCAL-YEAR LEVEL-DEPTH TRANS-TYPE ACCOUNT SUB-ACCOUNT VAR-LEVELS LEDGER COMPANY CURRENCY-CODE |
|
| ||||||||||||||||||||
MCNSET4 |
FISCAL-YEAR LEVEL-DEPTH TRANS-TYPE VAR-LEVELS ACCOUNT SUB-ACCOUNT LEDGER COMPANY CURRENCY-CODE |
|
| ||||||||||||||||||||
MCNSET5 |
LEDGER COMPANY TRANS-TYPE FISCAL-YEAR VAR-LEVELS ACCOUNT SUB-ACCOUNT CURRENCY-CODE LEVEL-DEPTH |
|
| ||||||||||||||||||||
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 |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Chart Details | GLCHARTDTL |
Required
| |||||||||
Glsystem | GLSYSTEM |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Base | MLCONSOL |
| ||||||||||||||||||||||||||||||
Cam Children 1 | MLCUAMOUNT |
| ||||||||||||||||||||||||||||||
Cam Children 2 | MLCUAMOUNT |
| ||||||||||||||||||||||||||||||
Children | MLCONSOL |
| ||||||||||||||||||||||||||||||
Curr 1 | MLCONSOL |
| ||||||||||||||||||||||||||||||
Curr 2 | MLCONSOL |
| ||||||||||||||||||||||||||||||
Gam Children | MLAMOUNTS |
| ||||||||||||||||||||||||||||||
Glnames | GLNAMES |
Required
| ||||||||||||||||||||||||||||||
Mlu Children | MLUNITS |
| ||||||||||||||||||||||||||||||
Parent | MLCONSOL |
|
All trademarks and registered trademarks are the property of their
respective owners.