GLSYSJE – GL Company Journal Entry

System: General Ledger Setup (IF)
Prefix: GSJ
Primary key: COMPANY, SYSTEM, FISCAL-YEAR, ACCT-PERIOD
Fields: 6
Updated by: 11 programs
Referenced by: 1 program

GLSYSJE is the GL Company Journal Entry table in Lawson General Ledger Setup (prefix GSJ). It is indexed by COMPANY, SYSTEM, FISCAL-YEAR, ACCT-PERIOD (GSJSET1). It is related 1:1 to GLCODES, GLSYSTEM and SYSTEMCODE. It is updated by GL110, GL148, GL191, GL196, GL197, GL199, GL40.2, GL40.6 and 3 more and referenced by GL210. The table has 6 fields, 1 index and 3 documented relations.

About GLSYSJE

This file contains information about the last journal entry number used for a specific system code.

Fields (6)

Column = COBOL field name without the GSJ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`GSJ-COMPANY` PK COMPANY	Numeric 4	The company number as defined in GL10.1 (Company).	GL110, GL148, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +3 more
`GSJ-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.)	GL148, GL191, GL196, GL197, GL199, GL40.2, GL40.6, GL45.1 +2 more
`GSJ-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	Contains the fiscal year for the data stored on this record.	GL148, GL191, GL196, GL197, GL199, GL40.2, GL40.6, GL45.1 +2 more
`GSJ-ACCT-PERIOD` PK ACCT_PERIOD	Numeric 2	This is the current accounting period. This field is updated by GL199 (Period Closing).	GL148, GL191, GL196, GL197, GL199, GL40.2, GL40.6, GL45.1 +2 more
`GSJ-LAST-JE-USED` LAST_JE_USED	Numeric 8	The last journal entry number.	GL148, GL191, GL196, GL197, GL199, GL40.2, GL40.6, GL45.1 +2 more
`GSJ-LST-IC-JE-NBR` LST_IC_JE_NBR	Numeric 4	The last IC journal entry number.	GL40.2, GL40.6, GL45.1, GL500, IFGT.1

Indexes (1)

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
`GSJSET1`	`COMPANY`, `SYSTEM`, `FISCAL-YEAR`, `ACCT-PERIOD`	Primary		GL110, GL148, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +4 more

Relations

One to one (3) — lookups and parents

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

Programs

Updated by (11)

GL110 Company Copy Delete
GL148 Zone Rebalancing
GL191 Currency Revaluation
GL196 Report Currency Translation
GL197 Period, Year End GL Commitments Processing
GL199 Period Closing
GL40.2 Define Journal
GL40.6 Journal Copy
GL45.1 Journal Control
GL500 Fiscal Year Change
IFGT.1 GLTRANS Interface

Referenced by (1)

GL210 Company Listing