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 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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GJL-COMPANY Numeric 4 GL110 GL146
Element: Company The company number represents an GL190 GL191
established company and is entered on GL196 GL197
all function codes. GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
GJL-FISCAL-YEAR Numeric 4 GL146 GL190
Element: Fiscal Year This is the current fiscal year. This GL191 GL196
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 GL190
Element: Accounting Period 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 Alpha 2 GL146 GL190
Element: System Code A two-character code representing an GL191 GL196
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 GL190
Element: Journal Entry The type of journal entry. Valid values GL191 GL196
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 GL190
Element: Control Group This field displays the journal entry GL191 GL196
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 GL190
Journal Entry The assigned sequence number. GL191 GL196
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 GL191
Element: Line Number This field contains the line number. 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 Numeric 6 GL146 GL190
Element: Log Sequence NThe journal entry log sequence number. 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 Alpha 5 GL146 GL190
Element: Error CategoryThe journal entry error category. 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 Numeric 3 GL146 GL190
Element: Message NumberThe journal entry message number. 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 Alpha 1 GL190 GL500
Element: Error Flag Indicates a journal entry error. IFGT.1
GJL-PROGRAM Alpha 5 GL146 GL190
Element: Program This field designates the program this GL191 GL196
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 GL190
Element: Run Date 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 Numeric 6 (hhmmss) GL146 GL190
Element: Run Time GL191 GL196
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 GL196
SYSTEM GL197 GL40.1
JE-TYPE GL40.2 GL40.3
CONTROL-GROUP GL40.6 GL40.7
JE-SEQUENCE GL40.8 GL44.1
LINE-NBR GL45.1 GL500
LOG-SEQ-NBR GL342 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
|