Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MLAMOUNTS


                             MLAMOUNTS FILE

                       Multi-Book Ledger Amounts

The Multi-Book Ledger Amounts-Period file contains beginning and period
account balances by accounting unit, account, and subaccount.

REFERENCED BY

RW80.1    MLRV.1

UPDATED BY

GL120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MLA-LEDGER             Alpha 15
Element: Ledger        The ledger associated with the balance
                       record.  The ledger must be defined in
                       ML10.

MLA-COMPANY            Numeric 4
Element: Company       The company into which transactions are
                       to be interfaced.

MLA-FISCAL-YEAR        Numeric 4
Element: Fiscal Year   The fiscal year for the transactions to
                       be interfaced. Defaults to the current
                       fiscal year.

MLA-VAR-LEVELS         Alpha 30                                  GL120
Element: Variable LevelA level that represents the location of
                       an accounting unit in an organization's
                       level structure.

MLA-ACCT-UNIT          Alpha 15
Element: Accounting UniThe short-hand notation representing
                       the variable level. It must defined in
                       the General Ledger as a posting
                       accounting unit.

MLA-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 are stored.

MLA-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 are stored.

MLA-CHART-NAME         Alpha 12
Element: Chart Name    The chart of accounts assigned to the
                       ledger

MLA-DB-BEG-BAL         Signed 18.2
Debit Beginning        The debit beginning balance.
Balance

MLA-CR-BEG-BAL         Signed 18.2
Credit Beginning       The credit beginning balance.
Balance

MLA-DB-AMOUNT          Signed 18.2 Occurs 13 Times
Element: Debit Amount  The debit amount.

MLA-CR-AMOUNT          Signed 18.2 Occurs 13 Times
Element: Credit Amount The credit amount.

MLA-ACTIVITY-FLAG      Alpha 1 Occurs 13 Times
Element: Activity Flag The field indicates whether there was
                       activity to this account.

MLA-MAINT-DATE         Numeric 8  (yyyymmdd)                     GL120
Element: Maintenance DaThe date the record was last changed.

MLA-MAINT-TIME         Numeric 6  (hhmmss)                       GL120
Element: Maintenance TiThe time the record was last changed.

MLA-CPAMT-DR           Derived
Element: Current PeriodThe current period debit amount.

MLA-CPAMT-CR           Derived
Current Period         The current period credit amount.
Credit

MLA-CPAMT              Derived
Current Period         The total current period amount.
Amount

MLA-CYBAMT             Derived
Current Year           The current year beginning amount.
Beginning Amount

MLA-CUR-PD-SUM-DR      Derived
Current Per Summ       The current period summary debit amount.
Debit

MLA-CUR-PD-SUM-CR      Derived
Current Per Summ       The current period summary credit
Credit                 amount.

MLA-CUR-PD-SUM         Derived
Element: Current Per SuThe current period summary amount.

MLA-CYDAMT             Derived
Current Year to        The current year-to-date amount.
Date Amount

MLA-CYPAMT1-DR         Derived
Current Period 1       The current year period 1 debit amount
Debit Amount

MLA-CYPAMT1-CR         Derived
Current Period 1       The current year period 1 credit amount
Credit Amount

MLA-CYPAMT1            Derived
Current Period 1       The current year period 1 amount.
Amount

MLA-CYPYTD1            Derived
Curr Per 1 Year to     Current year period year to date
Date Amount            period 1.

MLA-CYPAMT2-DR         Derived
Current Period 2       The current year period 2 debit amount
Debit Amount

MLA-CYPAMT2-CR         Derived
Current Period 2       The current year period 2 credit amount
Credit Amount

MLA-CYPAMT2            Derived
Current Period 2       The current year period 2 amount.
Amount

MLA-CYPYTD2            Derived
Curr Per 2 Year to     Current year period year to date
Date Amount            period 2.

