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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#GSJ-COMPANY PKCOMPANY | 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 PKSYSTEM | 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 PKFISCAL_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 PKACCT_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-USEDLAST_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-NBRLST_IC_JE_NBR | Numeric 4 | The last IC journal entry number. | GL40.2, GL40.6, GL45.1, GL500, IFGT.1 |
Indexes (1)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GSJSET1 |
| Primary | GL110, GL148, GL191, GL196, GL197, GL199, GL40.2, GL40.6 +4 more |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Glcodes | GLCODES | Not Required |
| |||||||
| Glsystem | GLSYSTEM | Required |
| |||||||
| Systemcode | SYSTEMCODE | Not Required |
|
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