Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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     GL199     GL40.2    GL40.6
GL45.1    GL500     IFGT.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

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