MLA-CYPAMT3-DR         Derived
Current Period 3       The current year period 3 debit amount
Debit Amount

MLA-CYPAMT3-CR         Derived
Current Period 3       The current year period 3 credit amount
Credit Amount

MLA-CYPAMT3            Derived
Current Period 3       The current year period 3 amount.
Amount

MLA-CYPYTD3            Derived
Curr Per 3 Year to     Current year period year to date
Date Amount            period 3.

MLA-CYPAMT4-DR         Derived
Current Period 4       The current year period 4 debit amount
Debit Amount

MLA-CYPAMT4-CR         Derived
Current Period 4       The current year period 4 credit amount
Credit Amount

MLA-CYPAMT4            Derived
Current Period 4       The current year period 4 amount.
Amount

MLA-CYPYTD4            Derived
Curr Per 4 Year to     Current year period year to date
Date Amount            period 4.

MLA-CYPAMT5-DR         Derived
Current Period 5       The current year period 5 debit amount
Debit Amount

MLA-CYPAMT5-CR         Derived
Current Period 5       The current year period 5 credit amount
Credit Amount

MLA-CYPAMT5            Derived
Current Period 5       The current year period 5 amount.
Amount

MLA-CYPYTD5            Derived
Curr Per 5 Year to     Current year period year to date
Date Amount            period 5.

MLA-CYPAMT6-DR         Derived
Current Period 6       The current year period 6 debit amount
Debit Amount

MLA-CYPAMT6-CR         Derived
Current Period 6       The current year period 6 credit amount
Credit Amount

MLA-CYPAMT6            Derived
Current Period 6       The current year period 6 amount.
Amount

MLA-CYPYTD6            Derived
Curr Per 6 Year to     Current year period year to date
Date Amount            period 6.

MLA-CYPAMT7-DR         Derived
Current Period 7       The current year period 7 debit amount
Debit Amount

MLA-CYPAMT7-CR         Derived
Current Period 7       The current year period 7 credit amount
Credit Amount

MLA-CYPAMT7            Derived
Current Period 7       The current year period 7 amount.
Amount

MLA-CYPYTD7            Derived
Curr Per 7 Year to     Current year period year to date
Date Amount            period 7.

MLA-CYPAMT8-DR         Derived
Current Period 8       The current year period 8 debit amount
Debit Amount

MLA-CYPAMT8-CR         Derived
Current Period 8       The current year period 8 credit amount
Credit Amount

MLA-CYPAMT8            Derived
Current Period 8       The current year period 8 amount.
Amount

MLA-CYPYTD8            Derived
Curr Per 8 Year to     Current year period year to date
Date Amount            period 8.

MLA-CYPAMT9-DR         Derived
Current Period 9       The current year period 9 debit amount
Debit Amount

MLA-CYPAMT9-CR         Derived
Current Period 9       The current year period 9 credit amount
Credit Amount

MLA-CYPAMT9            Derived
Current Period 9       The current year period 9 amount.
Amount

MLA-CYPYTD9            Derived
Curr Per 9 Year to     Current year period year to date
Date Amount            period 9.

MLA-CYPAMT10-DR        Derived
Current Period 10      The current year period 10 debit amount
Debit Amount

MLA-CYPAMT10-CR        Derived
Current Period 10      The current year period 10 credit amount
Credit Amt

MLA-CYPAMT10           Derived
Current Period 10      The current year period 10 amount.
Amount

MLA-CYPYTD10           Derived
Curr Per 10 Year to    Current year period year to date
Date Amt               period 10.

MLA-CYPAMT11-DR        Derived
Current Period 11      The current year period 11 debit amount
Debit Amount

MLA-CYPAMT11-CR        Derived
Current Period 11      The current year period 11 credit amount
Credit Amt

MLA-CYPAMT11           Derived
Current Period 11      The current year period 11 amount.
Amount

MLA-CYPYTD11           Derived
Curr Per 11 Year to    Current year period year to date
Date Amt               period 11.

