Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MLUNITS


                              MLUNITS FILE

                                ML Units

The Multi Book Ledger Units file contains debit and credit unit balance
information including the ledger, company, fiscal year, accounting unit, and
account records.

REFERENCED BY

RW80.1    MLRV.1

UPDATED BY

GL120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

MLU-COMPANY            Numeric 4
Element: Company       This is the company the ledger is
                       linked to
                       .~$3 MLUNITS   FISCAL-YEAR
                       This is the fiscal year the unit
                       amounts are posted to.

MLU-FISCAL-YEAR        Numeric 4
Element: Year          Contains the fiscal year for the data
                       stored on this record.


MLU-ACCT-UNIT          Alpha 15
Element: Acct Unit     This is the accounting unit with which
                       unit amounts are associated.

MLU-ACCOUNT            Numeric 6
Element: Account       This is the account with which unit
                       amounts are associated.

MLU-SUB-ACCOUNT        Numeric 4
Element: Sub Acct      This is the subaccount with which unit
                       amounts are associated.

MLU-VAR-LEVELS         Alpha 30                                  GL120
Element: Var Levels    This is the variable level with which
                       unit amounts are associated. A level
                       represents the location of an accounting
                       unit in an organization's level
                       structure.

MLU-CHART-NAME         Alpha 12
Element: Chart Name    This is the chart of account with which
                       the company is associated.

MLU-DB-BEG-BAL         Signed 18.2
Element: Intl Amt      The debit unit beginning balance.

MLU-CR-BEG-BAL         Signed 18.2
Element: Intl Amt      The credit unit beginning balance.

MLU-DB-UNITS           Signed 15.2 Occurs 13 Times
Element: Auto Debits   The debit unit amount.

MLU-CR-UNITS           Signed 15.2 Occurs 13 Times
Element: Auto Credits  The credit unit amount.

MLU-ACTIVITY-FLAG      Alpha 1 Occurs 13 Times
Element: Activity Flag When activity for this period has
                       occurred a "Y" will be inserted.  Not
                       required.

MLU-MAINT-DATE         Numeric 8  (yyyymmdd)                     GL120
Element: Maint Date    The date the unit record was last
                       changed.

MLU-MAINT-TIME         Numeric 6  (hhmmss)                       GL120
Element: Sys Time      The time the unit record was last
                       changed.

MLU-CYBUNT             Derived
Element: Cybunt        The current year beginning unit balance.

MLU-CPUNT-DR           Derived
Element: Cpunt Dr      The current period debit unit amount.

MLU-CPUNT-CR           Derived
Element: Cpunt Cr      The current period credit unit amount.

MLU-CPUNT              Derived
Element: Cpunt         The current period net unit amount.

MLU-CUR-PD-SUM-U-D     Derived
Element: Cur Pd Sum U DThe current period summary debit units.

MLU-CUR-PD-SUM-U-C     Derived
Element: Cur Pd Sum U CThe current period summary credit units.

MLU-CYDUNT             Derived
Element: Cydunt        The current year-to-date units.

MLU-CYPUNT1-DR         Derived
Element: Cypunt1 Dr    The current year period 1 debit unit
                       amount.

MLU-CYPUNT2-DR         Derived
Element: Cypunt2 Dr    The current year period 2 debit unit
                       amount.

MLU-CYPUNT3-DR         Derived
Element: Cypunt3 Dr    The current year period 3 debit unit
                       amount.

MLU-CYPUNT4-DR         Derived
Element: Cypunt4 Dr    The current year period 4 debit unit
                       amount.

MLU-CYPUNT5-DR         Derived
Element: Cypunt5 Dr    The current year period 5 debit unit
                       amount.

MLU-CYPUNT6-DR         Derived
Element: Cypunt6 Dr    The current year period 6 debit unit
                       amount.

MLU-CYPUNT7-DR         Derived
Element: Cypunt7 Dr    The current year period 7 debit unit
                       amount.

MLU-CYPUNT8-DR         Derived
Element: Cypunt8 Dr    The current year period 8 debit unit
                       amount.

MLU-CYPUNT9-DR         Derived
Element: Cypunt9 Dr    The current year period 9 debit unit
                       amount.

MLU-CYPUNT10-DR        Derived
Element: Cypunt10 Dr   The current year period 10 debit unit
                       amount.

MLU-CYPUNT11-DR        Derived
Element: Cypunt11 Dr   The current year period 11 debit unit
                       amount.

MLU-CYPUNT12-DR        Derived
Element: Cypunt12 Dr   The current year period 12 debit unit
                       amount.

MLU-CYPUNT13-DR        Derived
Element: Cypunt13 Dr   The current year period 13 debit unit
                       amount.

MLU-CYPUNT1-CR         Derived
Element: Cypunt1 Cr    The current year period 1 credit unit
                       amount.

MLU-CYPUNT2-CR         Derived
Element: Cypunt2 Cr    The current year period 2 credit unit
                       amount.

MLU-CYPUNT3-CR         Derived
Element: Cypunt3 Cr    The current year period 3 credit unit
                       amount.

MLU-CYPUNT4-CR         Derived
Element: Cypunt4 Cr    The current year period 4 credit unit
                       amount.

MLU-CYPUNT5-CR         Derived
Element: Cypunt5 Cr    The current year period 5 credit unit
                       amount.

MLU-CYPUNT6-CR         Derived
Element: Cypunt6 Cr    The current year period 6 credit unit
                       amount.

