Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MLCOLEDGER


                            MLCOLEDGER FILE

                      Multi-Book Ledger Co Ledger

The Multi Book Ledger Company Ledger file stores information on the company
ledger combination, including the current period and fiscal year.

REFERENCED BY

AC121     AC123     AC130     AC191     AC20.1    AC20.2
AC20.3    AC20.4    AC20.5    AC32.1    AC37.1    AC490
ACVW.1    ATVW.1    AM180     AP125     AP126     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    API1.1
API2.1    BR44.1    CA10.5    CA110     FB100     FB20.1
FB20.6    FB20.7    FB21.1    GL110     GL120     GL165
GL310     GL65.1    RW100     RW230     RW30.1    RW80.1
GLAV.1    GLCV.1    GLVW.1    IFAC.1    MA41.1    MA41.2
MA41.4    MA41.7    MA43.2    MA61.1    MAI1.1    RQ10.1
RQ10.3    RQ11.1    RQ13.2    RQ35.1    RQ500     RQIB.1
RQIF.1    RQIJ.1    SLVW.1    FB11.1    FB111     FB160
FB211     FB296     FB60.1    FB95.1    FB95.2    FB95.3
FB95.4    FB95.5    FB95.6    GL298     GL90.6    GL94.1
GL94.2    GL94.3    GL94.4    GL94.5    GL94.6    GL94.7
GL95.1    GL95.2    GL95.3    GL95.4    GL95.5    GL95.6
GL95.7    GL95.8    GL95.9    GL96.1    GL96.2    GL96.3
GL96.4    GL96.5    GL97.1    GL97.2    GL97.3    GL97.4
GL97.5    GL97.6    GL97.7    GL97.8    GL97.9    GL98.1
GL98.2    GL98.3    GL98.4    GL98.5    GL99.1    GL99.2
GL99.3    GL99.4    GL99.5    GL99.6    RW270     RW70.1
SNOA.1    SNRA.1    SNSA.1

UPDATED BY

GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MLE-COMPANY            Numeric 4
Element: Company       This is the company to which the ledger
                       is linked to. One company can be
                       associated with multiple ledgers. One
                       ledger can be associated with multiple
                       companies. ML maintains separate records
                       for each unique company/ledger
                       combination.

MLE-NAME               Alpha 30  (Lower Case)
Element: Name          This is the company name.

MLE-LEDGER             Alpha 15
Element: Ledger        This is the ledger. The ledger must be
                       associated with the company on ML10. One
                       company can be associated with multiple
                       ledgers. One ledger can be associated
                       with multiple companies. ML maintains
                       separate records for each unique
                       company/ledger combination.

MLE-ACCT-PERIOD        Numeric 2                                 GL500
Element: Acct Period   This is the current accounting period
                       for the ledger/company combination.  It
                       is updated by the Ledger Period Closing
                       (ML199).

MLE-FISCAL-YEAR        Numeric 4                                 GL500
Element: Year          This is the current fiscal year for the
                       ledger/company combination.

MLE-UPDATING           Numeric 2
Element: Updating      This is set with a value when an update
                       program is running in GL.  The value
                       determines the program that is running.
                       No other updates may take place while
                       this field is not blank.

MLE-LST-YR-CLOSED      Numeric 4
Element: Year          This field contains the last closed
                       fiscal year.

MLE-ACTIVE-STATUS      Alpha 1
Element: Active Status This field contains the status of the
                       ledger. A ledger must be Active for
                       transactions to be posted to it.

MLE-CURRENCY-CODE      Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

MLE-CURR-CODE-1        Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

MLE-CURR-CODE-2        Alpha 5
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

                         MLCOLEDGER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MLESET1   COMPANY                                                AC121   AC123
          LEDGER                                                 AC130   AC191
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC32.1
                                                                 AC37.1  AC490
                                                                 ACVW.1  ATVW.1
                                                                 AM180   AP125
                                                                 AP126   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  API1.1
                                                                 ...

MLESET2   LEDGER                                                 AC121   AC123
          COMPANY                                                AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.1
                                                                 ATVW.1  AM180
                                                                 CA10.5  CA110
                                                                 FB100   FB11.1
                                                                 FB111   FB160
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 FB211   FB296
                                                                 FB60.1  FB95.1
                                                                 FB95.2  FB95.3
                                                                 ...

                         MLCOLEDGER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Coledger       GLSYSTEM     Required

                            MLE-COMPANY        -> GLS-COMPANY

Glsystem       GLSYSTEM     Required

                            MLE-COMPANY        -> GLS-COMPANY

Mlcalmap       MLCALMAP     Required

                            MLE-LEDGER         -> MCM-LEDGER
                            MLE-COMPANY        -> MCM-COMPANY
                            MLE-FISCAL-YEAR    -> MCM-FISCAL-YEAR