MLA-CYPAMT12-DR        Derived
Cuurent Period 12      The current year period 12 debit amount
Debit Amount

MLA-CYPAMT12-CR        Derived
Current Period 12      The current year period 12 credit amount
Credit Amt

MLA-CYPAMT12           Derived
Current Period 12      The current year period 12 amount.
Amount

MLA-CYPYTD12           Derived
Curr Per 12 Year to    Current year period year to date
Date Amt               period 12.

MLA-CYPAMT13-DR        Derived
Current Period 13      The current year period 13 debit amount
Debit Amount

MLA-CYPAMT13-CR        Derived
Current Period 13      The current year period 13 credit amount
Credit Amt

MLA-CYPAMT13           Derived
Current Period 13      The current year period 13 amount.
Amount

MLA-CYPYTD13           Derived
Curr Per 13 Year to    Current year period year to date
Date Amt               period 13.

MLA-BLANK              Derived
Element: Blank         This derived field is always blank.  It
                       is used in the Drill Around feature for
                       column headings.
                       .~$3 MLAMOUNTS CPAMT-THOU

MLA-CPAMT-THOU         Derived
Current Period         The current period base amount divided
Thousands              by 1,000.


MLA-CYDAMT-THOU        Derived
Current Year to        The current period amount divided by
Date Thousands         1000.

MLA-PARENT-VAR-LEV     Alpha 30                                  GL120
Parent Variable        The variable level address of the parent
Level                  accounting unit.

                         MLAMOUNTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MLASET1   LEDGER
          COMPANY
          FISCAL-YEAR
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT

MLASET10  PARENT-VAR-LEV
          LEDGER
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR
          ACCT-UNIT

MLASET2   FISCAL-YEAR   KeyChange                                RW80.1  MLRV.1
          LEDGER
          COMPANY
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT

MLASET3   LEDGER                                                 GL120
          COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR

MLASET4   FISCAL-YEAR   KeyChange                                MLRV.1
          LEDGER
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT

MLASET5   FISCAL-YEAR   KeyChange                                MLRV.1
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          LEDGER
          COMPANY
          ACCT-UNIT

MLASET6   FISCAL-YEAR   KeyChange                                MLRV.1
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          LEDGER
          COMPANY
          ACCT-UNIT

MLASET7   LEDGER
          COMPANY
          FISCAL-YEAR
          ACCOUNT
          SUB-ACCOUNT
          ACCT-UNIT

                         MLAMOUNTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Chart Detail   GLCHARTDTL   Required

                            MLA-CHART-NAME        -> GDT-CHART-NAME  (GDTSET2)
                            MLA-ACCOUNT           -> GDT-ACCOUNT
                            MLA-SUB-ACCOUNT       -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            MLA-COMPANY           -> GLS-COMPANY

Glmaster       GLMASTER     Required

                            MLA-COMPANY           -> GLM-COMPANY
                            MLA-ACCT-UNIT         -> GLM-ACCT-UNIT
                            MLA-ACCOUNT           -> GLM-ACCOUNT
                            MLA-SUB-ACCOUNT       -> GLM-SUB-ACCOUNT

Mlcoledger     MLCOLEDGER   Required

                            MLA-LEDGER            -> MLE-LEDGER
                            MLA-COMPANY           -> MLE-COMPANY

                         MLAMOUNTS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Annual Amounts MLAMOUNTS

                            MLA-LEDGER            -> MLA-LEDGER
                            MLA-COMPANY           -> MLA-COMPANY
                            MLA-ACCT-UNIT         -> MLA-ACCT-UNIT
                            MLA-ACCOUNT           -> MLA-ACCOUNT
                            MLA-SUB-ACCOUNT       -> MLA-SUB-ACCOUNT
                                                     MLA-FISCAL-YEAR

