GLCODES

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
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 RW11.1 RW11.2 RW11.3 RW11.4 RW20.1
RW20.2 RW20.8 RW210 RW220 RW240 RW250
RW260 RW299 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 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 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 BN729 BN991 BS13.1 BS14.1 BS15.1
BS32.1 CB06.2 CB10.1 CB145 CB15.1 CB15.2
CB150 CB180 CB185 CB186 CB187 CB190
CB191 CB20.1 CB20.6 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
EE20.1 EE20.2 EE20.4 EE520 GL122 GL145
GL146 GL165 GL190 GL191 GL197 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 HCRE.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR15.1 HR155 HR156 HR511
HR515 HR54.1 HR55.2 HRS1.1 HRSC.1 PR521
CU03.1 EX175 EX542 EX545 EXI2.1 EXI4.1
GL03.6 GL124 GL225 GL25.1 IFGT.1 JB00.2
JB200 HS706 LP00.1 LP100 LP101 LP130
LP131 LP140 LP180 LP31.1 LP570 LP80.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA540 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 PA50.1 PA502
PA513 PA52.1 PA52.2 PA52.3 PA52.4 PA52.5
PA520 PA54.1 TR21.1 TR22.1 TR26.1 TR500
PO136 PO190 PO300 PO520 PO64.1 POCP.1
POI3.1 POII.1 POIJ.1 PR00.1 PR110 PR113
PR120 PR128 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR160 PR180 PR189 PR197
PR29.1 PR30.1 PR32.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 PR37.1 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.2
PR80.4 PR82.1 PR85.1 UK102 UK560 SL40.1
TA125 TA145 TA146 TA147 TA148 TA170
TA180 TA181 TA195 TA199 TA60.1 TA70.1
TA70.2 TA80.1 TA81.1


UPDATED BY
AM190 AM192 AP195 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 PR196 GL204 RW100 RW200 RW201
RW230 RW270 RW30.1 RW202 GL199 GL12.1
GL12.2 GL198 GL201 RW03.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GCD-RECORD-TYPE
Element: Record Type		Alpha 1
This field is filled by the program creating a GLCODES record. This field specifies the record as a system code, source code, folder, or process group.
C = System Code
F = Folder
P = Process Group
R = Reconciliation Code
GL01.1 GL01.2
GL04.1 GL04.2
GL10.1 GL167
LP900 RW01.1
RW01.2 RW02.1
RW02.2
GCD-FOLDER-NAME
Element: Folder		Alpha 12
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.
LP900 RW01.1
RW01.2
GCD-PROCESS-GROUP
Element: Process Group		Alpha 15
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.
LP900 RW02.1
RW02.2
GCD-SYSTEM
Element: System		Alpha 2
A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)
GL01.1 GL01.2
GL04.1 GL04.2
GL10.1 GL167
LP900
GCD-SOURCE-CODE
Element: Source Code		Alpha 2
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
Element: Company		Numeric 4
The company number as defined in GL10.1 (Company).
GL01.1 GL01.2
GL10.1 GL110
GL167 LP900
GCD-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
The system code description.
GL01.1 GL01.2
GL04.1 GL04.2
GL10.1 GL167
RW01.1 RW01.2
RW02.1 RW02.2
RW100
GCD-SYSTEM-FLAG
Element: System Flag		Alpha 1
Indicates if subledger control features are used for the system being defined.
Y = Yes
N = No
GL01.1 GL01.2
GL10.1 GL167
GCD-BEGIN-DATE
Element: Begin Date		Numeric 8 (yyyymmdd)
The beginning date in a range of dates.
AM190 AM192
AP195 CB195
GL01.1 GL01.2
PR196
GCD-END-DATE
Element: Ending Date		Numeric 8 (yyyymmdd)
The ending date in a range of dates.
AM190 AM192
AP195 CB195
GL01.1 GL01.2
PR196
GCD-PERIOD
Element: Last Closed Period		Numeric 2
When the subsystem closing program is run for the indicated system, this field is updated along with the GCD-YEAR to indicate the last period closed.
AM190 AM192
AP195 CA199
CB195 GL179
GL500 PR196
GCD-YEAR
Element: Last Closed Year		Numeric 4
When the subsystem closing program is run for the indicated system, this field is updated to indicate the last year closed along with the GCD-PERIOD.
AM190 AM192
AP195 CA199
CB195 GL179
PR196
GCD-OPEN-PERIODS
Element: Open Periods		Numeric 2
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
GL01.1 GL01.2
GCD-USER-CLASS
Element: User Class		Alpha 12
Represents a group of users that have authority to use a system.
RW01.1 RW01.2
GCD-ACTIVITY-IGNOR
Element: Activity Ignore		Alpha 1
Indicates if Activity system transactions are ignored.
N = No
Y = Yes
GL01.1 GL01.2
GCD-ZONE-IGNORE
Element: Zone Ignore		Alpha 1
Indicates if Base Zone transactions are ignored.
N = No
Y = Yes
GL01.1 GL01.2
GCD-ACTIVITY
Element: Activity		Alpha 15
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
Element: Hold Code		Alpha 4
This field contains the journal hold code.
GL01.1 GL01.2
GCD-JRNL-BOOK-NBR
Element: Journal Book		Alpha 12
The journal book assigned to the transaction.
GL01.1 GL01.2


GLCODES FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GCDSET1 RECORD-TYPE
FOLDER-NAME
PROCESS-GROUP
SYSTEM
COMPANY
...
GL04.1 GL04.2
GL204 GL255
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
RW200 RW201
RW210 RW220
GCDSET2 PROCESS-GROUP
Subset
WhereRECORD-TYPE ="P"
RW00.1 RW02.1
RW02.2 RW200
RW202
GCDSET3 SOURCE-CODE
KeyChange, Subset
WhereRECORD-TYPE ="S"
GCDSET4 COMPANY
SYSTEM
Subset
WhereRECORD-TYPE ="C"
...
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 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM30.1
AM30.2 AM30.3
GCDSET5 USER-CLASS
FOLDER-NAME
KeyChange, Subset
Where(RECORD-TYPE ="F")
RW03.2


GLCODES FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:49:44 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.