Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MLCUCNTRL


                             MLCUCNTRL FILE

                       Ml Ledger Currency Control

The Multi Book Ledger Currency Control file (MLCUCNTRL)  stores transaction
currency amounts.

UPDATED BY

GL310

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MCC-LEDGER             Alpha 15
Element: Ledger        The ledger being posted to.

MCC-COMPANY            Numeric 4
Element: Company       The Multi Book Ledger company for which
                       you are posting transactions.

MCC-FISCAL-YEAR        Numeric 4
Element: Year          This is the current fiscal year.  This
                       field is updated by Ledger Period
                       Closing (ML199).

MCC-ACCT-PERIOD        Numeric 2
Element: Acct Period   This is the current accounting period.
                       This field is updated by Ledger Period
                       Closing (ML199).

MCC-SYSTEM             Alpha 2
Element: System        A two-character code representing an
                       application used within the Lawson
                       system.  (for example,  GL = General
                       Ledger, AP = Accounts Payable, and so
                       on).

MCC-JE-TYPE            Alpha 1
Element: Je Type       The type of journal entry.  Valid
                       values are Normal and Intercompany.

MCC-CONTROL-GROUP      Numeric 8
Element: Control Group This field contains the journal entry
                       number used for process control of the
                       journal entry detail.

MCC-JE-SEQUENCE        Numeric 2
Element: Je Sequence   The journal entry sequence number.

MCC-CURRENCY-CODE      Alpha 5
Element: Currency Code The field containing the transaction
                       currency code.

MCC-AMT-TYPE           Numeric 1
Element: Amt Type      The amount type can be either Report
                       Currency One or Report Currency Two.

MCC-ENTRY-DB           Signed 18.2
Element: Intl Amt      Displays the total debit amount for the
                       journal entry in transaction currency.

MCC-ENTRY-CR           Signed 18.2
Element: Intl Amt      Displays the total credit amount for
                       the journal entry in transaction
                       currency.

MCC-AUTO-DB            Signed 18.2
Element: Intl Amt      This field will store the Auto Reverse
                       Total Debits for a Journal Entry for
                       Report Currency 1 and Report Currency 2.

MCC-AUTO-CR            Signed 18.2
Element: Intl Amt      This field will store the Auto Reverse
                       Total Credits for a Journal Entry for
                       Report Currency 1 and Report Currency 2.

                         MLCUCNTRL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MCCSET1   LEDGER                                                 GL310
          COMPANY
          FISCAL-YEAR
          ACCT-PERIOD
          SYSTEM
          JE-TYPE
          CONTROL-GROUP
          JE-SEQUENCE
          AMT-TYPE
          CURRENCY-CODE