Lawson Insight Technical Documentation |
|
GLSYSJE
GLSYSJE FILE
GL Company Journal Entry
This file contains information about the last journal entry number used for a
specific system code.
REFERENCED BY
GL210
UPDATED BY
GL110 GL148 GL191 GL196 GL197 GL199
GL40.2 GL40.6 GL45.1 GL500 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GSJ-COMPANY Numeric 4 GL110 GL148
Element: Company The company number as defined in GL10.1 GL191 GL196
(Company). GL197 GL199
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GSJ-SYSTEM Alpha 2 GL148 GL191
Element: System Code A two-character code representing an GL196 GL197
application used within the Lawson GL199 GL40.2
system. (i.e.: GL = General Ledger, AP = GL40.6 GL45.1
Accounts Payable, etc.) GL500 IFGT.1
GSJ-FISCAL-YEAR Numeric 4 GL148 GL191
Element: Fiscal Year Contains the fiscal year for the data GL196 GL197
stored on this record. GL199 GL40.2
GL40.6 GL45.1
GL500 IFGT.1
GSJ-ACCT-PERIOD Numeric 2 GL148 GL191
Element: Accounting PerThis is the current accounting period. GL196 GL197
This field is updated by GL199 (Period GL199 GL40.2
Closing). GL40.6 GL45.1
GL500 IFGT.1
GSJ-LAST-JE-USED Numeric 8 GL148 GL191
Last Journal Entry The last journal entry number. GL196 GL197
Number GL199 GL40.2
GL40.6 GL45.1
GL500 IFGT.1
GSJ-LST-IC-JE-NBR Numeric 4 GL40.2 GL40.6
Last IC Journal The last IC journal entry number. GL45.1 GL500
Entry Number IFGT.1
GLSYSJE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GSJSET1 COMPANY GL110 GL148
SYSTEM GL191 GL196
FISCAL-YEAR GL197 GL199
ACCT-PERIOD GL40.2 GL40.6
GL45.1 GL500
GL210 IFGT.1
GLSYSJE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|