GLJELOG – Journal Entry Log

System
General Ledger Setup (IF)
Prefix
GJL
Primary key
COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, LINE-NBR, LOG-SEQ-NBR
Fields
22
Updated by
19 programs
Referenced by
3 programs

GLJELOG is the Journal Entry Log table in Lawson General Ledger Setup (prefix GJL). It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, LINE-NBR, LOG-SEQ-NBR (GJLSET1); alternate indexes: GJLSET2 and GJLSET3. It is related 1:1 to GLCONTROL and GLTRANS. It is updated by GL110, GL146, GL148, GL190, GL191, GL196, GL197, GL199 and 11 more and referenced by GL145, GL42.1 and IFJR.1. The table has 22 fields, 3 indexes and 2 documented relations.

About GLJELOG

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

Fields (22)

Column = COBOL field name without the GJL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GJL-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.GL110, GL146, GL148, GL190, GL191, GL196, GL197, GL199 +10 more
#GJL-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-ACCT-PERIOD PK
ACCT_PERIOD		Numeric 2This is the current accounting period. This field is updated by GL199 (Period Closing).GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-JE-TYPE PK
JE_TYPE		Alpha 1The type of journal entry. Valid values are Normal and Intercompany.GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-CONTROL-GROUP PK
CONTROL_GROUP		Numeric 8This field displays the journal entry number used for process control of the journal entry detail.GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-JE-SEQUENCE PK
JE_SEQUENCE		Numeric 2The assigned sequence number.GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.GL146, GL148, GL191, GL196, GL197, GL199, GL40.1, GL40.2 +8 more
#GJL-LOG-SEQ-NBR PK
LOG_SEQ_NBR		Numeric 6The journal entry log sequence number.GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-ERROR-CAT
ERROR_CAT		Alpha 5The journal entry error category.GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-MSG-NBR
MSG_NBR		Numeric 3The journal entry message number.GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-ERR-INF-FLAG
ERR_INF_FLAG		Alpha 1Indicates a journal entry error.GL190, GL500, IFGT.1
#GJL-PROGRAM SET2 SET3
PROGRAM		Alpha 5This field designates the program this record was created by.GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-RUN-DATE SET2 SET3
RUN_DATE		Numeric 8 (yyyymmdd)The date a transaction is posted to general ledger.GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-RUN-TIME SET2 SET3
RUN_TIME		Numeric 6 (hhmmss)—GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
#GJL-ERR-VAR1
ERR_VAR1		Alpha 20—IFGT.1
#GJL-ERR-VAR2
ERR_VAR2		Alpha 20—IFGT.1
#GJL-ERR-VAR3
ERR_VAR3		Alpha 20—IFGT.1
#GJL-ERR-VAR4
ERR_VAR4		Alpha 20—IFGT.1
#GJL-ERR-VAR5
ERR_VAR5		Alpha 20—IFGT.1
#GJL-JOBNAME SET3
JOBNAME		Alpha 10 (Lower Case)—IFGT.1
#GJL-OPERATOR
OPERATOR		Alpha 10 (Lower Case)—GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GJLSET1
  1. COMPANY
  2. FISCAL-YEAR
  3. ACCT-PERIOD
  4. SYSTEM
  5. JE-TYPE
  6. CONTROL-GROUP
  7. JE-SEQUENCE
  8. LINE-NBR
  9. LOG-SEQ-NBR
PrimaryGL110, GL145, GL146, GL190, GL191, GL196, GL197, GL40.1 +12 more
GJLSET2
  1. COMPANY
  2. RUN-DATE
  3. RUN-TIME
  4. PROGRAM
  5. FISCAL-YEAR
  6. ACCT-PERIOD
  7. SYSTEM
  8. JE-TYPE
  9. CONTROL-GROUP
  10. JE-SEQUENCE
  11. LINE-NBR
  12. LOG-SEQ-NBR
KeyChangeGL42.1
GJLSET3
  1. RUN-DATE
  2. RUN-TIME
  3. JOBNAME
  4. PROGRAM
  5. COMPANY
  6. FISCAL-YEAR
  7. ACCT-PERIOD
  8. SYSTEM
  9. JE-TYPE
  10. CONTROL-GROUP
  11. JE-SEQUENCE
  12. LOG-SEQ-NBR
KeyChange, SubsetWhere (LINE-NBR = Zeroes) And (LOG-SEQ-NBR = 1)IFJR.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLCONTROLGLTRANSGLJELOG

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GlcontrolGLCONTROLNot 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
GltransGLTRANSNot 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

Programs

Updated by (19)

Referenced by (3)