|
|
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
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.
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.
MCN-LEDGER Alpha 15
Element: Ledger The ledger associated with the
transaction record.
MCN-COMPANY Numeric 4
Element: Company The company associated to the ledger.
MCN-VAR-LEVELS Alpha 30
Element: New Levels The variable level address of the
summary accounting unit associated with
this record.
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 Currency 15.2
Element: Amount The debit beginning balance in base
currency
MCN-CR-BEG-BAL Currency 15.2
Element: Amount The credit beginning balance in base
currency
MCN-DB-AMOUNT Currency 15.2 Occurs 13 Times
Element: Amount The debit amount.
MCN-CR-AMOUNT Currency 15.2 Occurs 13 Times
Element: 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
Element: Name User 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-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
Object This is the parent object identifier.
Identification 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 KeyChange
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
|
