|
|
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 AC160 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
AM19.1 AM19.2 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
AM502 AM551 AM92.1 AM96.1 AM98.1 AP115
AP125 AP126 AP131 AP150 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 AP21.1
AP220 AP23.1 AP25.1 AP25.2 AP255 AP26.1
AP265 AP27.1 AP28.1 AP28.2 AP30.2 AP30.4
AP305 AP520 AP55.1 AP80.1 AP81.1 AP90.5
API1.1 API2.1 AR01.1 AR115 AR124 AR129
AR130 AR131 AR135 AR137 AR195 AR196
AR20.1 AR21.1 AR21.2 AR21.3 AR24.1 AR29.2
AR30.1 AR30.2 AR30.3 AR30.8 AR32.1 AR33.1
AR33.3 AR33.5 AR33.6 AR34.1 AR34.4 AR35.1
AR35.2 AR38.1 AR38.2 AR38.3 AR39.1 AR39.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 BL80.1
BL820 BL92.1 BN100 BN101 BN102 BN103
BN105 BN138 BN15.1 BN150 BN215 BN245
BN305 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 BR151 BR152 BR154
BR21.1 BR41.1 BR41.4 BR43.1 BR46.1 BRIP.1
CB06.2 CB10.1 CB145 CB15.1 CB15.2 CB150
CB180 CB185 CB186 CB187 CB190 CB191
CB20.1 CB25.1 CB30.1 CB43.1 CB44.1 CB45.1
CB46.1 CB50.1 CB500 CB54.1 CB543 CB544
CB55.1 CB554 CB80.1 CB82.1 CXCP.1 DT180
DT181 DT185 DT190 DT30.1 DT30.2 DT40.1
DT520 DT92.1 EE20.1 EE20.2 EE20.4 EE520
ET530 ET540 ETI2.1 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 IC12.1 IC12.2 IC130
IC320 IC330 IC812 CU03.1 GL03.6 GL12.1
GL12.2 GL124 GL198 GL201 GL225 GL25.1
IFGT.1 JB00.2 JB200 LP00.1 LP100 LP101
LP130 LP180 LP31.1 LP570 LP80.1 MA180
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA530 MA531
MA540 MA60.2 MA60.3 MA60.5 MA61.1 MA63.1
MA65.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA69.1 MA69.2 MA70.1 MA75.1
MA80.1 MAI1.1 PA02.1 PA100 PA102 PA115
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 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO16.1
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO228 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO253 PO27.2 PO29.1
PO30.1 PO30.2 PO30.3 PO300 PO31.1 PO31.2
PO32.2 PO32.4 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 POID.1
POII.1 POIJ.1 PR00.1 PR110 PR113 PR120
PR128 PR13.1 PR13.5 PR13.6 PR13.8 PR130
PR131 PR132 PR134 PR135 PR136 PR160
PR180 PR189 PR197 PR29.1 PR30.1 PR32.2
PR33.1 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 PR80.1 PR80.2
PR82.1 PR85.1 UK102 UK560 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 TA125
TA145 TA146 TA147 TA148 TA170 TA180
TA181 TA195 TA199 TA60.1 TA70.1 TA80.1
TA81.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 WH224
WH226 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 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
GL01.1 GL01.2 GL10.1 LP900 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, LP900 RW01.1
source code, folder, or process group. RW01.2 RW02.1
RW02.2
C = System Code
F = Folder
P = Process Group
R = Reconciliation Code
GCD-FOLDER-NAME Alpha 12 LP900 RW01.1
Element: Folder Required for record type "F," this RW01.2
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 LP900 RW02.1
Element: Process Group Required for record type "P," this RW02.2
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 = LP900
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 LP900
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 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 BL199
CB195 GL01.1
GL01.2 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 BL199
is updated along with the GCD-YEAR to CA199 CB195
indicate the last period closed. GL179 GL500
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 BL199
is updated to indicate the last year CA199 CB195
closed along with the GCD-PERIOD. GL179 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 AC255 AC256
FOLDER-NAME 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 Subset RW00.1 RW02.1
Where RECORD-TYPE = "P" RW02.2 RW200
RW202
GCDSET3 SOURCE-CODE KeyChange, Subset
Where RECORD-TYPE = "S"
GCDSET4 COMPANY Subset AC130 AC160
SYSTEM Where RECORD-TYPE = "C" AC195 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
AM19.1 AM19.2
AM190 AM192
AM20.1 AM20.2
AM20.3 AM20.4
...
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
|
