GLCODES – General Ledger Codes

System
General Ledger Setup (IF)
Prefix
GCD
Primary key
RECORD-TYPE, FOLDER-NAME, PROCESS-GROUP, SYSTEM, COMPANY
Fields
20
Updated by
27 programs
Referenced by
637 programs

GLCODES is the General Ledger Codes table in Lawson General Ledger Setup (prefix GCD). It is indexed by RECORD-TYPE, FOLDER-NAME, PROCESS-GROUP, SYSTEM, COMPANY (GCDSET1); alternate indexes: GCDSET2, GCDSET3, GCDSET4 and GCDSET5. It is related 1:1 to SYSTEMCODE and 1:M to AMACCTGRP, AMASSET, AMASTTYPE, AMCALENDAR, AMTRANS, CMPUTE, RWFORMAT, GLCONTROL and 6 more. It is updated by AC195, AM190, AM192, AP195, CA199, CB195, GL01.1, GL01.2 and 19 more and referenced by AC130, AC160, AC255, AC256, AC40.1, AC40.4, AC41.1, AC41.4 and 629 more. The table has 20 fields, 5 indexes and 21 documented relations.

About GLCODES

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.

Fields (20)

Column = COBOL field name without the GCD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
GCD-RECORD-TYPE PK
RECORD_TYPE		Alpha 1This 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, ML167 +4 more
GCD-FOLDER-NAME PK
FOLDER_NAME		Alpha 12Required 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 PK
PROCESS_GROUP		Alpha 15Required 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 PK
SYSTEM		Alpha 2A 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, ML167
GCD-SOURCE-CODE
SOURCE_CODE		Alpha 2Required 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 PK
COMPANY		Numeric 4The company number as defined in GL10.1 (Company).GL01.1, GL01.2, GL10.1, GL110, GL167, LP900, ML167
GCD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The system code description.GL01.1, GL01.2, GL04.1, GL04.2, GL10.1, GL167, ML167, RW01.1 +4 more
GCD-SYSTEM-FLAG
SYSTEM_FLAG		Alpha 1Indicates if subledger control features are used for the system being defined.
  • Y Yes
  • N No
GL01.1, GL01.2, GL10.1, GL167, ML167
GCD-BEGIN-DATE
BEGIN_DATE		Numeric 8 (yyyymmdd)The beginning date in a range of dates.AC195, AM190, AM192, AP195, CB195, GL01.1, GL01.2, IC199 +5 more
GCD-END-DATE
END_DATE		Numeric 8 (yyyymmdd)The ending date in a range of dates.AC195, AM190, AM192, AP195, CB195, GL01.1, GL01.2, IC199 +5 more
GCD-PERIOD
PERIOD		Numeric 2When 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.AC195, AM190, AM192, AP195, CA199, CB195, GL179, GL500 +6 more
GCD-YEAR
YEAR		Numeric 4When 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.AC195, AM190, AM192, AP195, CA199, CB195, GL179, IC199 +5 more
GCD-OPEN-PERIODS
OPEN_PERIODS		Numeric 2It is used by the subsystem's closing program to increment the new ending date (GCD-END-DATE) in the valid entry date range. 00 12GL01.1, GL01.2
GCD-USER-CLASS
USER_CLASS		Alpha 12Represents a group of users that have authority to use a system.RW01.1, RW01.2
GCD-ACTIVITY-IGNOR
ACTIVITY_IGNOR		Alpha 1Indicates if Activity system transactions are ignored.
  • N No
  • Y Yes
GL01.1, GL01.2
GCD-ZONE-IGNORE
ZONE_IGNORE		Alpha 1Indicates if Base Zone transactions are ignored.
  • N No
  • Y Yes
GL01.1, GL01.2
GCD-ACTIVITY
ACTIVITY		Alpha 15Activities 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
HOLD_CODE		Alpha 4This field contains the journal hold code.GL01.1, GL01.2
GCD-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.GL01.1, GL01.2
GCD-AUTH-FLAG
AUTH_FLAG		Alpha 1Indicates if additional authorization is required to run Report Writer reports by folder or process group.
  • Y Yes
  • N No
RW01.1, RW01.2, RW02.1, RW02.2

