|
|
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 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 AM154 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.1 AM30.2 AM30.3
AM40.1 AM40.2 AM40.3 AM40.4 AM41.1 AM41.2
AM500 AM551 AM96.1 AM98.1 AP125 AP126
AP131 AP151 AP155 AP160 AP161 AP170
AP175 AP180 AP181 AP190 AP191 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.6
AP20.7 AP20.8 AP23.1 AP25.1 AP25.2 AP255
AP26.1 AP265 AP27.1 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 AR137 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 BR120 BR151
BR152 BR156 BR21.1 BR41.1 BR41.4 BR43.1
CB06.2 CB10.1 CB15.1 CB15.2 CB180 CB185
CB190 CB191 CB20.1 CB25.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 GL197 GL199 GL230
GL245 GL256 GL30.1 GL40.1 GL40.2 GL40.3
GL40.6 GL40.7 GL40.8 GL44.1 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
IC182 IC20.1 IC20.2 IC21.1 IC21.2 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
IC270 IC28.1 IC281 IC282 IC285 IC29.1
IC29.2 IC29.3 IC295 IC31.1 IC320 IC330
IC36.1 IC40.1 IC40.2 IC44.1 IC45.1 IC500
IC520 IC521 IC522 IC523 IC524 IC525
IC526 IC527 IC530 IC531 IC574 IC598
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 IC84.1 IC84.2 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 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA540 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.1 PO100 PO101
PO122 PO131 PO16.1 PO20.1 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO228 PO23.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 PO64.1 POI3.1 POII.1 POIJ.1
PR197 MM280 MM80.1 MM80.2 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ35.1 RQ39.1
RQ39.2 RQ39.3 RQ500 RQIC.1 RQID.1 RQIE.1
RQIF.1 RQIG.1 RQIH.1 RQIJ.1 SEA3.1 SL40.1
WH110 WH120 WH126 WH130 WH132 WH190
WH20.1 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6
WH20.7 WH22.1 WH220 WH222 WH25.1 WH25.2
WH30.1 WH30.2 WH30.3 WH30.4 WH31.1 WH31.2
WH31.3 WH31.4 WH32.1 WH32.2 WH32.3 WH32.4
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 WH40.1 WH40.2 WH520 WH830 WO10.1
WO120 WO130 WO131 WO132 WO133 WO140
WO20.1 WO215 WO220 WO232 WO235 WO250
WO251 WO252 WO255 WO256 WO280 WO30.1
WO30.2 WO300 WO32.1 WO32.2 WO32.3 WO32.4
WO32.5 WO35.1 WO40.1 WO40.2 WO40.3 WO40.4
WO40.5 WO40.6 WO41.1 WO41.2 WO41.3 WO41.4
WO42.1 WO42.2 WO42.3 WO42.4 WO42.5 WO45.1
WO510 WO80.1 WO81.1 WO81.2 WO82.1 WOEX.1
WOSP.1 RW03.2
UPDATED BY
AC195 AM190 AM192 AP195 AR199 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 PO139 PO199
PR196
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCD-RECORD-TYPE Alpha 1 GL01.1 GL01.2
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Company The company number as defined in GL10.1 GL10.1 GL110
(Company). GL167
GCD-DESCRIPTION Alpha 30 (Lower Case) GL01.1 GL01.2
Element: 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
Element: 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
Element: Begin Date The beginning date in a range of dates. AM192 AP195
AR199 CB195
GL01.1 GL01.2
IC199 PO135
PO139 PO199
PR196
GCD-END-DATE Numeric 8 (yyyymmdd) AC195 AM190
Element: Ending Date The ending date in a range of dates. AM192 AP195
AR199 CB195
GL01.1 GL01.2
IC199 PO135
PO139 PO199
PR196
GCD-PERIOD Numeric 2 AC195 AM190
Element: Last Closed PeWhen the subsystem closing program is AM192 AP195
run for the indicated system, this field AR199 CA199
is updated along with the GCD-YEAR to CB195 GL179
indicate the last period closed. GL500 IC199
PO135 PO139
PO199 PR196
GCD-YEAR Numeric 4 AC195 AM190
Element: Last Closed YeWhen the subsystem closing program is AM192 AP195
run for the indicated system, this field AR199 CA199
is updated to indicate the last year CB195 GL179
closed along with the GCD-PERIOD. IC199 PO135
PO139 PO199
PR196
GCD-OPEN-PERIODS Numeric 2 GL01.1 GL01.2
Element: 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
Element: User Class Represents a group of users that have
authority to use a system.
GCD-ACTIVITY-IGNOR Alpha 1 GL01.1 GL01.2
Element: Activity IgnorIndicates if Activity system
transactions are ignored.
N = No
Y = Yes
GCD-ZONE-IGNORE Alpha 1 GL01.1 GL01.2
Element: Zone Ignore Indicates if Base Zone transactions are
ignored.
N = No
Y = Yes
GCD-ACTIVITY Alpha 15
Element: 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
Element: Hold Code This field contains the journal hold
code.
GCD-JRNL-BOOK-NBR Alpha 12 GL01.1 GL01.2
Element: 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.
KeyChange, Subset
Where RECORD-TYPE = "S"
GCDSET4 COMPANY This path is used to retrieve system AC130 AC195
SYSTEM codes. AC40.1 AC40.4
AC41.1 AC41.4
Subset AC42.1 AC54.1
Where RECORD-TYPE = "C" AC540 AM115
AM125 AM135
AM145 AM15.1
AM15.2 AM15.3
AM15.4 AM154
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
|
