 |
Lawson Insight Technical Documentation |
|
GLJELOG FILE
GL Journal Entry Log
This file contains journal entry log information including the system code,
control group, and sequence number.
REFERENCED BY
GL145 GL42.1 IFJR.1
UPDATED BY
GL110 GL146 GL190 GL191 GL199 GL40.2
GL40.6 GL45.1 GL500 GL342 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GJL-COMPANY Numeric 4 GL110 GL146
Company The company number represents an GL190 GL191
established company and is entered on GL199 GL40.2
all function codes. GL40.6 GL45.1
GL500 IFGT.1
GJL-FISCAL-YEAR Numeric 4 GL146 GL190
Fiscal Year This is the current fiscal year. This GL191 GL199
field is updated by Period Closing GL40.2 GL40.6
(GL199). GL45.1 GL500
IFGT.1
GJL-ACCT-PERIOD Numeric 2 GL146 GL190
Accounting Period This is the current accounting period. GL191 GL199
This field is updated by GL199 (Period GL40.2 GL40.6
Closing). GL45.1 GL500
IFGT.1
GJL-SYSTEM Alpha 2 GL146 GL190
System Code A two-character code representing an GL191 GL199
application used within the Lawson GL40.2 GL40.6
system. (i.e.: GL = General Ledger, AP = GL45.1 GL500
Accounts Payable, etc.) IFGT.1
GJL-JE-TYPE Alpha 1 GL146 GL190
Journal Entry Type The type of journal entry. Valid values GL191 GL199
are Normal and Intercompany. GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GJL-CONTROL-GROUP Numeric 8 GL146 GL190
Control Group This field displays the journal entry GL191 GL199
number used for process control of the GL40.2 GL40.6
journal entry detail. GL45.1 GL500
IFGT.1
GJL-JE-SEQUENCE Numeric 2 GL146 GL190
Journal Entry The assigned sequence number. GL191 GL199
Sequence GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GJL-LINE-NBR Numeric 6 GL146 GL191
Line Number This field contains the line number. GL199 GL40.2
GL40.6 GL45.1
GL500 IFGT.1
GJL-LOG-SEQ-NBR Numeric 6 GL146 GL190
Log Sequence Number The journal entry log sequence number. GL191 GL199
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GJL-ERROR-CAT Alpha 5 GL146 GL190
Error Category The journal entry error category. GL191 GL199
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GJL-MSG-NBR Numeric 3 GL146 GL190
Message Number The journal entry message number. GL191 GL199
GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GJL-ERR-INF-FLAG Alpha 1 GL190 GL500
Error Flag Indicates a journal entry error. IFGT.1
GJL-PROGRAM Alpha 5 GL146 GL190
Program This field designates the program this GL191 GL199
record was created by. GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GJL-RUN-DATE Numeric 8 (yyyymmdd) GL146 GL190
Run Date The date a transaction is posted to GL191 GL199
general ledger. GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GJL-RUN-TIME Numeric 6 (hhmmss) GL146 GL190
Run Time Contains the time a transaction is GL191 GL199
posted to the general ledger. GL40.2 GL40.6
GL45.1 GL500
IFGT.1
GLJELOG FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GJLSET1 COMPANY GL110 GL145
FISCAL-YEAR GL146 GL190
ACCT-PERIOD GL191 GL40.2
SYSTEM GL40.6 GL45.1
JE-TYPE GL500 GL342
CONTROL-GROUP GL42.1 IFGT.1
JE-SEQUENCE IFJR.1
LINE-NBR
LOG-SEQ-NBR
GJLSET2 COMPANY GL42.1
RUN-DATE
RUN-TIME
PROGRAM
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
LINE-NBR
LOG-SEQ-NBR
GJLSET3 RUN-DATE Subset IFJR.1
RUN-TIME Where (LINE-NBR = Zeroes )
PROGRAM And (LOG-SEQ-NBR = 1 )
COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
LOG-SEQ-NBR
GLJELOG FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|