GLJELOG

GL Journal Entry Log

This file contains journal entry log information including the system code, control group, and sequence number.
UPDATED BY
GL110 GL146 GL148 GL190 GL191 GL196
GL197 GL199 GL40.1 GL40.2 GL40.3 GL40.6
GL40.7 GL40.8 GL44.1 GL45.1 GL500 GL342
IFGT.1 GL145 GL42.1 IFJR.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GJL-COMPANY
Element: 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
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
Contains the fiscal year for the data stored on this record.
GL146 GL148
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-ACCT-PERIOD
Element: Accounting 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
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-SYSTEM
Element: System Code		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
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-JE-TYPE
Element: Journal Entry Type		Alpha 1
The type of journal entry. Valid values are Normal and Intercompany.
GL146 GL148
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-CONTROL-GROUP
Element: 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
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-JE-SEQUENCE
Journal Entry
Sequence		Numeric 2
The assigned sequence number.
GL146 GL148
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-LINE-NBR
Element: Line Number		Numeric 6
This field contains the line number.
GL146 GL148
GL191 GL196
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-LOG-SEQ-NBR
Element: Log Sequence Number		Numeric 6
The journal entry log sequence number.
GL146 GL148
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-ERROR-CAT
Element: Error Category		Alpha 5
The journal entry error category.
GL146 GL148
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-MSG-NBR
Element: Message Number		Numeric 3
The journal entry message number.
GL146 GL148
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-ERR-INF-FLAG
Element: Error Flag		Alpha 1
Indicates a journal entry error.
GL190 GL500
IFGT.1
GJL-PROGRAM
Element: Program		Alpha 5
This field designates the program this record was created by.
GL146 GL148
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-RUN-DATE
Element: Run Date		Numeric 8 (yyyymmdd)
The date a transaction is posted to general ledger.
GL146 GL148
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-RUN-TIME
Element: Run Time		Numeric 6 (hhmmss)
GL146 GL148
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-ERR-VAR1
Element: Error Variable		Alpha 20
IFGT.1
GJL-ERR-VAR2
Element: Error Variable		Alpha 20
IFGT.1
GJL-ERR-VAR3
Element: Error Variable		Alpha 20
IFGT.1
GJL-ERR-VAR4
Element: Error Variable		Alpha 20
IFGT.1
GJL-ERR-VAR5
Element: Error Variable		Alpha 20
IFGT.1
GJL-JOBNAME
Element: Jobname		Alpha 10 (Lower Case)
IFGT.1


GLJELOG FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GJLSET1 COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
LINE-NBR
LOG-SEQ-NBR
GL110 GL145
GL146 GL190
GL191 GL196
GL197 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GL342 GL42.1
IFGT.1 IFJR.1
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


GLJELOG FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
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

File created: Wed Jun 08 20:49:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.