Lawson Insight Technical Documentation |
|
GLJELOG
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 GL148 GL190 GL191 GL197
GL199 GL40.1 GL40.2 GL40.3 GL40.6 GL40.7
GL40.8 GL44.1 GL45.1 GL500 GL342 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GJL-COMPANY Numeric 4 GL110 GL146
Element: Company Identifies the AP company if the GL148 GL190
resource type = V. Identifies the HR GL191 GL197
company if the resource type = E. It is GL199 GL40.1
blank for type A, P or Q resources. GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-FISCAL-YEAR Numeric 4 GL146 GL148
Element: Fiscal Year This is the current fiscal year. This GL190 GL191
field is updated by Period Closing GL197 GL199
(GL199). GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-ACCT-PERIOD Numeric 2 GL146 GL148
Element: Accounting PerThis is the current accounting period. GL190 GL191
This field is updated by GL199 (Period GL197 GL199
Closing). GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-SYSTEM Alpha 2 GL146 GL148
Element: System Code A two-character code representing an GL190 GL191
application used within the Lawson GL197 GL199
system. (i.e.: GL = General Ledger, AP = GL40.1 GL40.2
Accounts Payable, etc.) GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-JE-TYPE Alpha 1 GL146 GL148
Element: Journal Entry The type of journal entry. Valid values GL190 GL191
are Normal and Intercompany. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-CONTROL-GROUP Numeric 8 GL146 GL148
Element: Control Group This field displays the journal entry GL190 GL191
number used for process control of the GL197 GL199
journal entry detail. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-JE-SEQUENCE Numeric 2 GL146 GL148
Journal Entry The assigned sequence number. GL190 GL191
Sequence GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-LINE-NBR Numeric 6 GL146 GL148
Element: Line Number This field contains the line number. GL191 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 Numeric 6 GL146 GL148
Element: Log Sequence NThe journal entry log sequence number. GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-ERROR-CAT Alpha 5 GL146 GL148
Element: Error CategoryThe journal entry error category. GL190 GL191
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-MSG-NBR Numeric 3 GL146 GL148
Element: Message NumberThe journal entry message number. GL190 GL191
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 Alpha 1 GL190 GL500
Element: Error Flag Indicates a journal entry error. IFGT.1
GJL-PROGRAM Alpha 5 GL146 GL148
Element: Program This field designates the program this GL190 GL191
record was created by. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-RUN-DATE Numeric 8 (yyyymmdd) GL146 GL148
Element: Run Date The date a transaction is posted to GL190 GL191
general ledger. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
GJL-RUN-TIME Numeric 6 (hhmmss) GL146 GL148
Element: Run Time Contains the time a transaction is GL190 GL191
posted to the general ledger. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 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 GL197
SYSTEM GL40.1 GL40.2
JE-TYPE GL40.3 GL40.6
CONTROL-GROUP GL40.7 GL40.8
JE-SEQUENCE GL44.1 GL45.1
LINE-NBR GL500 GL342
LOG-SEQ-NBR GL42.1 IFGT.1
IFJR.1
GJLSET2 COMPANY KeyChange 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 KeyChange, 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
|