MLCONSOL FILE
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
Fiscal Year This is the current fiscal year. This
field is updated by Ledger Period
Closing (ML199).
MCN-LEVEL-DEPTH Numeric 1
Level Depth
The summary level depth.
"0" = Company Level.
"1" = Level 1.
"2" = Level 2.
"3" = Level 3.
"4" = Level 4.
MCN-TRANS-TYPE Alpha 1
Transaction Type This determines if amounts or units are
processed in each transaction.
MCN-LEDGER Alpha 15
Ledger The ledger to which transactions are
written.
MCN-COMPANY Numeric 4
Company The company associated to the ledger.
MCN-VAR-LEVELS Alpha 30
Variable Levels A level that represents the location of
an accounting unit in an organization's
level structure.
MCN-ACCOUNT Numeric 6
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
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
Currency Code This field contains the company base
currency code established in Company
(GL10.1).
MCN-DB-BEG-BAL Currency 15.2
Debit Beginning The debit beginning balance in base
Balance currency
MCN-CR-BEG-BAL Currency 15.2
Credit Beginning The credit beginning balance in base
Balance currency
MCN-DB-AMOUNT Currency 15.2 Occurs 13 Times
Debit Amount The debit amount.
MCN-CR-AMOUNT Currency 15.2 Occurs 13 Times
Credit Amount The credit amount.
MCN-ACCT-ND Numeric 1
Account Currency Number of decimal positions in the
Code account amounts.
MCN-CHART-NAME Alpha 12
Chart Name This is the chart of accounts when you
assigned to your company structure in
the General Ledger system.
MCN-CPAMT-DR Derived
Current Period Debit This 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
Cybamt This is the total current year
beginning balance.
MCN-CUR-PD-SUM-C-D Derived
Cur Pd Sum C D This is the current period summary
debit amount.
MCN-CUR-PD-SUM-C-C Derived
Cur Pd Sum C C This is the current period summary
credit amount.
MCN-CUR-PD-SUM-C Derived
Cur Pd Sum C This is the total current period
summary amount.
MCN-CYDAMT Derived
Cydamt This is the current year-to-date amount.
MCN-CPAMT-THOU Derived
Cpamt Thou This is current period amount divided
by 1000.
MCN-CYDAMT-THOU Derived
Cydamt Thou This is the current year-to-date amount
divided by 1000.
MCN-BLANK Derived
Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
MCN-OBJ-ID Numeric 12
Object This is the object identifier. It is a
Identification unique key which facilitates drill
around.
MCN-PARENT-OBJ-ID Numeric 12
Parent Obj Id This is the parent object identifier.
This unique key facilitates drill around
to the parent record.
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
MCNSET6 OBJ-ID
TRANS-TYPE
LEDGER
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
LEVEL-DEPTH
CURRENCY-CODE
MCNSET7 PARENT-OBJ-ID
OBJ-ID
TRANS-TYPE
LEDGER
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
LEVEL-DEPTH
CURRENCY-CODE
MLCONSOL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Required
MCN-COMPANY -> GLS-COMPANY (GLSSET1)
MLCONSOL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base MLCONSOL
MCN-OBJ-ID -> MCN-OBJ-ID
"A" -> MCN-TRANS-TYPE
MCN-LEDGER -> MCN-LEDGER
MCN-COMPANY -> MCN-COMPANY
MCN-VAR-LEVELS -> MCN-VAR-LEVELS
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-OBJ-ID -> MCA-PARENT-OBJ-ID
3 -> MCA-AMT-TYPE
MCN-LEDGER -> MCA-LEDGER
MCN-COMPANY -> MCA-COMPANY
MCA-ACCT-UNIT
MCA-ACCOUNT
MCA-SUB-ACCOUNT
MCA-VAR-LEVELS
MCA-FISCAL-YEAR
MCA-CURRENCY-CODE
Cam Children 2 MLCUAMOUNT
MCN-OBJ-ID -> MCA-PARENT-OBJ-ID
4 -> MCA-AMT-TYPE
MCN-LEDGER -> MCA-LEDGER
MCN-COMPANY -> MCA-COMPANY
MCA-ACCT-UNIT
MCA-ACCOUNT
MCA-SUB-ACCOUNT
MCA-VAR-LEVELS
MCA-FISCAL-YEAR
MCA-CURRENCY-CODE
Children MLCONSOL
MCN-PARENT-OBJ-ID -> MCN-PARENT-OBJ-ID
MCN-OBJ-ID -> MCN-OBJ-ID
MCN-TRANS-TYPE -> MCN-TRANS-TYPE
MCN-LEDGER -> MCN-LEDGER
MCN-COMPANY -> MCN-COMPANY
MCN-VAR-LEVELS
MCN-ACCOUNT
MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
Curr 1 MLCONSOL
MCN-OBJ-ID -> MCN-OBJ-ID
"Y" -> MCN-TRANS-TYPE
MCN-LEDGER -> MCN-LEDGER
MCN-COMPANY -> MCN-COMPANY
MCN-VAR-LEVELS -> MCN-VAR-LEVELS
MCN-ACCOUNT -> MCN-ACCOUNT
MCN-SUB-ACCOUNT -> MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR -> MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
Curr 2 MLCONSOL
MCN-OBJ-ID -> MCN-OBJ-ID
"Z" -> MCN-TRANS-TYPE
MCN-LEDGER -> MCN-LEDGER
MCN-COMPANY -> MCN-COMPANY
MCN-VAR-LEVELS -> MCN-VAR-LEVELS
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-OBJ-ID -> MLA-PARENT-OBJ-ID
MCN-LEDGER -> MLA-LEDGER
MCN-COMPANY -> MLA-COMPANY
MLA-ACCT-UNIT
MLA-ACCOUNT
MLA-SUB-ACCOUNT
MLA-FISCAL-YEAR
Glnames GLNAMES Required
MCN-COMPANY -> GLN-COMPANY
MCN-VAR-LEVELS -> GLN-VAR-LEVELS
GLN-ACCT-UNIT
Parent MLCONSOL
MCN-PARENT-OBJ-ID -> MCN-OBJ-ID
MCN-TRANS-TYPE -> MCN-TRANS-TYPE
MCN-LEDGER -> MCN-LEDGER
MCN-COMPANY -> MCN-COMPANY
MCN-VAR-LEVELS
MCN-ACCOUNT
MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
|