Indexes (5)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GCDSET1RECORD-TYPE, FOLDER-NAME, PROCESS-GROUP, SYSTEM, COMPANYPrimaryAC255, AC256, AC55.1, AC55.2, GL04.1, GL04.2, GL204, GL255 +22 more (list truncated in source)
GCDSET2PROCESS-GROUPSubsetWhere RECORD-TYPE = "P"RW00.1, RW02.1, RW02.2, RW200, RW202
GCDSET3SOURCE-CODEKeyChange, SubsetWhere RECORD-TYPE = "S"—
GCDSET4COMPANY, SYSTEMSubsetWhere RECORD-TYPE = "C"AC130, AC160, AC195, AC40.1, AC40.4, AC41.1, AC41.4, AC42.1 +22 more (list truncated in source)
GCDSET5USER-CLASS, FOLDER-NAMEKeyChange, SubsetWhere (RECORD-TYPE = "F")RW03.2

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
SystemcodeSYSTEMCODENot RequiredValid When GCD-RECORD-TYPE = "C"GCD-SYSTEM → SYS-SYSTEM

One to many (20) — child tables

RelationTableRulesConditionField map
AmacctgrpAMACCTGRPGCD-COMPANY → AAG-COMPANY, → AAG-ACCT-GRP
AmassetAMASSETGCD-COMPANY → AST-COMPANY, → AST-ASSET
AmasttypeAMASTTYPEGCD-COMPANY → ATP-COMPANY, → ATP-ASSET-TYPE, → ATP-SUB-TYPE
AmcalendarAMCALENDARGCD-COMPANY → AMC-COMPANY, → AMC-BOOK
AmtransAMTRANSGCD-COMPANY → AMT-COMPANY, "4" → AMT-TRANS-STATUS, → AMT-ASSET-PROCESS, → AMT-ASSET, → AMT-SEQ-NUMBER
ComputesCMPUTEDelete RestrictedGCD-FOLDER-NAME → CMP-FOLDER-NAME, → CMP-COMPUTE-NAME
FormatsRWFORMATDelete RestrictedGCD-FOLDER-NAME → RWF-FOLDER-NAME, → RWF-FORMAT, → RWF-LINE-NBR
Glcontrol HGLCONTROLGCD-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
GlsysjeGLSYSJEValid When GCD-RECORD-TYPE = "C"GCD-COMPANY → GSJ-COMPANY, GCD-SYSTEM → GSJ-SYSTEM, → GSJ-FISCAL-YEAR, → GSJ-ACCT-PERIOD
GroupsRWHEADERDelete RestrictedGCD-FOLDER-NAME → RWH-FOLDER-NAME, "G" → RWH-HEAD-TYPE, → RWH-HEAD-NAME, → RWH-RECORD-TYPE
Pr Grp RequestRWREQUESTDelete RestrictedValid When GCD-RECORD-TYPE = "P"GCD-PROCESS-GROUP → RWR-PROCESS-GROUP, → RWR-REQUEST-NAME
Ratio NamesRADEFINEDelete RestrictedGCD-FOLDER-NAME → RAD-FOLDER-NAME, → RAD-RATIO-NAME
RationamesRADEFINEDelete RestrictedGCD-FOLDER-NAME → RAD-FOLDER-NAME, → RAD-RATIO-NAME
RequestsRWREQUESTDelete RestrictedGCD-FOLDER-NAME → RWR-FOLDER-NAME, → RWR-REQUEST-NAME
RowsRWHEADERDelete RestrictedGCD-FOLDER-NAME → RWH-FOLDER-NAME, "R" → RWH-HEAD-TYPE, → RWH-HEAD-NAME, → RWH-RECORD-TYPE
RwuserRWUSERGCD-USER-CLASS → RWU-USER-CLASS, → RWU-USERNAME
Total NamesRATOTALSDelete RestrictedGCD-FOLDER-NAME → RAT-FOLDER-NAME, → RAT-FISCAL-YEAR, → RAT-TOTAL-NAME, → RAT-ACCT-UNIT
Total RangesRWHEADERDelete RestrictedGCD-FOLDER-NAME → RWH-FOLDER-NAME, "T" → RWH-HEAD-TYPE, → RWH-HEAD-NAME, → RWH-RECORD-TYPE
TotalnamesRATOTALSDelete RestrictedGCD-FOLDER-NAME → RAT-FOLDER-NAME, → RAT-FISCAL-YEAR, → RAT-TOTAL-NAME, → RAT-ACCT-UNIT
TotalrangesRWHEADERDelete RestrictedGCD-FOLDER-NAME → RWH-FOLDER-NAME, "T" → RWH-HEAD-TYPE, → RWH-HEAD-NAME, → RWH-RECORD-TYPE

Programs

Updated by (27)

Referenced by (637)