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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GCHSET1CHART-NAMEPrimaryAC03.1, AC03.2, AC03.3, AC03.4, AC03.5, AC03.6, AC03.7, AC10.1 +22 more (list truncated in source)
GCHSET2SEGMENT-GROUP, CHART-NAMEKeyChangeSL01.2, SL02.2

Relations

One to one (11) — lookups and parents

RelationTableRulesConditionField map
Bal AccountGLCHARTDTLNot RequiredGCH-CHART-NAME → GDT-CHART-NAME, GCH-BAL-ACCOUNT → GDT-ACCOUNT, GCH-BAL-SUB-ACCT → GDT-SUB-ACCOUNT
Comt AccountGLCHARTDTLNot RequiredGCH-CHART-NAME → GDT-CHART-NAME, GCH-COMT-ACCOUNT → GDT-ACCOUNT, GCH-COMT-SUB-ACCT → GDT-SUB-ACCOUNT
Es AccountGLCHARTDTLNot RequiredGCH-CHART-NAME → GDT-CHART-NAME, GCH-ES-ACCOUNT → GDT-ACCOUNT, GCH-ES-SUB-ACCT → GDT-SUB-ACCOUNT
Gain AccountGLCHARTDTLNot RequiredGCH-CHART-NAME → GDT-CHART-NAME, GCH-GAIN-ACCT → GDT-ACCOUNT, GCH-GAIN-SUB-ACCT → GDT-SUB-ACCOUNT
GlchartbodGLCHARTBODNot Required, Delete CascadesGCH-CHART-NAME → YBT-CHART-NAME
Loss AccountGLCHARTDTLNot RequiredGCH-CHART-NAME → GDT-CHART-NAME, GCH-LOSS-ACCT → GDT-ACCOUNT, GCH-LOSS-SUB-ACCT → GDT-SUB-ACCOUNT
Re AccountGLCHARTDTLNot RequiredGCH-CHART-NAME → GDT-CHART-NAME, GCH-RE-ACCOUNT → GDT-ACCOUNT, GCH-RE-SUB-ACCT → GDT-SUB-ACCOUNT
Rnd AccountGLCHARTDTLNot RequiredGCH-CHART-NAME → GDT-CHART-NAME, GCH-RND-ACCOUNT → GDT-ACCOUNT, GCH-RND-SUB-ACCT → GDT-SUB-ACCOUNT
SlgrouphdrSLGROUPHDRRequiredGCH-SEGMENT-GROUP → SLH-SEGMENT-GROUP
SlrelathdrSLRELATHDRRequiredGCH-SEGMENT-GROUP → SRH-SEGMENT-GROUP, GCH-CHART-NAME → SRH-RELATION
Ure AccountGLCHARTDTLNot RequiredGCH-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 RestrictedGCH-CHART-NAME → GLS-CHART-NAME, → GLS-COMPANY
Detail AcctsGLCHARTDTLDelete CascadesGCH-CHART-NAME → GDT-CHART-NAME, → GDT-ACCOUNT, → GDT-SUB-ACCOUNT
GlesacctGLESACCTDelete CascadesGCH-CHART-NAME → ESA-CHART-NAME, → ESA-SYSTEM
ReportsRWREQUESTGCH-CHART-NAME → RWR-CHART-NAME, → RWR-REQUEST-NAME
Summary AcctsGLCHARTSUMDelete RestrictedGCH-CHART-NAME → GCS-CHART-NAME, → GCS-CHART-SECTION, → GCS-SEQ-NUMBER

Programs

Updated by (5)

Referenced by (1246)