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    AM180     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    IC222     GLAV.1    GLCV.1    GLVW.1    IFAC.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

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: Account PeriodThis 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: Last Closed YeThis 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: Last Closed YeThis field contains the last closed
                       fiscal year.

MLE-ACTIVE-STATUS      Alpha 1
Element: 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 Type the currency code you want to
                       associate with the report currency name.

                       The currency code must exist in CU01.1
                       (Currency Codes).



MLE-CURR-CODE-2        Alpha 5
Element: Currency Code Type the currency code you want to
                       associate with the report currency name.

                       The currency code must exist in CU01.1
                       (Currency Codes).



                         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  AM180
                                                                 BR44.1  CA10.5
                                                                 CA110   FB100
                                                                 FB20.1  FB20.6
                                                                 FB20.7  FB21.1
                                                                 GL110   GL120
                                                                 GL165   GL310
                                                                 GL500   GL65.1
                                                                 RW100   RW230
                                                                 ...

MLESET2   LEDGER                                                 AC121   AC123
          COMPANY                                                AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC37.1
                                                                 AC490   ACVW.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  FB95.4
                                                                 ...

                         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