Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLUNITS


                              GLUNITS FILE

                          General Ledger Units

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


REFERENCED BY

CA290     FB120     FB20.1    FB20.3    FB20.4    FB20.6
FB20.7    GL141     GL281     GL290     GL291     GL90.1
GL90.4    GLOP.1    GL195     GLSV.1    RW80.1    GLRV.1
GL122     GL20.2    GL295     GL320

UPDATED BY

CA110     GL110     GL120     GL146     GL167     GL190
GL197     GL199     GL300     GL325     GL330     GL40.1
GL40.2    GL40.3    GL40.7    GL40.8    GL44.1    GL45.1
GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLU-COMPANY            Numeric 4                                 CA110   GL110
Element: Company       The company number represents an          GL146   GL167
                       established company and is entered on     GL190   GL197
                       all function codes.                       GL199   GL325
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

GLU-FISCAL-YEAR        Numeric 4                                 CA110   GL146
Element: Fiscal Year   This is the current fiscal year.  This    GL167   GL190
                       field is updated by Period Closing        GL197   GL199
                       (GL199).                                  GL325   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GLU-ACCT-UNIT          Alpha 15                                  CA110   GL146
Element: Accounting UniThe accounting unit is a shorthand        GL167   GL190
                       notation representing the variable level  GL197   GL199
                       number. When used in the General Ledger   GL325   GL330
                       Account Master file, the accounting unit  GL40.1  GL40.2
                       must be defined in the General Ledger     GL40.3  GL40.7
                       Names file as a posting accounting unit.  GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GLU-ACCOUNT            Numeric 6                                 CA110   GL146
Element: Account       This field along with the accounting      GL167   GL190
                       unit and subaccount make up the location  GL197   GL199
                       (account) where amounts and other         GL325   GL330
                       account information is stored.            GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GLU-SUB-ACCOUNT        Numeric 4                                 CA110   GL146
Element: Subaccount    This field along with the accounting      GL167   GL190
                       unit and account make up the location     GL197   GL199
                       (account) where amounts and other         GL325   GL330
                       account information is stored.            GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GLU-VAR-LEVELS         Alpha 30                                  CA110   GL120
Element: Variable Levels                                         GL146   GL167
                                                                 GL190   GL197
                                                                 GL199   GL325
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   GLSV.1

GLU-CHART-NAME         Alpha 12                                  CA110   GL146
Element: Chart Name    The name assigned to the chart of         GL167   GL190
                       accounts when you defined your company    GL197   GL199
                       structure in the Lawson General Ledger    GL325   GL330
                       system.                                   GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GLU-DB-BEG-BAL         Currency 15.2                             FB20.7  GL110
Debit Beginning                                                  GL167   GL199
Balance                                                          GL281   GL291
                                                                 GL325   GL500
                                                                 GLSV.1

GLU-CR-BEG-BAL         Currency 15.2                             FB20.7  GL110
Credit Beginning                                                 GL167   GL199
Balance                                                          GL281   GL291
                                                                 GL325   GL500
                                                                 GLSV.1

GLU-DB-UNITS           Signed 15.2 Occurs 13 Times               FB20.7  GL110
Element: Debit Units   The debit units.                          GL146   GL167
                                                                 GL190   GL197
                                                                 GL281   GL291
                                                                 GL325   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GLU-CR-UNITS           Signed 15.2 Occurs 13 Times               FB20.7  GL110
Element: Credit Units  The credit units.                         GL146   GL167
                                                                 GL190   GL197
                                                                 GL281   GL291
                                                                 GL325   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLSV.1

GLU-ACTIVITY-FLAG      Alpha 1 Occurs 13 Times                   GL146   GL167
Element: Activity Flag Not required.                             GL190   GL197
                       When activity for this period has         GL325   GL40.1
                       occurred, a "Y" will be inserted.         GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                       Y = Yes                                   GL44.1  GL45.1
                       N = No                                    GL500
                       " " = No

GLU-MAINT-DATE         Numeric 8  (yyyymmdd)                     GL120   GL146
Element: Date                                                    GL167   GL190
                                                                 GL197   GL199
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

GLU-MAINT-TIME         Numeric 6  (hhmmss)                       GL120   GL146
Element: Sys Time                                                GL167   GL190
                                                                 GL197   GL199
                                                                 GL330   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

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


GLU-CPUNT-DR           Derived
Current Period Unit    The debit unit amount.
Debit

GLU-CPUNT-CR           Derived
Current Period Unit    The credit unit amount.
Credit

GLU-CPUNT              Derived
Element: Current PeriodThe total unit amount.

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

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

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

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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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

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

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

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

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

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

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

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

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

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


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


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


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


GLU-BLANKAM            Derived
Element: Blank         This field consists of blank spaces. It
                       is used to provide column headings on
                       Drill Arounds.


                         GLUNITS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLUSET1   COMPANY                                                CA110   CA290
          FISCAL-YEAR                                            FB120   FB20.1
          ACCT-UNIT                                              FB20.3  FB20.4
          ACCOUNT                                                FB20.6  FB20.7
          SUB-ACCOUNT                                            GL110   GL120
                                                                 GL141   GL146
                                                                 GL167   GL190
                                                                 GL197   GL199
                                                                 GL281   GL290
                                                                 GL291   GL300
                                                                 GL325   GL330
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 ...

GLUSET2   FISCAL-YEAR   KeyChange                                FB120   GL195
          COMPANY                                                GL281   GL291
          VAR-LEVELS                                             GL325   GLSV.1
          ACCOUNT                                                RW80.1  GLOP.1
          SUB-ACCOUNT                                            GLRV.1
          ACCT-UNIT

GLUSET3   COMPANY       KeyChange                                GL122   GL500
          ACCOUNT                                                GL20.2
          SUB-ACCOUNT
          VAR-LEVELS
          ACCT-UNIT
          FISCAL-YEAR

GLUSET4   FISCAL-YEAR   KeyChange                                GLSV.1  GLRV.1
          VAR-LEVELS
          ACCOUNT
          SUB-ACCOUNT
          COMPANY
          ACCT-UNIT

GLUSET5   FISCAL-YEAR   KeyChange                                GLSV.1  GLRV.1
          ACCOUNT
          SUB-ACCOUNT
          VAR-LEVELS
          COMPANY
          ACCT-UNIT

GLUSET6   FISCAL-YEAR   KeyChange                                GL199   GL290
          COMPANY                                                GL295   GL320
          ACCOUNT                                                GL325   GL330
          SUB-ACCOUNT                                            GLSV.1  GLRV.1
          VAR-LEVELS
          ACCT-UNIT

GLUSET8   MAINT-DATE    KeyChange                                GLOP.1
          MAINT-TIME
          COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          FISCAL-YEAR

                         GLUNITS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Au        GLMASTER     Required

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

Chart Detail   GLCHARTDTL   Required

                            GLU-CHART-NAME     -> GDT-CHART-NAME
                            GLU-ACCOUNT        -> GDT-ACCOUNT
                            GLU-SUB-ACCOUNT    -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            GLU-COMPANY        -> GLS-COMPANY