Company Trans  MLTRANS

                            MLA-LEDGER            -> MLT-LEDGER
                            MLA-COMPANY           -> MLT-TO-COMPANY
                            MLA-FISCAL-YEAR       -> MLT-FISCAL-YEAR
                            MLE-ACCT-PERIOD       -> MLT-ACCT-PERIOD
                            MLA-ACCOUNT           -> MLT-ACCOUNT
                            MLA-SUB-ACCOUNT       -> MLT-SUB-ACCOUNT
                                                     MLT-ACCT-UNIT
                                                     MLT-OBJ-ID

Consol Parent  MLCONSOL

                            MLA-PARENT-VAR-LEV    -> MCN-VAR-LEVELS
                            "A"                   -> MCN-TRANS-TYPE
                            MLA-LEDGER            -> MCN-LEDGER
                            MLA-COMPANY           -> MCN-COMPANY
                            MLA-ACCOUNT           -> MCN-ACCOUNT
                            MLA-SUB-ACCOUNT       -> MCN-SUB-ACCOUNT
                            MLA-FISCAL-YEAR       -> MCN-FISCAL-YEAR
                                                     MCN-LEVEL-DEPTH
                                                     MCN-CURRENCY-CODE

Mca Curr 1     MLCUAMOUNT

                            MLA-PARENT-VAR-LEV    -> MCA-PARENT-VAR-LEV
                            3                     -> MCA-AMT-TYPE
                            MLA-LEDGER            -> MCA-LEDGER
                            MLA-COMPANY           -> MCA-COMPANY
                            MLA-ACCOUNT           -> MCA-ACCOUNT
                            MLA-SUB-ACCOUNT       -> MCA-SUB-ACCOUNT
                            MLA-FISCAL-YEAR       -> MCA-FISCAL-YEAR
                            MLA-ACCT-UNIT         -> MCA-ACCT-UNIT
                            MLA-VAR-LEVELS        -> MCA-VAR-LEVELS
                                                     MCA-CURRENCY-CODE

Mca Curr 2     MLCUAMOUNT

                            MLA-PARENT-VAR-LEV    -> MCA-PARENT-VAR-LEV
                            4                     -> MCA-AMT-TYPE
                            MLA-LEDGER            -> MCA-LEDGER
                            MLA-COMPANY           -> MCA-COMPANY
                            MLA-ACCOUNT           -> MCA-ACCOUNT
                            MLA-SUB-ACCOUNT       -> MCA-SUB-ACCOUNT
                            MLA-FISCAL-YEAR       -> MCA-FISCAL-YEAR
                            MLA-ACCT-UNIT         -> MCA-ACCT-UNIT
                            MLA-VAR-LEVELS        -> MCA-VAR-LEVELS
                                                     MCA-CURRENCY-CODE

Trans One Prd  MLTRANS

                            MLA-LEDGER            -> MLT-LEDGER
                            MLA-COMPANY           -> MLT-TO-COMPANY
                            MLA-FISCAL-YEAR       -> MLT-FISCAL-YEAR
                            MLE-ACCT-PERIOD       -> MLT-ACCT-PERIOD
                            MLA-ACCT-UNIT         -> MLT-ACCT-UNIT
                            MLA-ACCOUNT           -> MLT-ACCOUNT
                            MLA-SUB-ACCOUNT       -> MLT-SUB-ACCOUNT
                                                     MLT-OBJ-ID

Trans One Prds MLTRANS

                            MLA-LEDGER            -> MLT-LEDGER
                            MLA-COMPANY           -> MLT-TO-COMPANY
                            MLA-ACCOUNT           -> MLT-ACCOUNT
                            MLA-SUB-ACCOUNT       -> MLT-SUB-ACCOUNT
                            MLA-ACCT-UNIT         -> MLT-ACCT-UNIT
                            MLE-FISCAL-YEAR       -> MLT-FISCAL-YEAR
                                                     MLT-ACCT-PERIOD
                                                     MLT-OBJ-ID