GLCHART – General Ledger Chart

System
General Ledger Setup (IF)
Prefix
GCH
Primary key
CHART-NAME
Fields
27
Updated by
5 programs
Referenced by
1246 programs

GLCHART is the General Ledger Chart table in Lawson General Ledger Setup (prefix GCH). It is indexed by CHART-NAME (GCHSET1); alternate indexes: GCHSET2. It is related 1:1 to GLCHARTDTL, GLCHARTBOD, SLGROUPHDR and SLRELATHDR and 1:M to GLSYSTEM, GLCHARTDTL, GLESACCT, RWREQUEST and GLCHARTSUM. It is updated by GL00.1, GL00.2, GL00.7, GL00.9 and GL160 and referenced by AC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 and 1238 more. The table has 27 fields, 2 indexes and 16 documented relations.

About GLCHART

The General Ledger Chart (GLCHART) file contains chart and system account information in the General Ledger system including retained earnings, undistributed retained earnings, error suspense, and gain/loss account records defined in the System Accounts subform.

Fields (27)

Column = COBOL field name without the GCH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#GCH-CHART-NAME PK
CHART_NAME		Alpha 12This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.GL00.2, GL00.9, GL160
#GCH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The chart of accounts description.GL00.2, GL00.9, GL160
#GCH-SHORT-DESC
SHORT_DESC		DerivedThe chart short description.—
#GCH-RE-ACCOUNT
RE_ACCOUNT		Numeric 6The retained earnings account number. At year end, the system uses this account to close all income statement accounts.GL00.3, GL00.7, GL160
#GCH-RE-SUB-ACCT
RE_SUB_ACCT		Numeric 4The retained earnings subaccount. At year end, the system uses this account to close all income statement accounts.GL00.3, GL00.7, GL160
#GCH-URE-ACCOUNT
URE_ACCOUNT		Numeric 6The undistributed retained earnings account. The system stores the accumulated net income and loss in this account.GL00.3, GL00.7, GL160, GL288
#GCH-URE-SUB-ACCT
URE_SUB_ACCT		Numeric 4The undistributed retained earnings subaccount. The system stores the accumulated net income and loss in this account.GL00.3, GL00.7, GL160
#GCH-ES-ACCOUNT
ES_ACCOUNT		Numeric 6The error suspense account. The system uses the error suspense account to post any differences from subsystems, or any instances of inactive or invalid accounts and accounting units. This account makes sure that the general ledger always stays in balance.GL00.3, GL00.7, GL160
#GCH-ES-SUB-ACCT
ES_SUB_ACCT		Numeric 4The error suspense subaccount. The system uses the error suspense account to post any differences from subsystems, or any instances of inactive or invalid accounts and accounting units. This account makes sure that the general ledger stays in balance.GL00.3, GL00.7, GL160
#GCH-GAIN-ACCT
GAIN_ACCT		Numeric 6This is the gain account from your General Ledger Chart of Accounts. The translation gain account stores a favorable variance if one exists during the currency translation process.GL00.3, GL00.7
#GCH-GAIN-SUB-ACCT
GAIN_SUB_ACCT		Numeric 4This is the gain subaccount from your general ledger chart of accounts.GL00.3, GL00.7
#GCH-LOSS-ACCT
LOSS_ACCT		Numeric 6This is the loss account from your general ledger chart of accounts. The translation loss account stores an unfavorable variance if one exists during the currency translation process.GL00.3, GL00.7
#GCH-LOSS-SUB-ACCT
LOSS_SUB_ACCT		Numeric 4This is the loss subaccount from your general ledger chart of accounts.GL00.3, GL00.7
#GCH-RND-ACCOUNT
RND_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.GL00.7
#GCH-RND-SUB-ACCT
RND_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.GL00.7
#GCH-LAST-SEQ-NBR
LAST_SEQ_NBR		Numeric 6The last sequence number assigned.GL00.1, GL160
#GCH-LAST-ACCT-ID
LAST_ACCT_ID		Numeric 6The summary account ID.GL00.1, GL160
#GCH-BAL-ACCOUNT
BAL_ACCOUNT		Numeric 6The account used to post journal autobalancing entries in company base currency if the company selected autobalancing.GL00.7
#GCH-BAL-SUB-ACCT
BAL_SUB_ACCT		Numeric 4The subaccount used to post journal autobalancing entries.GL00.7
#GCH-BAL-DESC
BAL_DESC		Alpha 60The name of the autobalancing account.—
#GCH-SEGMENT-GROUP SET2
SEGMENT_GROUP		Alpha 15A user analysis group is a combination of up to four user analysis for reports and analysis.GL00.2
#GCH-COMT-ACCOUNT
COMT_ACCOUNT		Numeric 6The Accrued Commitment Account is the account the system will use to post the total commitments for the period or year.GL00.7, GL160
#GCH-COMT-SUB-ACCT
COMT_SUB_ACCT		Numeric 4The Accrued Commitment Subaccount is the subaccount the system will use to post the total commitments for the period or year.GL00.7, GL160
#GCH-CREATED-BY
CREATED_BY		Alpha 10—GL00.2, GL00.9, GL160
#GCH-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—GL00.1, GL00.2, GL00.7, GL00.9, GL160
#GCH-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—GL00.1, GL00.2, GL00.7, GL00.9, GL160
#GCH-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—GL00.1, GL00.2, GL00.7, GL00.9, GL160

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GCHSET1
  1. CHART-NAME
