|
|
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
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 AC170 AC40.1 AC41.1 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 AM30.3 AM40.4
AM500 AM96.1 AM98.1 AP151 AP155 AP157
AP160 AP161 AP170 AP175 AP180 AP181
AP190 AP191 AP193 AP20.1 AP20.2 AP20.5
AP20.6 AP20.7 AP20.8 AP23.1 AP25.1 AP255
AP265 AP28.1 AP28.2 AP30.2 AP30.4 AP32.2
AP520 AP55.1 AP80.1 AP81.1 AP90.5 AR01.1
AR115 AR124 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 AR560 AR570 AR575
AR580 AR80.1 AR80.2 AR82.1 BL120 BL130
BL20.1 BL20.3 BL21.2 BL21.5 BL29.1 BL29.2
BL520 BL820 BL92.1 BL940 CB06.2 CB10.1
CB15.1 CB15.2 CB180 CB185 CB190 CB191
CB20.1 CB30.1 CB500 CB80.1 CX05.1 CX05.2
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CX805 CXCP.1 DT180
DT181 DT185 DT190 DT30.1 DT30.2 DT40.1
DT520 DT92.1 EE20.1 EE20.2 EE20.4 EE520
GL145 GL146 GL165 GL190 GL191 GL199
GL230 GL245 GL256 GL30.1 GL40.1 GL40.2
GL40.7 GL40.9 GL45.1 GL65.1 DR100 IC10.2
IC116 IC12.1 IC120 IC134 IC138 IC140
IC141 IC142 IC145 IC150 IC151 IC152
IC170 IC175 IC20.1 IC20.2 IC21.1 IC21.2
IC22.1 IC22.2 IC223 IC224 IC225 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 IC29.1 IC29.2 IC29.3 IC295 IC31.1
IC40.1 IC40.2 IC45.1 IC500 IC574 IC61.1
IC62.1 IC62.2 IC67.1 IC68.1 IC68.2 IC68.3
IC72.1 IC73.1 IC74.1 IC820 IC83.1 IC90.1
IC95.1 IC95.2 IC95.3 CU03.1 GL03.6 GL12.1
GL12.2 GL198 GL201 GL225 GL25.1 IFGT.1
JB00.2 JB200 MA00.4 MA40.1 MA40.2 MA41.1
MA41.2 MA41.4 MA41.5 MA41.6 MA43.1 MA43.2
MA43.3 MA43.4 MA52.1 MA530 MA540 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
OE113 OE114 OE129 OE14.4 OE15.1 OE15.2
OE15.3 OE15.4 OE15.5 OE15.7 OE30.1 OE30.2
OE30.3 OE30.4 OE30.5 OE30.6 OE30.7 OE30.9
OE510 OE81.1 OE81.3 OE810 OE830 OE90.1
OE920 OE950 PO30.1 PO31.1 PO32.2 PO33.1
PO34.1 PO35.1 PO39.1 PO530 RQ10.1 RQ10.2
RQ10.3 RQ11.1 RQ12.1 RQ125 RQ13.1 RQ15.1
RQ20.1 RQ20.2 RQ20.4 RQ240 RQ35.1 RQ39.1
RQ39.2 RQ39.3 RQ42.1 RQ50.1 RQ500 RQ961
SL40.1 WH110 WH126 WH130 WH132 WH190
WH20.1 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6
WH20.7 WH22.1 WH220 WH222 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 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
WH961 WO10.1 WO120 WO130 WO131 WO132
WO133 WO140 WO20.1 WO215 WO220 WO232
WO235 WO250 WO251 WO252 WO255 WO256
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
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. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
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 GL110 GL204
COMPANY GL255 GL50.4
GL55.1 GL55.2
GL90.4 RW00.1
RW00.6 RW01.1
RW01.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
...
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 AC170 AC195
SYSTEM codes. AC40.1 AC41.1
AC42.1 AC54.1
Subset AC540 AM115
Where RECORD-TYPE = "C" 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
AM30.3 AM40.4
AM500 AM96.1
AM98.1 AP151
...
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
|