GLCOMMENT FILE
General Ledger Comments
This file contains the comments and header information for Journal entries
and Recurring Journal entries.
REFERENCED BY
GL240 GL270 GL41.1
UPDATED BY
AP125 AP126 AP20.1 AP20.2 AP20.5 AP20.7
AP23.1 AP25.1 AP25.2 AP26.1 AP30.2 AP30.4
AP32.2 GL110 GL146 GL170 GL190 GL199
GL300 GL40.1 GL40.2 GL40.3 GL40.5 GL40.7
GL40.8 GL40.9 GL44.1 GL45.1 GL500 GL70.2
GL70.5 GL70.7 GL75.1 GL981 IFGT.1 MA40.1
MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6
MA43.1 MA43.2 MA43.3 MA43.4 MA52.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCM-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP20.1 AP20.2
established company and is entered on AP20.5 AP20.7
all function codes. AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL110
GL146 GL170
GL190 GL40.1
GL40.2 GL40.3
GL40.5 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.5
GL70.7 GL75.1
IFGT.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
GCM-RECORD-TYPE Alpha 1 AP125 AP126
Record Type This field identifies the type of AP20.1 AP20.2
record defined. AP20.5 AP20.7
AP23.1 AP25.1
Valid values are: AP25.2 AP26.1
S=Summary AP30.2 AP30.4
D=Detail AP32.2 GL146
J = Journal Entry GL170 GL190
R = Recurring Entry GL40.1 GL40.2
GL40.3 GL40.5
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.5
GL75.1 IFGT.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
GCM-SYSTEM Alpha 2 AP125 AP126
System A two-character code representing an AP20.1 AP20.2
application used within the Lawson AP20.5 AP20.7
system. (i.e.: GL = General Ledger, AP = AP23.1 AP25.1
Accounts Payable, etc.) AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL190
GL40.1 GL40.2
GL40.3 GL40.5
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL70.5 GL75.1
GL981 IFGT.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
GCM-FISCAL-YEAR Numeric 4 AP125 AP126
Fiscal Year This is the fiscal year for the journal AP20.1 AP20.2
entry comment. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL190
GL199 GL40.1
GL40.2 GL40.3
GL40.5 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.5
GL75.1 IFGT.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
GCM-ACCT-PERIOD Numeric 2 AP125 AP126
Accounting Period This is the accounting period for the AP20.1 AP20.2
journal entry comment. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL190
GL199 GL40.1
GL40.2 GL40.3
GL40.5 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.5
GL75.1 IFGT.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
GCM-CONTROL-GROUP Numeric 8 AP125 AP126
Control Group This field contains the journal entry AP20.1 AP20.2
number used for process control of the AP20.5 AP20.7
journal entry detail. AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL190
GL40.1 GL40.2
GL40.3 GL40.5
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL70.5 GL70.7
GL75.1 IFGT.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
GCM-JE-TYPE Alpha 1 AP125 AP126
Journal Entry Type The type of journal entry. Valid values AP20.1 AP20.2
are Normal and Intercompany. AP20.5 AP20.7
AP23.1 AP25.1
N = Normal AP25.2 AP26.1
I = Intercompany AP30.2 AP30.4
A = Auto Rev Normal AP32.2 GL146
R = Auto Rev Intc GL170 GL190
GL199 GL40.1
GL40.2 GL40.3
GL40.5 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL70.5 GL75.1
IFGT.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
GCM-JE-SEQUENCE Numeric 2 AP125 AP126
Journal Entry The unique journal entry sequence AP20.1 AP20.2
Sequence number. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL190
GL40.1 GL40.2
GL40.3 GL40.5
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 GL500
GL75.1 IFGT.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
GCM-SEQUENCE-NBR Numeric 4 AP20.1 AP20.2
Sequence Number The user-assigned sequence number to AP20.5 AP20.7
keep the records unique and to determine AP25.1 AP25.2
order. AP30.2 AP30.4
AP32.2 GL146
GL170 GL190
GL40.1 GL40.2
GL40.3 GL40.5
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.5
GL75.1 IFGT.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4
GCM-CMT-TEXT Alpha 60 (Lower Case) AP125 AP126
Comments The text associated with the sequence AP20.1 AP20.2
number. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL190
GL40.1 GL40.2
GL40.3 GL40.5
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.5
GL75.1 IFGT.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
GCM-DATE Numeric 8 (yyyymmdd) AP125 AP126
Date The system date the comment was last AP20.1 AP20.2
modified. AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP30.2 AP30.4
AP32.2 GL146
GL170 GL190
GL40.1 GL40.2
GL40.3 GL40.5
GL40.8 GL40.9
GL44.1 GL45.1
GL500 GL70.5
GL75.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
GLCOMMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCMSET1 COMPANY GL110 GL146
RECORD-TYPE GL170 GL190
SYSTEM GL199 GL240
FISCAL-YEAR GL270 GL300
ACCT-PERIOD GL40.1 GL40.2
CONTROL-GROUP GL40.3 GL40.5
JE-TYPE GL40.7 GL40.8
JE-SEQUENCE GL40.9 GL41.1
SEQUENCE-NBR GL44.1 GL45.1
GL500 GL70.1
GL70.2 GL70.5
GL70.7 GL981
IFGT.1
|