GLCODES FILE
General Ledger Codes
GLCODES is a multi-purpose file. It holds information relating to systems,
source codes, folders and process groups.
System codes are defined in System Control. Each system code represents a
subsystem that interfaces transactions to the Lawson General Ledger or uses
Subsystem Control features. Subsystem Control features determine at what point
the Lawson General Ledger is closed, and which dates are valid for entry in
the subsystems. In addition, the status of the entry as it hits the General
Ledger can be controlled for each system. Choices are released or unreleased.
Source codes provide the Lawson General Ledger system with a method of
identifying and classifying transactions. Any transaction either entering the
General Ledger from a subsystem or created in GL must have a source code.
Source codes (defined in Source Codes) help to group and total transactions on
reports.
Folders also provide a method for identifying and classifying. However, they
classify the pieces used to create Lawson GL Report Writer reports. Folders
are defined in RW01 (Folders).
Process groups are created in RW02 (Process Groups). They group Lawson GL
Report Writer reports that should be processed (run) at the same time.
REFERENCED BY
AC255 AC256 AC55.1 AC55.2 GL204 GL255
GL50.4 GL55.1 GL55.2 GL90.4 RW00.1 RW00.6
RW04.1 RW04.2 RW10.2 RW10.3 RW10.4 RW10.8
RW100 RW11.1 RW11.2 RW11.3 RW11.4 RW20.1
RW20.2 RW20.8 RW200 RW201 RW210 RW220
RW230 RW240 RW250 RW260 RW270 RW299
RW30.1 RW40.1 RW40.2 RW40.3 RW40.4 RW40.5
RW40.6 RW40.7 RW40.8 RW50.1 RW60.1 RW60.2
RW60.3 RW70.1 RW202 AC130 AC170 AC40.1
AC40.4 AC41.1 AC41.4 AC42.1 AC54.1 AC540
AM115 AM125 AM135 AM145 AM15.1 AM15.2
AM15.3 AM15.4 AM170 AM20.1 AM20.2 AM20.3
AM20.4 AM20.5 AM20.6 AM21.1 AM21.2 AM21.3
AM21.4 AM21.5 AM21.6 AM30.3 AM40.4 AM41.2
AM500 AM551 AM96.1 AM98.1 AP151 AP155
AP160 AP161 AP170 AP180 AP181 AP190
AP191 AP193 AP255 AP265 AP28.1 AP28.2
AP30.2 AP30.4 AP32.2 AP520 AP55.1 AP80.1
AP81.1 AP90.5 API1.1 AR01.1 AR115 AR124
AR129 AR130 AR131 AR135 AR190 AR196
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2
AR30.1 AR30.2 AR30.3 AR30.4 AR30.8 AR30.9
AR31.1 AR31.5 AR31.6 AR35.1 AR35.2 AR42.1
AR42.2 AR44.3 AR48.3 AR560 AR570 AR575
AR580 AR80.1 AR80.2 AR82.1 BL140 CB06.2
CB10.1 CB15.1 CB15.2 CB180 CB185 CB190
CB191 CB20.1 CB30.1 CB500 CB80.1 CXCP.1
DT180 DT181 DT185 DT190 DT30.1 DT30.2
DT40.1 DT520 DT92.1 EE20.1 EE20.2 EE20.4
EE520 GL122 GL145 GL146 GL165 GL190
GL191 GL199 GL230 GL245 GL256 GL30.1
GL40.1 GL40.2 GL40.6 GL40.8 GL45.1 GL65.1
DR100 IC10.2 IC12.1 IC12.2 IC120 IC125
IC130 IC134 IC138 IC140 IC141 IC142
IC145 IC150 IC151 IC152 IC170 IC175
IC20.1 IC20.2 IC21.1 IC21.2 IC211 IC22.1
IC22.2 IC223 IC224 IC225 IC226 IC227
IC228 IC23.1 IC23.2 IC23.3 IC23.4 IC23.5
IC24.1 IC24.2 IC25.1 IC26.1 IC26.2 IC262
IC28.1 IC281 IC29.1 IC29.2 IC29.3 IC295
IC31.1 IC320 IC330 IC36.1 IC40.1 IC40.2
IC45.1 IC500 IC520 IC521 IC522 IC523
IC524 IC525 IC526 IC527 IC530 IC531
IC574 IC61.1 IC62.1 IC62.2 IC67.1 IC68.1
IC68.2 IC68.3 IC72.1 IC73.1 IC74.1 IC81.1
IC82.1 IC820 IC83.1 IC840 IC90.1 IC95.1
IC95.2 IC95.3 PC120 SEA1.1 CU03.1 GL03.6
GL12.1 GL12.2 GL124 GL198 GL201 GL225
GL25.1 IFGT.1 JB00.2 JB200 MA63.1 PO16.1
PO228 PO64.1 POIJ.1 RQ11.1 RQ12.1 RQ13.1
RQ39.1 RQ39.2 RQ39.3 SEA3.1 WH110 WH126
WH130 WH22.1 WH220 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH34.5 RW03.2
UPDATED BY
AC195 AM190 AM192 AP195 AR199 BL199
CB195 CA199 GL04.1 GL04.2 GL110 GL167
GL179 GL500 RW01.1 RW01.2 RW02.1 RW02.2
IC199 GL01.1 GL01.2 GL10.1 PO135 PO199
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCD-RECORD-TYPE Alpha 1 GL01.1 GL01.2
Record Type This field is filled by the program GL04.1 GL04.2
creating a GLCODES record. This field GL10.1 GL167
specifies the record as a system code, RW01.1 RW01.2
source code, folder, or process group. RW02.1 RW02.2
C = System Code
F = Folder
P = Process Group
R = Reconciliation Code
GCD-FOLDER-NAME Alpha 12 RW01.1 RW01.2
Folder Required for record type "F," this
field is created in RW01. A folder is
used to classify the pieces comprising a
GL Report Writer report or ratio.
GCD-PROCESS-GROUP Alpha 15 RW02.1 RW02.2
Process Group Required for record type "P," this
field is created in RW02. A process
group is used to group GL Report Writer
reports together for processing.
GCD-SYSTEM Alpha 2 GL01.1 GL01.2
System A two-character code representing an GL04.1 GL04.2
application used within the Lawson GL10.1 GL167
system. (i.e.: GL = General Ledger, AP =
Accounts Payable, etc.)
GCD-SOURCE-CODE Alpha 2
Source Code Required field for record types of "C"
or "S." This field can represent either
a system code or a source code.
System codes have a record type of "C."
They identify all systems that interface
to the Lawson General Ledger or use
subledger control features.
Source codes have a record type of "S."
Source codes help to classify
transactions in the Lawson General
Ledger system.
GCD-COMPANY Numeric 4 GL01.1 GL01.2
Company The company number as defined in GL10.1 GL10.1 GL110
(Company). GL167
GCD-DESCRIPTION Alpha 30 (Lower Case) GL01.1 GL01.2
Description The system code description. GL04.1 GL04.2
GL10.1 GL167
RW01.1 RW01.2
RW02.1 RW02.2
RW100
GCD-SYSTEM-FLAG Alpha 1 GL01.1 GL01.2
System Flag Indicates if subledger control features GL10.1 GL167
are used for the system being defined.
Y = Yes
N = No
GCD-BEGIN-DATE Numeric 8 (yyyymmdd) AC195 AM190
Begin Date The beginning date in a range of dates. AM192 AP195
AR199 BL199
CB195 GL01.1
GL01.2 IC199
PO135 PO199
GCD-END-DATE Numeric 8 (yyyymmdd) AC195 AM190
Ending Date The ending date in a range of dates. AM192 AP195
AR199 BL199
CB195 GL01.1
GL01.2 IC199
PO135 PO199
GCD-PERIOD Numeric 2 AC195 AM190
Last Closed Period When the subsystem closing program is AM192 AP195
run for the indicated system, this field AR199 BL199
is updated along with the GCD-YEAR to CA199 CB195
indicate the last period closed. GL179 GL500
IC199 PO135
PO199
GCD-YEAR Numeric 4 AC195 AM190
Last Closed Year When the subsystem closing program is AM192 AP195
run for the indicated system, this field AR199 BL199
is updated to indicate the last year CA199 CB195
closed along with the GCD-PERIOD. GL179 IC199
PO135 PO199
GCD-OPEN-PERIODS Numeric 2 GL01.1 GL01.2
Open Periods It is used by the subsystem's closing
program to increment the new ending date
(GCD-END-DATE) in the valid entry date
range.
00
12
GCD-USER-CLASS Alpha 12 RW01.1 RW01.2
User Class Represents a group of users that have
authority to use a system.
GCD-ACTIVITY-IGNOR Alpha 1 GL01.1 GL01.2
Activity Ignore Indicates if Activity system
transactions are ignored.
N = No
Y = Yes
GCD-ZONE-IGNORE Alpha 1 GL01.1 GL01.2
Zone Ignore Indicates if Base Zone transactions are
ignored.
N = No
Y = Yes
GCD-ACTIVITY Alpha 15
Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
GCD-HOLD-CODE Alpha 4 GL01.1 GL01.2
Hold Code This field contains the journal hold
code.
GCD-JRNL-BOOK-NBR Alpha 12 GL01.1 GL01.2
Journal Book The journal book assigned to the
transaction.
GLCODES FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCDSET1 RECORD-TYPE This path is used to retrieve Report AC255 AC256
FOLDER-NAME Writer folders. AC55.1 AC55.2
PROCESS-GROUP GL04.1 GL04.2
SYSTEM GL204 GL255
COMPANY GL50.4 GL55.1
GL55.2 GL90.4
RW00.1 RW00.6
RW01.1 RW01.2
RW04.1 RW04.2
RW10.2 RW10.3
RW10.4 RW10.8
RW100 RW11.1
RW11.2 RW11.3
RW11.4 RW20.1
RW20.2 RW20.8
...
GCDSET2 PROCESS-GROUP This path is used to retrieve process RW00.1 RW02.1
groups. RW02.2 RW200
RW202
Subset
Where RECORD-TYPE = "P"
GCDSET3 SOURCE-CODE This path is used to retrieve source
codes.
Subset
Where RECORD-TYPE = "S"
GCDSET4 COMPANY This path is used to retrieve system AC130 AC170
SYSTEM codes. AC195 AC40.1
AC40.4 AC41.1
Subset AC41.4 AC42.1
Where RECORD-TYPE = "C" AC54.1 AC540
AM115 AM125
AM135 AM145
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM190
AM192 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
...
GCDSET5 USER-CLASS KeyChange, Subset RW03.2
FOLDER-NAME Where (RECORD-TYPE = "F" )
GLCODES FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Systemcode SYSTEMCODE Not Required
Valid When GCD-RECORD-TYPE = "C"
GCD-SYSTEM -> SYS-SYSTEM
GLCODES FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amacctgrp AMACCTGRP
GCD-COMPANY -> AAG-COMPANY
AAG-ACCT-GRP
Amasset AMASSET
GCD-COMPANY -> AST-COMPANY
AST-ASSET
Amasttype AMASTTYPE
GCD-COMPANY -> ATP-COMPANY
ATP-ASSET-TYPE
ATP-SUB-TYPE
Amcalendar AMCALENDAR
GCD-COMPANY -> AMC-COMPANY
AMC-BOOK
Amtrans AMTRANS
GCD-COMPANY -> AMT-COMPANY
"4" -> AMT-TRANS-STATUS
AMT-ASSET-PROCESS
AMT-ASSET
AMT-SEQ-NUMBER
Computes CMPUTE Delete Restricted
GCD-FOLDER-NAME -> CMP-FOLDER-NAME
CMP-COMPUTE-NAME
Formats RWFORMAT Delete Restricted
GCD-FOLDER-NAME -> RWF-FOLDER-NAME
RWF-FORMAT
RWF-LINE-NBR
Glcontrol H GLCONTROL
GCD-COMPANY -> GLC-COMPANY
GCD-HOLD-CODE -> GLC-HOLD-CODE
GLC-FISCAL-YEAR
GLC-ACCT-PERIOD
GLC-STATUS
GLC-SYSTEM
GLC-JE-TYPE
GLC-CONTROL-GROUP
GLC-JE-SEQUENCE
Glsysje GLSYSJE
Valid When GCD-RECORD-TYPE = "C"
GCD-COMPANY -> GSJ-COMPANY
GCD-SYSTEM -> GSJ-SYSTEM
GSJ-FISCAL-YEAR
GSJ-ACCT-PERIOD
Groups RWHEADER Delete Restricted
GCD-FOLDER-NAME -> RWH-FOLDER-NAME
"G" -> RWH-HEAD-TYPE
RWH-HEAD-NAME
RWH-RECORD-TYPE
Pr Grp Request RWREQUEST Delete Restricted
Valid When GCD-RECORD-TYPE = "P"
GCD-PROCESS-GROUP -> RWR-PROCESS-GROUP
RWR-REQUEST-NAME
Ratio Names RADEFINE Delete Restricted
GCD-FOLDER-NAME -> RAD-FOLDER-NAME
RAD-RATIO-NAME
Rationames RADEFINE Delete Restricted
GCD-FOLDER-NAME -> RAD-FOLDER-NAME
RAD-RATIO-NAME
Requests RWREQUEST Delete Restricted
GCD-FOLDER-NAME -> RWR-FOLDER-NAME
RWR-REQUEST-NAME
Rows RWHEADER Delete Restricted
GCD-FOLDER-NAME -> RWH-FOLDER-NAME
"R" -> RWH-HEAD-TYPE
RWH-HEAD-NAME
RWH-RECORD-TYPE
Rwuser RWUSER
GCD-USER-CLASS -> RWU-USER-CLASS
RWU-USERNAME
Total Names RATOTALS Delete Restricted
GCD-FOLDER-NAME -> RAT-FOLDER-NAME
RAT-FISCAL-YEAR
RAT-TOTAL-NAME
RAT-ACCT-UNIT
Total Ranges RWHEADER Delete Restricted
GCD-FOLDER-NAME -> RWH-FOLDER-NAME
"T" -> RWH-HEAD-TYPE
RWH-HEAD-NAME
RWH-RECORD-TYPE
Totalnames RATOTALS Delete Restricted
GCD-FOLDER-NAME -> RAT-FOLDER-NAME
RAT-FISCAL-YEAR
RAT-TOTAL-NAME
RAT-ACCT-UNIT
Totalranges RWHEADER Delete Restricted
GCD-FOLDER-NAME -> RWH-FOLDER-NAME
"T" -> RWH-HEAD-TYPE
RWH-HEAD-NAME
RWH-RECORD-TYPE
|
