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 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 Identifies the AP company if the GL148 GL190
resource type = V. Identifies the HR GL191 GL196
company if the resource type = E. It is GL197 GL199
blank for type A, P or Q resources. 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 GL148
Element: Fiscal Year Contains the fiscal year for the data GL190 GL191
stored on this record. 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 Numeric 2 GL146 GL148
Element: Accounting PerThis is the current accounting period. GL190 GL191
This field is updated by GL199 (Period GL196 GL197
Closing). 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 GL148
Element: System Code A two-character code representing an GL190 GL191
application used within the Lawson GL196 GL197
system. (i.e.: GL = General Ledger, AP = GL199 GL40.1
Accounts Payable, etc.) GL40.2 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. 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 Numeric 8 GL146 GL148
Element: Control Group This field displays the journal entry GL190 GL191
number used for process control of the GL196 GL197
journal entry detail. GL199 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 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 Numeric 6 GL146 GL148
Element: Line Number This field contains the line 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-LOG-SEQ-NBR Numeric 6 GL146 GL148
Element: Log Sequence NThe journal entry log sequence number. 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 Alpha 5 GL146 GL148
Element: Error CategoryThe journal entry error category. 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 Numeric 3 GL146 GL148
Element: Message NumberThe journal entry message number. 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 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. 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 Numeric 8 (yyyymmdd) GL146 GL148
Element: Run Date The date a transaction is posted to GL190 GL191
general ledger. 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 GL148
Element: Run Time GL190 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
|