PrimaryAC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +22 more (list truncated in source)
GCHSET2
  1. SEGMENT-GROUP
  2. CHART-NAME
KeyChangeSL01.2, SL02.2

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLCHARTDTLGLCHARTBODSLGROUPHDRSLRELATHDRGLSYSTEMGLCHARTDTLGLESACCTRWREQUESTGLCHARTSUMGLCHART

One to one (11) — lookups and parents

RelationTableRulesConditionField map
Bal AccountGLCHARTDTLNot Required
GCH-CHART-NAME→GDT-CHART-NAME
GCH-BAL-ACCOUNT→GDT-ACCOUNT
GCH-BAL-SUB-ACCT→GDT-SUB-ACCOUNT
Comt AccountGLCHARTDTLNot Required
GCH-CHART-NAME→GDT-CHART-NAME
GCH-COMT-ACCOUNT→GDT-ACCOUNT
GCH-COMT-SUB-ACCT→GDT-SUB-ACCOUNT
Es AccountGLCHARTDTLNot Required
GCH-CHART-NAME→GDT-CHART-NAME
GCH-ES-ACCOUNT→GDT-ACCOUNT
GCH-ES-SUB-ACCT→GDT-SUB-ACCOUNT
Gain AccountGLCHARTDTLNot Required
GCH-CHART-NAME→GDT-CHART-NAME
GCH-GAIN-ACCT→GDT-ACCOUNT
GCH-GAIN-SUB-ACCT→GDT-SUB-ACCOUNT
GlchartbodGLCHARTBODNot Required, Delete Cascades
GCH-CHART-NAME→YBT-CHART-NAME
Loss AccountGLCHARTDTLNot Required
GCH-CHART-NAME→GDT-CHART-NAME
GCH-LOSS-ACCT→GDT-ACCOUNT
GCH-LOSS-SUB-ACCT→GDT-SUB-ACCOUNT
Re AccountGLCHARTDTLNot Required
GCH-CHART-NAME→GDT-CHART-NAME
GCH-RE-ACCOUNT→GDT-ACCOUNT
GCH-RE-SUB-ACCT→GDT-SUB-ACCOUNT
Rnd AccountGLCHARTDTLNot Required
GCH-CHART-NAME→GDT-CHART-NAME
GCH-RND-ACCOUNT→GDT-ACCOUNT
GCH-RND-SUB-ACCT→GDT-SUB-ACCOUNT
SlgrouphdrSLGROUPHDRRequired
GCH-SEGMENT-GROUP→SLH-SEGMENT-GROUP
SlrelathdrSLRELATHDRRequired
GCH-SEGMENT-GROUP→SRH-SEGMENT-GROUP
GCH-CHART-NAME→SRH-RELATION
Ure AccountGLCHARTDTLNot Required
GCH-CHART-NAME→GDT-CHART-NAME
GCH-URE-ACCOUNT→GDT-ACCOUNT
GCH-URE-SUB-ACCT→GDT-SUB-ACCOUNT

One to many (5) — child tables

RelationTableRulesConditionField map
CompanyGLSYSTEMDelete Restricted
GCH-CHART-NAME→GLS-CHART-NAME
—→GLS-COMPANY
Detail AcctsGLCHARTDTLDelete Cascades
GCH-CHART-NAME→GDT-CHART-NAME
—→GDT-ACCOUNT
—→GDT-SUB-ACCOUNT
GlesacctGLESACCTDelete Cascades
GCH-CHART-NAME→ESA-CHART-NAME
—→ESA-SYSTEM
ReportsRWREQUEST
GCH-CHART-NAME→RWR-CHART-NAME
—→RWR-REQUEST-NAME
Summary AcctsGLCHARTSUMDelete Restricted
GCH-CHART-NAME→GCS-CHART-NAME
—→GCS-CHART-SECTION
—→GCS-SEQ-NUMBER

Programs

Updated by (5)

Referenced by (1246)