Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             MLCUCNTRL FILE

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
Ledger               The ledger being posted to.

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

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

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

MCC-SYSTEM           Alpha 2
System Code          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
Journal Entry Type   The type of journal entry.  Valid
                     values are Normal and Intercompany.

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

MCC-JE-SEQUENCE      Numeric 2
Journal Entry        The journal entry sequence number.
Sequence Number

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

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

MCC-ENTRY-DB         Signed 15.2
Entry Debits         Displays the total debit amount for the
                     journal entry in transaction currency.

MCC-ENTRY-CR         Signed 15.2
Entry Credit         Displays the total credit amount for
                     the journal entry in transaction
                     currency.

                         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