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.

Field / column	Type	Description & values	Updated by
`GJL-COMPANY` PK COMPANY	Numeric 4	Identifies 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 4	Contains 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 2	This 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 2	A 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 1	The 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 8	This 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 2	The assigned sequence number.	GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
`GJL-LINE-NBR` PK LINE_NBR	Numeric 6	This 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 6	The journal entry log sequence number.	GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
`GJL-ERROR-CAT` ERROR_CAT	Alpha 5	The journal entry error category.	GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
`GJL-MSG-NBR` MSG_NBR	Numeric 3	The journal entry message number.	GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
`GJL-ERR-INF-FLAG` ERR_INF_FLAG	Alpha 1	Indicates a journal entry error.	GL190, GL500, IFGT.1
`GJL-PROGRAM` PROGRAM	Alpha 5	This field designates the program this record was created by.	GL146, GL148, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
`GJL-RUN-DATE` 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` 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` 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`GJLSET1`	`COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`, `LINE-NBR`, `LOG-SEQ-NBR`	Primary		GL110, GL145, GL146, GL190, GL191, GL196, GL197, GL40.1 +12 more
`GJLSET2`	`COMPANY`, `RUN-DATE`, `RUN-TIME`, `PROGRAM`, `FISCAL-YEAR`, `ACCT-PERIOD`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`, `LINE-NBR`, `LOG-SEQ-NBR`	KeyChange		GL42.1
`GJLSET3`	`RUN-DATE`, `RUN-TIME`, `JOBNAME`, `PROGRAM`, `COMPANY`, `FISCAL-YEAR`, `ACCT-PERIOD`, `SYSTEM`, `JE-TYPE`, `CONTROL-GROUP`, `JE-SEQUENCE`, `LOG-SEQ-NBR`	KeyChange, Subset	Where (LINE-NBR = Zeroes) And (LOG-SEQ-NBR = 1)	IFJR.1

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (19)

GL110 Company Copy Delete
GL146 Batch Journal Control
GL148 Zone Rebalancing
GL190 Journal Posting
GL191 Currency Revaluation
GL196 Report Currency Translation
GL197 Period, Year End GL Commitments Processing
GL199 Period Closing
GL342 Journal Entry Log Mass Delete
GL40.1 Journal Entry
GL40.2 Define Journal
GL40.3 Speed Entry
GL40.6 Journal Copy
GL40.7 Totals
GL40.8 Journal Entry
GL44.1 Report Currency Entry
GL45.1 Journal Control
GL500 Fiscal Year Change
IFGT.1 GLTRANS Interface

Referenced by (3)

GL145 Journal Entry Hold Release
GL42.1 Journal Entry Log
IFJR.1 Interface JE Report