|
|
MLCONSOL FILE
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
MLRV.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MCN-FISCAL-YEAR Numeric 4
Element: Last Closed YeThis is the fiscal year of the
consolidated record.
MCN-LEVEL-DEPTH Numeric 1
Element: Level Depth 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 Alpha 1
Element: Transaction TyThis 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 Alpha 15
Element: Ledger The ledger associated with the
consolidation record.
MCN-COMPANY Numeric 4
Element: Company The company associated to the ledger.
MCN-VAR-LEVELS Alpha 30
Element: Variable LevelThe variable level address of the
summary accounting unit associated with
this reord.
MCN-ACCOUNT Numeric 6
Element: Account 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 Numeric 4
Element: Subaccount 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 Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1).
MCN-DB-BEG-BAL Signed 18.2
Element: Intl Amt The debit beginning balance in base
currency
MCN-CR-BEG-BAL Signed 18.2
Element: Intl Amt The credit beginning balance in base
currency
MCN-DB-AMOUNT Signed 18.2 Occurs 13 Times
Element: Intl Amt The debit amount.
MCN-CR-AMOUNT Signed 18.2 Occurs 13 Times
Element: Intl Amt The credit amount.
MCN-ACCT-ND Numeric 1
Account Currency Number of decimal positions in the
Code account amounts.
MCN-CHART-NAME Alpha 12
Element: Chart Name This is the chart of accounts when you
assigned to your company structure in
the General Ledger system.
MCN-CPAMT-DR Derived
Element: Current PeriodThis is the current period debit amount.
MCN-CPAMT-CR Derived
Current Period This is the current period credit
Credit amount.
MCN-CPAMT Derived
Current Period This is the total current period amount.
Amount
MCN-CYBAMT Derived
Element: Cybamt This is the total current year
beginning balance.
MCN-CUR-PD-SUM-C-D Derived
Element: Cur Pd Sum C DThis is the current period summary
debit amount.
MCN-CUR-PD-SUM-C-C Derived
Element: Cur Pd Sum C CThis is the current period summary
credit amount.
MCN-CUR-PD-SUM-C Derived
Element: Cur Pd Sum C This is the total current period
summary amount.
MCN-CYDAMT Derived
Element: Cydamt This is the current year-to-date amount.
MCN-CPAMT-THOU Derived
Element: Cpamt Thou This is current period amount divided
by 1000.
MCN-CYDAMT-THOU Derived
Element: Cydamt Thou This is the current year-to-date amount
divided by 1000.
MCN-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
MCN-CYPAMT1-DR Derived
Period 1 Base Debit Current year period debit amount
Amount period 1.
MCN-CYPAMT1-CR Derived
Period 1 Base Current year period credit amount
Credit Amount period 1.
MCN-CYPAMT1 Derived
Element: Period 1 Base Current year period amount period 1.
MCN-CYPYTD1 Derived
Element: Period 1 Base Current year period year to date
period 1.
MCN-CYPAMT2-DR Derived
Period 2 Base Debit Current year period debit amount
Amount period 2.
MCN-CYPAMT2-CR Derived
Period 2 Base Current year period credit amount
Credit Amount period 2.
MCN-CYPAMT2 Derived
Element: Period 2 Base Current year period amount period 2.
MCN-CYPYTD2 Derived
Element: Period 2 Base Current year period year to date
period 2.
MCN-CYPAMT3-DR Derived
Period 3 Base Debit Current year period debit amount
Amount period 3.
MCN-CYPAMT3-CR Derived
Period 3 Base Current year period credit amount
Credit Amount period 3.
MCN-CYPAMT3 Derived
Element: Period 3 Base Current year period amount period 3.
MCN-CYPYTD3 Derived
Element: Period 3 Base Current year period year to date
period 3.
MCN-CYPAMT4-DR Derived
Period 4 Base Debit Current year period debit amount
Amount period 4.
MCN-CYPAMT4-CR Derived
Period 4 Base Current year period credit amount
Credit Amount period 4.
MCN-CYPAMT4 Derived
Element: Period 4 Base Current year period amount period 4.
MCN-CYPYTD4 Derived
Element: Period 4 Base Current year period year to date
period 4.
MCN-CYPAMT5-DR Derived
Period 5 Base Debit Current year period debit amount
Amount period 5.
MCN-CYPAMT5-CR Derived
Peirod 5 Base Current year period credit amount
Credit Amount period 5.
MCN-CYPAMT5 Derived
Element: Peirod 5 Base Current year period amount period 5.
MCN-CYPYTD5 Derived
Element: Peirod 5 Base Current year period year to date
period 5.
MCN-CYPAMT6-DR Derived
Period 6 Base Debit Current year period debit amount
Amount period 6.
MCN-CYPAMT6-CR Derived
Period 6 Base Current year period credit amount
Credit Amount period 6.
MCN-CYPAMT6 Derived
Element: Period 6 Base Current year period amount period 6.
MCN-CYPYTD6 Derived
Element: Period 6 Base Current year period year to date
period 6.
MCN-CYPAMT7-DR Derived
Period 7 Base Debit Current year period debit amount
Amount period 7.
MCN-CYPAMT7-CR Derived
Period 7 Base Current year period credit amount
Credit Amount period 7.
MCN-CYPAMT7 Derived
Element: Period 7 Base Current year period amount period 7.
MCN-CYPYTD7 Derived
Element: Period 7 Base Current year period year to date
period 7.
MCN-CYPAMT8-DR Derived
Period 8 Base Current year period debit amount
Detail Amount period 8.
MCN-CYPAMT8-CR Derived
Period 8 Base Current year period credit amount
Credit Amount period 8.
MCN-CYPAMT8 Derived
Element: Period 8 Base Current year period amount period 8.
MCN-CYPYTD8 Derived
Element: Period 8 Base Current year period year to date
period 8.
MCN-CYPAMT9-DR Derived
Period 9 Base Debit Current year period debit amount
Amount period 9.
MCN-CYPAMT9-CR Derived
Period 9 Base Current year period credit amount
Credit Amount period 9.
MCN-CYPAMT9 Derived
Element: Period 9 Base Current year period amount period 9.
MCN-CYPYTD9 Derived
Element: Period 9 Base Current year period year to date
period 9.
MCN-CYPAMT10-DR Derived
Period 10 Base Current year period debit amount
Debit Amount period 10.
MCN-CYPAMT10-CR Derived
Period 10 Base Current year period credit amount
Credit Amount period 10.
MCN-CYPAMT10 Derived
Period 10 Baes Current year period amount period 10.
Amount
MCN-CYPYTD10 Derived
Period 10 Baes Current year period year to date
Amount period 10.
MCN-CYPAMT11-DR Derived
Period 11 Base Current year period debit amount
Debit Amount period 11.
MCN-CYPAMT11-CR Derived
Period 11 Base Current year period credit amount
Credit Amount period 11.
MCN-CYPAMT11 Derived
Period 11 Base Current year period amount period 11.
Amount
MCN-CYPYTD11 Derived
Period 11 Base Current year period year to date
Amount period 11.
MCN-CYPAMT12-DR Derived
Period 12 Base Current year period debit amount
Debit Amount period 12.
MCN-CYPAMT12-CR Derived
Period 12 Base Current year period credit amount
Credit Amount period 12.
MCN-CYPAMT12 Derived
Period 12 Base Current year period amount period 12.
Amount
MCN-CYPYTD12 Derived
Period 12 Base Current year period year to date
Amount period 12.
MCN-CYPAMT13-DR Derived
Period 13 Base Current year period debit amount
Debit Amount period 13.
MCN-CYPAMT13-CR Derived
Period 13 Base Current year period credit amount
Credit Amount period 13.
MCN-CYPAMT13 Derived
Period 13 Base Current year period amount period 13.
Amount
MCN-CYPYTD13 Derived
Period 13 Base Current year period year to date
Amount period 13.
MCN-PARENT-VAR-LEV Alpha 30
Element: Parent Var LevThe variable level address of the parent
accounting unit.
MLCONSOL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MCNSET1 FISCAL-YEAR MLRV.1
LEVEL-DEPTH
TRANS-TYPE
LEDGER
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
CURRENCY-CODE
MCNSET2 FISCAL-YEAR MLRV.1
LEVEL-DEPTH
TRANS-TYPE
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
CURRENCY-CODE
MCNSET3 FISCAL-YEAR MLRV.1
LEVEL-DEPTH
TRANS-TYPE
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
LEDGER
COMPANY
CURRENCY-CODE
MCNSET4 FISCAL-YEAR MLRV.1
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
MLCONSOL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
