Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLUNITSX


                             GLUNITSX FILE

                       General Ledger Units-Daily

The General Ledger Units - Daily file contains debit and credit unit balance
information by accounting unit, account, and subaccount for the date
specified.


REFERENCED BY

GLOP.1    GL243     GL43.1

UPDATED BY

GL110     GL120     GL146     GL167     GL190     GL197
GL326     GL40.1    GL40.2    GL40.3    GL40.7    GL40.8
GL44.1    GL45.1    GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GUX-COMPANY            Numeric 4                                 GL110   GL146
Element: Company       The Company field contains the company    GL167   GL190
                       number that is used in the Organization   GL197   GL326
                       dimension.                                GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

GUX-DATE               Numeric 8  (yyyymmdd)                     GL146   GL167
Element: Date          The Date field contains the system date   GL190   GL197
                       this was created. The Date format used    GL326   GL40.1
                       is YYYYMMDD.                              GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1

GUX-ACCT-UNIT          Alpha 15                                  GL146   GL167
Element: Accounting UniThe Accounting Unit field contains the    GL190   GL197
                       name of the accounting unit that is used  GL326   GL40.1
                       in the Organization dimension. If this    GL40.2  GL40.3
                       field is blank, all accounting units are  GL40.7  GL40.8
                       included as members in the dimension      GL44.1  GL45.1
                       outline. This name can contain up to 15
                       alphabetic characters.


GUX-ACCOUNT            Numeric 6                                 GL146   GL167
Element: Account       This field, along with the accounting     GL190   GL197
                       unit and subaccount, make up the          GL326   GL40.1
                       location (account) where units and other  GL40.2  GL40.3
                       account information are stored.           GL40.7  GL40.8
                                                                 GL44.1  GL45.1

GUX-SUB-ACCOUNT        Numeric 4                                 GL146   GL167
Element: Subaccount    This field along with the accounting      GL190   GL197
                       unit and subaccount make up the location  GL326   GL40.1
                       (account) where units and other account   GL40.2  GL40.3
                       information is stored.                    GL40.7  GL40.8
                                                                 GL44.1  GL45.1

GUX-VAR-LEVELS         Alpha 30                                  GL120   GL146
Element: New Levels                                              GL167   GL190
                                                                 GL197   GL326
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

GUX-CHART-NAME         Alpha 12                                  GL146   GL167
Element: Name User     The Chart of Accounts Name field          GL190   GL197
                       contains the name of the chart of         GL326   GL40.1
                       accounts that is used by the              GL40.2  GL40.3
                       Organization dimension. This name can     GL40.7  GL40.8
                       contain up to 12 alphabetic characters.   GL44.1  GL45.1


GUX-DB-UNITS           Signed 15.2                               GL110   GL146
Element: Auto Debits   The Debit Units field contains the        GL167   GL190
                       number of debit units.                    GL197   GL326
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

GUX-CR-UNITS           Signed 15.2                               GL110   GL146
Element: Auto Credits  The Credit Units field contains the       GL167   GL190
                       number of credit units.                   GL197   GL326
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1

GUX-FISCAL-YEAR        Numeric 4                                 GL146   GL167
Element: Last Closed YeThe Fiscal Year field contains the        GL190   GL197
                       numeric fiscal year. This field can       GL326   GL40.1
                       contain up to four numeric characters.    GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500

GUX-MAINT-DATE         Numeric 8  (yyyymmdd)                     GL120   GL146
Element: Date          The Maintenance Date field contains the   GL167   GL190
                       date that this file was last updated.     GL197   GL326
                       The date format used is YYYYMMDD.         GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

GUX-MAINT-TIME         Numeric 6  (hhmmss)                       GL120   GL146
Element: Sys Time      The Maintenance Time field contains the   GL167   GL190
                       time that this file was last updated.     GL197   GL326
                       The time format used is HHMMSS.           GL40.1  GL40.2
                                                                 GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500

                         GLUNITSX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GUXSET1   COMPANY                                                GL110   GL146
          DATE                                                   GL167   GL190
          ACCT-UNIT                                              GL197   GL326
          ACCOUNT                                                GL40.1  GL40.2
          SUB-ACCOUNT                                            GL40.3  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 GLOP.1

GUXSET2   MAINT-DATE    KeyChange                                GLOP.1
          MAINT-TIME
          COMPANY
          DATE
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT

GUXSET3   COMPANY       KeyChange                                GL110
          FISCAL-YEAR
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          DATE

GUXSET4   COMPANY                                                GL120   GL243
          ACCT-UNIT                                              GL43.1
          ACCOUNT
          SUB-ACCOUNT
          DATE