Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

GLJELOG


                              GLJELOG FILE

                          GL Journal Entry Log

This file contains journal entry log information including the system code,
control group, and sequence number.


REFERENCED BY

GL145     GL42.1    IFJR.1

UPDATED BY

GL110     GL146     GL148     GL190     GL191     GL197
GL199     GL40.1    GL40.2    GL40.3    GL40.6    GL40.7
GL40.8    GL44.1    GL45.1    GL500     GL342     IFGT.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GJL-COMPANY            Numeric 4                                 GL110   GL146
Element: Company       Identifies the AP company if the          GL148   GL190
                       resource type = V.  Identifies the HR     GL191   GL197
                       company if the resource type = E.  It is  GL199   GL40.1
                       blank for type A, P or Q resources.       GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GJL-FISCAL-YEAR        Numeric 4                                 GL146   GL148
Element: Fiscal Year   This is the current fiscal year.  This    GL190   GL191
                       field is updated by Period Closing        GL197   GL199
                       (GL199).                                  GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GJL-ACCT-PERIOD        Numeric 2                                 GL146   GL148
Element: Accounting PerThis is the current accounting period.    GL190   GL191
                       This field is updated by GL199 (Period    GL197   GL199
                       Closing).                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

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

GJL-JE-TYPE            Alpha 1                                   GL146   GL148
Element: Journal Entry The type of journal entry. Valid values   GL190   GL191
                       are Normal and Intercompany.              GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GJL-CONTROL-GROUP      Numeric 8                                 GL146   GL148
Element: Control Group This field displays the journal entry     GL190   GL191
                       number used for process control of the    GL197   GL199
                       journal entry detail.                     GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GJL-JE-SEQUENCE        Numeric 2                                 GL146   GL148
Journal Entry          The assigned sequence number.             GL190   GL191
Sequence                                                         GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GJL-LINE-NBR           Numeric 6                                 GL146   GL148
Element: Line Number   This field contains the line number.      GL191   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL500
                                                                 IFGT.1

GJL-LOG-SEQ-NBR        Numeric 6                                 GL146   GL148
Element: Log Sequence NThe journal entry log sequence number.    GL190   GL191
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GJL-ERROR-CAT          Alpha 5                                   GL146   GL148
Element: Error CategoryThe journal entry error category.         GL190   GL191
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GJL-MSG-NBR            Numeric 3                                 GL146   GL148
Element: Message NumberThe journal entry message number.         GL190   GL191
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GJL-ERR-INF-FLAG       Alpha 1                                   GL190   GL500
Element: Error Flag    Indicates a journal entry error.          IFGT.1

GJL-PROGRAM            Alpha 5                                   GL146   GL148
Element: Program       This field designates the program this    GL190   GL191
                       record was created by.                    GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GJL-RUN-DATE           Numeric 8  (yyyymmdd)                     GL146   GL148
Element: Run Date      The date a transaction is posted to       GL190   GL191
                       general ledger.                           GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

GJL-RUN-TIME           Numeric 6  (hhmmss)                       GL146   GL148
Element: Run Time      Contains the time a transaction is        GL190   GL191
                       posted to the general ledger.             GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL500   IFGT.1

                         GLJELOG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GJLSET1   COMPANY                                                GL110   GL145
          FISCAL-YEAR                                            GL146   GL190
          ACCT-PERIOD                                            GL191   GL197
          SYSTEM                                                 GL40.1  GL40.2
          JE-TYPE                                                GL40.3  GL40.6
          CONTROL-GROUP                                          GL40.7  GL40.8
          JE-SEQUENCE                                            GL44.1  GL45.1
          LINE-NBR                                               GL500   GL342
          LOG-SEQ-NBR                                            GL42.1  IFGT.1
                                                                 IFJR.1

GJLSET2   COMPANY       KeyChange                                GL42.1
          RUN-DATE
          RUN-TIME
          PROGRAM
          FISCAL-YEAR
          ACCT-PERIOD
          SYSTEM
          JE-TYPE
          CONTROL-GROUP
          JE-SEQUENCE
          LINE-NBR
          LOG-SEQ-NBR

GJLSET3   RUN-DATE      KeyChange, Subset                        IFJR.1
          RUN-TIME      Where (LINE-NBR    = Zeroes )
          PROGRAM       And   (LOG-SEQ-NBR = 1 )
          COMPANY
          FISCAL-YEAR
          ACCT-PERIOD
          SYSTEM
          JE-TYPE
          CONTROL-GROUP
          JE-SEQUENCE
          LOG-SEQ-NBR

                         GLJELOG FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcontrol      GLCONTROL    Not Required

                            GJL-COMPANY          -> GLC-COMPANY
                            GJL-FISCAL-YEAR      -> GLC-FISCAL-YEAR
                            GJL-ACCT-PERIOD      -> GLC-ACCT-PERIOD
                            GJL-SYSTEM           -> GLC-SYSTEM
                            GJL-JE-TYPE          -> GLC-JE-TYPE
                            GJL-CONTROL-GROUP    -> GLC-CONTROL-GROUP
                            GJL-JE-SEQUENCE      -> GLC-JE-SEQUENCE

Gltrans        GLTRANS      Not Required

                            GJL-COMPANY          -> GLT-COMPANY
                            GJL-FISCAL-YEAR      -> GLT-FISCAL-YEAR
                            GJL-ACCT-PERIOD      -> GLT-ACCT-PERIOD
                            GJL-CONTROL-GROUP    -> GLT-CONTROL-GROUP
                            GJL-SYSTEM           -> GLT-SYSTEM
                            GJL-JE-TYPE          -> GLT-JE-TYPE
                            GJL-JE-SEQUENCE      -> GLT-JE-SEQUENCE
                            GJL-LINE-NBR         -> GLT-LINE-NBR