|
|
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 AC45.1 AC54.1 AC540
AM115 AM117 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.2 AM500 AM502 AM551 AM92.1 AM96.1
AM98.1 AP125 AP126 AP131 AP151 AP155
AP160 AP161 AP170 AP175 AP180 AP181
AP190 AP191 AP193 AP25.1 AP25.2 AP255
AP26.1 AP265 AP27.1 AP28.1 AP28.2 AP30.2
AP30.4 AP520 AP55.1 AP80.1 AP81.1 AP90.5
API1.1 AR01.1 AR115 AR124 AR129 AR130
AR131 AR135 AR196 AR20.1 AR21.1 AR21.2
AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.3
AR30.8 AR31.1 AR31.5 AR31.6 AR33.1 AR33.3
AR33.5 AR33.6 AR34.1 AR34.4 AR35.1 AR35.2
AR42.1 AR42.2 AR44.3 AR48.3 AR560 AR570
AR575 AR580 AR80.1 AR80.2 AR82.1 ARLL.1
BL120 BL122 BL130 BL140 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 BN100 BN101 BN102 BN103 BN105
BN15.1 BN150 BN215 BN245 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN531 BN65.1 BN71.1
BN72.1 BS13.1 BS14.1 BS15.1 BS32.1 BR120
BR41.1 BR41.4 BR43.1 BR46.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 HAP3.1 HEP4.1
HPOS.1 HPQC.1 HPRS.1 HR11.1 HR11.2 HR15.1
HR155 HR511 HR515 HR54.1 HR55.2 HRS1.1
HRSC.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 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 IC62.4 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 MA180 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 OE10.1 OE10.2 OE10.3
OE10.4 OE10.5 OE10.6 OE10.7 OE10.8 OE11.1
OE11.4 OE11.8 OE11.9 OE110 OE111 OE113
OE114 OE116 OE129 OE13.1 OE13.2 OE13.3
OE13.4 OE13.5 OE13.6 OE14.4 OE229 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE530 OE81.1 OE81.3 OE810
OE830 OE86.1 OE90.1 OE90.2 PA02.1 PA100
PA102 PA13.1 PA13.2 PA16.1 PA20.1 PA21.1
PA22.1 PA24.1 PA27.1 PA34.1 PA35.1 PA36.1
PA38.1 PA502 PA513 PA52.1 PA52.2 PA52.3
PA52.4 PA52.5 PA520 PA54.1 TR21.1 TR22.1
TR26.1 TR500 PO100 PO101 PO122 PO131
PO16.1 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO228 PO23.1 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO33.1
PO34.1 PO35.1 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO64.1 POI3.1 POIE.1
POII.1 POIJ.1 PR00.1 PR110 PR113 PR120
PR128 PR13.1 PR13.5 PR13.6 PR13.8 PR130
PR131 PR132 PR134 PR136 PR160 PR180
PR197 PR29.1 PR30.1 PR32.2 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR45.1 PR529 PR530
PR560 PR82.1 PR85.1 PRSC.1 UK102 MM280
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ39.1 RQ39.2 RQ39.3 RQ500
RQIC.1 RQID.1 RQIF.1 RQIG.1 RQIH.1 RQIJ.1
SL40.1 TA147 TP135 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 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
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 BL199
CB195 GL01.1
GL01.2 IC199
PO135 PO199
PR196
GCD-END-DATE Numeric 8 (yyyymmdd) AC195 AM190
Element: Ending Date The ending date in a range of dates. AM192 AP195
AR199 BL199
CB195 GL01.1
GL01.2 IC199
PO135 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 BL199
is updated along with the GCD-YEAR to CA199 CB195
indicate the last period closed. GL179 GL500
IC199 PO135
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 BL199
is updated to indicate the last year CA199 CB195
closed along with the GCD-PERIOD. GL179 IC199
PO135 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 AC45.1
Where RECORD-TYPE = "C" AC54.1 AC540
AM115 AM117
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
...
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
|