MLU-CYPUNT7-CR         Derived
Element: Cypunt7 Cr    The current year period 7 credit unit
                       amount.

MLU-CYPUNT8-CR         Derived
Element: Cypunt8 Cr    The current year period 8 credit unit
                       amount.

MLU-CYPUNT9-CR         Derived
Element: Cypunt9 Cr    The current year period 9 credit unit
                       amount.

MLU-CYPUNT10-CR        Derived
Element: Cypunt10 Cr   The current year period 10 credit unit
                       amount.

MLU-CYPUNT11-CR        Derived
Element: Cypunt11 Cr   The current year period 11 credit unit
                       amount.

MLU-CYPUNT12-CR        Derived
Element: Cypunt12 Cr   The current year period 12 credit unit
                       amount.

MLU-CYPUNT13-CR        Derived
Element: Cypunt13 Cr   The current year period 13 credit unit
                       amount.

MLU-CYPUNT1            Derived
Element: Cypunt1       The current year period 1 net unit
                       amount.

MLU-CYPUNT2            Derived
Element: Cypunt2       The current year period 2 net unit
                       amount.

MLU-CYPUNT3            Derived
Element: Cypunt3       The current year period 3 net unit
                       amount.

MLU-CYPUNT4            Derived
Element: Cypunt4       The current year period 4 net unit
                       amount.

MLU-CYPUNT5            Derived
Element: Cypunt5       The current year period 5 net unit
                       amount.

MLU-CYPUNT6            Derived
Element: Cypunt6       The current year period 6 net unit
                       amount.

MLU-CYPUNT7            Derived
Element: Cypunt7       The current year period 7 net unit
                       amount.

MLU-CYPUNT8            Derived
Element: Cypunt8       The current year period 8 net unit
                       amount.

MLU-CYPUNT9            Derived
Element: Cypunt9       The current year period 9 net unit
                       amount.

MLU-CYPUNT10           Derived
Element: Cypunt10      The current year period 10 net unit
                       amount.

MLU-CYPUNT11           Derived
Element: Cypunt11      The current year period 11 net unit
                       amount.

MLU-CYPUNT12           Derived
Element: Cypunt12      The current year period 12 net unit
                       amount.

MLU-CYPUNT13           Derived
Element: Cypunt13      The current year period 13 net unit
                       amount.

MLU-CYPYTD1            Derived
Element: Cypunt1       Current year period year to date
                       period 1.

MLU-CYPYTD2            Derived
Element: Cypunt2       Current year period year to date
                       period 2.

MLU-CYPYTD3            Derived
Element: Cypunt3       Current year period year to date
                       period 3.

MLU-CYPYTD4            Derived
Element: Cypunt4       Current year period year to date
                       period 4.

MLU-CYPYTD5            Derived
Element: Cypunt5       Current year period year to date
                       period 5.

MLU-CYPYTD6            Derived
Element: Cypunt6       Current year period year to date
                       period 6.

MLU-CYPYTD7            Derived
Element: Cypunt7       Current year period year to date
                       period 7.

MLU-CYPYTD8            Derived
Element: Cypunt8       Current year period year to date
                       period 8.

MLU-CYPYTD9            Derived
Element: Cypunt9       Current year period year to date
                       period 9.

MLU-CYPYTD10           Derived
Element: Cypunt10      Current year period year to date
                       period 10.

MLU-CYPYTD11           Derived
Element: Cypunt11      Current year period year to date
                       period 11.

MLU-CYPYTD12           Derived
Element: Cypunt12      Current year period year to date
                       period 12.

MLU-CYPYTD13           Derived
Element: Cypunt13      Current year period year to date
                       period 13.

MLU-BLANKAM            Derived
Element: Blankam       This field consists of blank spaces.
                       It is used to provide column headings on
                       drill arounds.


MLU-PARENT-VAR-LEV     Alpha 30                                  GL120
Element: Parent Var LevThe variable level address of the parent
                       accounting unit.

                         MLUNITS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

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

MLUSET3   LEDGER        KeyChange
          COMPANY
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT
          FISCAL-YEAR

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

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

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

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

                         MLUNITS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Au        GLMASTER     Required

                            MLU-COMPANY           -> GLM-COMPANY  (GLMSET2)
                            MLU-ACCT-UNIT         -> GLM-ACCT-UNIT
                            MLU-ACCOUNT           -> GLM-ACCOUNT
                            MLU-SUB-ACCOUNT       -> GLM-SUB-ACCOUNT

Chart Detail   GLCHARTDTL   Required

                            MLU-CHART-NAME        -> GDT-CHART-NAME
                            MLU-ACCOUNT           -> GDT-ACCOUNT
                            MLU-SUB-ACCOUNT       -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            MLU-COMPANY           -> GLS-COMPANY

Mlledger       MLLEDGER     Required

                            MLU-LEDGER            -> MLL-LEDGER

                         MLUNITS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Annual Units   MLUNITS

                            MLU-LEDGER            -> MLU-LEDGER
                            MLU-COMPANY           -> MLU-COMPANY
                            MLU-ACCOUNT           -> MLU-ACCOUNT
                            MLU-SUB-ACCOUNT       -> MLU-SUB-ACCOUNT
                            MLU-VAR-LEVELS        -> MLU-VAR-LEVELS
                            MLU-ACCT-UNIT         -> MLU-ACCT-UNIT
                                                     MLU-FISCAL-YEAR

Mlunit Parent  MLCONSOL

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