Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MLCONSOL


                             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