Lawson Insight Technical Documentation

                              GLSYSJE FILE

                        GL Company Journal Entry

This file contains information about the last journal entry number used for a
specific system code.


REFERENCED BY

GL210

UPDATED BY

GL110     GL191     GL196     GL197     GL199     GL40.2
GL40.6    GL45.1    GL500     IFGT.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GSJ-COMPANY            Numeric 4                                 GL110   GL191
Element: Company       The company number as defined in GL10.1   GL196   GL197
                       (Company).                                GL199   GL40.2
                                                                 GL40.6  GL45.1
                                                                 GL500   IFGT.1

GSJ-SYSTEM             Alpha 2                                   GL191   GL196
Element: System Code   A two-character code representing an      GL197   GL199
                       application used within the Lawson        GL40.2  GL40.6
                       system. (i.e.: GL = General Ledger, AP =  GL45.1  GL500
                       Accounts Payable, etc.)                   IFGT.1

GSJ-FISCAL-YEAR        Numeric 4                                 GL191   GL196
Element: Fiscal Year   This is the current fiscal year.  This    GL197   GL199
                       field is updated by Period Closing        GL40.2  GL40.6
                       (GL199).                                  GL45.1  GL500
                                                                 IFGT.1

GSJ-ACCT-PERIOD        Numeric 2                                 GL191   GL196
Element: Accounting Period                                       GL197   GL199
                                                                 GL40.2  GL40.6
                                                                 GL45.1  GL500
                                                                 IFGT.1

GSJ-LAST-JE-USED       Numeric 8                                 GL191   GL196
Last Journal Entry     The last journal entry number.            GL197   GL199
Number                                                           GL40.2  GL40.6
                                                                 GL45.1  GL500
                                                                 IFGT.1

GSJ-LST-IC-JE-NBR      Numeric 4                                 GL40.2  GL40.6
Last IC Journal        The last IC journal entry number.         GL45.1  GL500
Entry Number                                                     IFGT.1

                         GLSYSJE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GSJSET1   COMPANY                                                GL110   GL191
          SYSTEM                                                 GL196   GL197
          FISCAL-YEAR                                            GL199   GL40.2
          ACCT-PERIOD                                            GL40.6  GL45.1
                                                                 GL500   GL210
                                                                 IFGT.1

GSJSET2   SYSTEM
          COMPANY
          FISCAL-YEAR
          ACCT-PERIOD

                         GLSYSJE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcodes        GLCODES      Not Required

                            GSJ-COMPANY    -> GCD-COMPANY  (GCDSET4)
                            GSJ-SYSTEM     -> GCD-SYSTEM

Glsystem       GLSYSTEM     Required

                            GSJ-COMPANY    -> GLS-COMPANY

Systemcode     SYSTEMCODE   Not Required

                            GSJ-SYSTEM     -> SYS-SYSTEM