Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLSYSJE


                              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     GL148     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   GL148
Element: Company       The company number as defined in GL10.1   GL191   GL196
                       (Company).                                GL197   GL199
                                                                 GL40.2  GL40.6
                                                                 GL45.1  GL500
                                                                 IFGT.1

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

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

GSJ-ACCT-PERIOD        Numeric 2                                 GL148   GL191
Element: Accounting PerThis is the current accounting period.    GL196   GL197
                       This field is updated by GL199 (Period    GL199   GL40.2
                       Closing).                                 GL40.6  GL45.1
                                                                 GL500   IFGT.1

GSJ-LAST-JE-USED       Numeric 8                                 GL148   GL191
Last Journal Entry     The last journal entry number.            GL196   GL197
Number                                                           GL199   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   GL148
          SYSTEM                                                 GL191   GL196
          FISCAL-YEAR                                            GL197   GL199
          ACCT-PERIOD                                            GL40.2  GL40.6
                                                                 GL45.1  GL500
                                                                 GL210   IFGT.1

                         GLSYSJE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcodes        GLCODES      Not Required

                            GSJ-COMPANY    -> GCD-COMPANY
                            GSJ-SYSTEM     -> GCD-SYSTEM

Glsystem       GLSYSTEM     Required

                            GSJ-COMPANY    -> GLS-COMPANY

Systemcode     SYSTEMCODE   Not Required

                            GSJ-SYSTEM     -> SYS-SYSTEM