|
|
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: Year This 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: Trans Type 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 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: Var Levels The 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: Sub Acct 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
Element: Acct Nd Number of decimal positions in the
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: Cpamt Dr This is the current period debit amount.
MCN-CPAMT-CR Derived
Element: Cpamt Cr This is the current period credit
amount.
MCN-CPAMT Derived
Element: Cpamt This is the total current period 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
Element: Cypamt1 Dr Current year period debit amount
period 1.
MCN-CYPAMT1-CR Derived
Element: Cypamt1 Cr Current year period credit amount
period 1.
MCN-CYPAMT1 Derived
Element: Cypamt1 Current year period amount period 1.
MCN-CYPYTD1 Derived
Element: Cypamt1 Current year period year to date
period 1.
MCN-CYPAMT2-DR Derived
Element: Cypamt2 Dr Current year period debit amount
period 2.
MCN-CYPAMT2-CR Derived
Element: Cypamt2 Cr Current year period credit amount
period 2.
MCN-CYPAMT2 Derived
Element: Cypamt2 Current year period amount period 2.
MCN-CYPYTD2 Derived
Element: Cypamt2 Current year period year to date
period 2.
MCN-CYPAMT3-DR Derived
Element: Cypamt3 Dr Current year period debit amount
period 3.
MCN-CYPAMT3-CR Derived
Element: Cypamt3 Cr Current year period credit amount
period 3.
MCN-CYPAMT3 Derived
Element: Cypamt3 Current year period amount period 3.
MCN-CYPYTD3 Derived
Element: Cypamt3 Current year period year to date
period 3.
MCN-CYPAMT4-DR Derived
Element: Cypamt4 Dr Current year period debit amount
period 4.
MCN-CYPAMT4-CR Derived
Element: Cypamt4 Cr Current year period credit amount
period 4.
MCN-CYPAMT4 Derived
Element: Cypamt4 Current year period amount period 4.
MCN-CYPYTD4 Derived
Element: Cypamt4 Current year period year to date
period 4.
MCN-CYPAMT5-DR Derived
Element: Cypamt5 Dr Current year period debit amount
period 5.
MCN-CYPAMT5-CR Derived
Element: Cypamt5 Cr Current year period credit amount
period 5.
MCN-CYPAMT5 Derived
Element: Cypamt5 Current year period amount period 5.
MCN-CYPYTD5 Derived
Element: Cypamt5 Current year period year to date
period 5.
MCN-CYPAMT6-DR Derived
Element: Cypamt6 Dr Current year period debit amount
period 6.
MCN-CYPAMT6-CR Derived
Element: Cypamt6 Cr Current year period credit amount
period 6.
MCN-CYPAMT6 Derived
Element: Cypamt6 Current year period amount period 6.
MCN-CYPYTD6 Derived
Element: Cypamt6 Current year period year to date
period 6.
MCN-CYPAMT7-DR Derived
Element: Cypamt7 Dr Current year period debit amount
period 7.
MCN-CYPAMT7-CR Derived
Element: Cypamt7 Cr Current year period credit amount
period 7.
MCN-CYPAMT7 Derived
Element: Cypamt7 Current year period amount period 7.
MCN-CYPYTD7 Derived
Element: Cypamt7 Current year period year to date
period 7.
MCN-CYPAMT8-DR Derived
Element: Cypamt8 Dr Current year period debit amount
period 8.
MCN-CYPAMT8-CR Derived
Element: Cypamt8 Cr Current year period credit amount
period 8.
MCN-CYPAMT8 Derived
Element: Cypamt8 Current year period amount period 8.
MCN-CYPYTD8 Derived
Element: Cypamt8 Current year period year to date
period 8.
MCN-CYPAMT9-DR Derived
Element: Cypamt9 Dr Current year period debit amount
period 9.
MCN-CYPAMT9-CR Derived
Element: Cypamt9 Cr Current year period credit amount
period 9.
MCN-CYPAMT9 Derived
Element: Cypamt9 Current year period amount period 9.
MCN-CYPYTD9 Derived
Element: Cypamt9 Current year period year to date
period 9.
MCN-CYPAMT10-DR Derived
Element: Cypamt10 Dr Current year period debit amount
period 10.
MCN-CYPAMT10-CR Derived
Element: Cypamt10 Cr Current year period credit amount
period 10.
MCN-CYPAMT10 Derived
Element: Cypamt10 Current year period amount period 10.
MCN-CYPYTD10 Derived
Element: Cypamt10 Current year period year to date
period 10.
MCN-CYPAMT11-DR Derived
Element: Cypamt11 Dr Current year period debit amount
period 11.
MCN-CYPAMT11-CR Derived
Element: Cypamt11 Cr Current year period credit amount
period 11.
MCN-CYPAMT11 Derived
Element: Cypamt11 Current year period amount period 11.
MCN-CYPYTD11 Derived
Element: Cypamt11 Current year period year to date
period 11.
MCN-CYPAMT12-DR Derived
Element: Cypamt12 Dr Current year period debit amount
period 12.
MCN-CYPAMT12-CR Derived
Element: Cypamt12 Cr Current year period credit amount
period 12.
MCN-CYPAMT12 Derived
Element: Cypamt12 Current year period amount period 12.
MCN-CYPYTD12 Derived
Element: Cypamt12 Current year period year to date
period 12.
MCN-CYPAMT13-DR Derived
Element: Cypamt13 Dr Current year period debit amount
period 13.
MCN-CYPAMT13-CR Derived
Element: Cypamt13 Cr Current year period credit amount
period 13.
MCN-CYPAMT13 Derived
Element: Cypamt13 Current year period amount period 13.
MCN-CYPYTD13 Derived
Element: Cypamt13 Current year period year to date
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
|
