GLCHARTSUM – General Ledger Chart Summary

System
General Ledger Setup (IF)
Prefix
GCS
Primary key
CHART-NAME, CHART-SECTION, SEQ-NUMBER
Fields
32
Updated by
7 programs
Referenced by
506 programs

GLCHARTSUM is the General Ledger Chart Summary table in Lawson General Ledger Setup (prefix GCS). It is indexed by CHART-NAME, CHART-SECTION, SEQ-NUMBER (GCSSET1); alternate indexes: GCSSET2, GCSSET3, GCSSET4, GCSSET5, GCSSET6, GCSSET7 and GCSSET8. It is related 1:1 to GLCHART, GLCHSUMBOD, MXLISTHDR and GLCHARTSUM and 1:M to GLCHARTSUM, GLCHARTDTL, GLACCTVLD and MXLISTMBR. It is updated by GL00.1, GL00.2, GL00.8, GL00.9, GL03.2, GL03.4 and GL160 and referenced by AC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 and 498 more. The table has 32 fields, 8 indexes and 8 documented relations.

About GLCHARTSUM

This file contains chart summary records including summary account information and report options defined in GL00.1 (Chart of Accounts) and the Summary Account Options subform.

Fields (32)

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

Field / columnTypeDescription & valuesUpdated by
GCS-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.1, GL00.9, GL03.2, GL160
GCS-CHART-SECTION PK
CHART_SECTION		Alpha 1The chart section.
  • 1 Balance Sheet
  • 2 Income Statement
GL00.1, GL03.2, GL160
GCS-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to the summary account.GL00.1, GL03.2, GL160
GCS-SUMMARY-ACCT
SUMMARY_ACCT		Alpha 12The summary account.GL00.1, GL00.8, GL03.2, GL160
GCS-ACCOUNT-DESC
ACCOUNT_DESC		Alpha 60 (Lower Case)The account description.GL00.1, GL03.2, GL160
GCS-TOTAL-DESC
TOTAL_DESC		Alpha 60 (Lower Case)The description that appears next to the transaction total.GL00.1, GL03.2
GCS-DEPTH
DEPTH		Numeric 2Indicates the order of account totaling. For example, each account assigned a depth of 2, totals to the previous account assigned a depth of 1.
  • 01 Depth 1
  • 02 Depth 2
  • 03 Depth 3
  • 04 Depth 4
  • 05 Depth 5
  • 06 Depth 6
  • 07 Depth 7
  • 08 Depth 8
  • 09 Depth 9
GL00.1, GL03.2, GL160
GCS-SUMRY-ACCT-ID
SUMRY_ACCT_ID		Numeric 6The summary account.GL00.1, GL03.2, GL160
GCS-SPACE-CODE
SPACE_CODE		Numeric 1Indicates the number of spaces you want to advance on a report after the heading.
  • 1 Advance 1 Line
  • 2 Advance 2 Lines
  • 3 Advance 3 Lines
  • 9 Advance to Next Page
GL00.1, GL03.2, GL160, GL281
GCS-SIGN-CODE
SIGN_CODE		Alpha 1This field determines whether the sign following an account balance is reversed. The default is No. This field is for appearance only, it does not change the amount balance.
  • N No
  • Y Yes
GL00.1, GL03.2, GL160
GCS-SPACE-CODE-TTL
SPACE_CODE_TTL		Numeric 1The number of spaces appearing after the summary account total.
  • 1 Advance 1 Line
  • 2 Advance 2 Lines
  • 3 Advance 3 Lines
  • 9 Advance to Next Page
GL00.1, GL03.2, GL160
GCS-UNDERLINE-B4
UNDERLINE_B4		Alpha 1The underline appearing before the total.
  • S Single
  • D Double
  • N None
GL00.1, GL03.2, GL160, GL281
GCS-UNDERLINE-AFT
UNDERLINE_AFT		Alpha 1The underline appearing after the total.
  • S Single
  • D Double
  • N None
GL00.1, GL03.2, GL160, GL281
GCS-PRINT-HEADING
PRINT_HEADING		Alpha 1Indicates if the heading is printed for financial statements.
  • Y Yes
  • N No
GL00.1, GL03.2
GCS-PARENT-OBJ-ID
PARENT_OBJ_ID		Numeric 12The ID of the parent object.GL00.1, GL03.2, GL160
GCS-DYNAMIC-LIST
DYNAMIC_LIST		Alpha 12A valid accounting unit attribute list. Detail accounts are created for the accounting unit after transactions are entered.GL00.1, GL03.2, GL160
GCS-RESTRICT-SYS
RESTRICT_SYS		Alpha 1Indicates if system codes are validated every time the account is used by a system.
  • N No
  • Y Yes
GL00.1, GL03.2, GL03.4
GCS-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thruGL00.1, GL03.2, GL160
GCS-DAILY-BALANCE
DAILY_BALANCE		Alpha 1" "
  • Y Yes
  • N No
GL00.1, GL03.2, GL160
GCS-RELATION
RELATION		Alpha 15The user analysis value relation assigned to the detail or summary account. The relation must exist in SL02.1 (User Analysis Value Relation).GL00.1, GL03.2
GCS-UNARY-OPER
UNARY_OPER		Alpha 1The mathematical operation to consolidate amounts for a natural balance. Valid values are Add, subtract, multiply, and divide. The default is Add. Only used by the OLAP environment. + = Addition % = Percentile " " = Do Nothing
  • - Subtraction
  • * Multiplication
  • / Division
GL00.1, GL03.2, GL160
GCS-NAT-BALANCE
NAT_BALANCE		Alpha 1This field determines whether the natural balance is a Debit or Credit. This field is not required. This is only used by the OLAP environment. " " = Blank
  • D Debit
  • C Credit
GL00.1, GL03.2, GL160
GCS-SL-ACCT-FLAG
SL_ACCT_FLAG		Alpha 1This flag determines whether user analysis values can be assigned to a specific account. You can select Yes, No, or use the Summary Account selection.GL00.1, GL03.2, GL160
GCS-OBJ-ID
OBJ_ID		Numeric 12This is the unique object identifier.GL00.1, GL00.9, GL03.2, GL160
GCS-LEDGER-GROUP
LEDGER_GROUP		Alpha 15—GL00.1, GL03.2, GL160
GCS-GL-BUD-FL
GL_BUD_FL		Alpha 1This is the Yes/No flag for budget editing.
  • N No Edit
  • Y Yes
GL00.1, GL03.2, GL160
GCS-GL-ACCT-TYPE
GL_ACCT_TYPE		Numeric 2—
  • 01 Asset
  • 02 Liability
  • 03 Equity
  • 04 Revenue
  • 05 Expense
  • 06 Statistical
GL00.1, GL160
GCS-XBRL-TAG-ID
XBRL_TAG_ID		Alpha 60—GL00.1, GL160
GCS-CREATED-BY
CREATED_BY		Alpha 10—GL00.1, GL00.9, GL03.2, GL160
GCS-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—GL00.1, GL00.8, GL00.9, GL03.2, GL03.4, GL160
GCS-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—GL00.1, GL00.8, GL00.9, GL03.2, GL03.4, GL160
GCS-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—GL00.1, GL00.8, GL00.9, GL03.2, GL03.4, GL160

Indexes (8)

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

IndexKeysFlagsConditionUsed in
GCSSET1CHART-NAME, CHART-SECTION, SEQ-NUMBERPrimaryAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GCSSET2CHART-NAME, SUMMARY-ACCTKeyChangeAC34.1, ACVW.1, ATVW.1, AD290, AD50.1, AD95.1, AD96.1, AD97.1 +22 more (list truncated in source)
GCSSET3CHART-NAME, CHART-SECTION, SUMMARY-ACCTKeyChangeGL00.1, GL160
GCSSET4CHART-NAME, PARENT-OBJ-ID, CHART-SECTION, SEQ-NUMBERKeyChange—
GCSSET5CHART-NAME, SUMRY-ACCT-IDAC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source)
GCSSET6RELATION, CHART-NAME, CHART-SECTION, SEQ-NUMBERKeyChangeSL02.2
GCSSET7OBJ-IDSubsetWhere OBJ-ID != ZeroesAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GCSSET8LEDGER-GROUP, CHART-NAME, CHART-SECTION, SEQ-NUMBERKeyChange, SubsetWhere LEDGER-GROUP != SpacesML11.1

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Chart Of AcctsGLCHARTRequiredGCS-CHART-NAME → GCH-CHART-NAME
GlchsumbodGLCHSUMBODNot Required, Delete CascadesGCS-CHART-NAME → YBV-CHART-NAME, GCS-CHART-SECTION → YBV-CHART-SECTION, GCS-SEQ-NUMBER → YBV-SEQ-NUMBER
MxlisthdrMXLISTHDRNot Required"ACCTU" → MLH-OBJ-TYPE, GCS-DYNAMIC-LIST → MLH-MATRIX-LIST
ParentGLCHARTSUMNot RequiredGCS-CHART-NAME → GCS-CHART-NAME, GCS-PARENT-OBJ-ID → GCS-SUMRY-ACCT-ID

One to many (4) — child tables

RelationTableRulesConditionField map
ChildrenGLCHARTSUMGCS-CHART-NAME → GCS-CHART-NAME, GCS-SUMRY-ACCT-ID → GCS-PARENT-OBJ-ID, → GCS-CHART-SECTION, → GCS-SEQ-NUMBER
Detail AcctsGLCHARTDTLDelete RestrictedGCS-CHART-NAME → GDT-CHART-NAME, GCS-SUMRY-ACCT-ID → GDT-SUMRY-ACCT-ID, → GDT-ACCOUNT, → GDT-SUB-ACCOUNT
Glacctvld SysGLACCTVLD"S" → VLD-RECORD-TYPE, GCS-CHART-NAME → VLD-CHART-NAME, GCS-SUMRY-ACCT-ID → VLD-SUMRY-ACCT-ID, Zeroes → VLD-ACCOUNT, Zeroes → VLD-SUB-ACCOUNT, Zeroes → VLD-COMPANY, Spaces → VLD-ACCT-UNIT, → VLD-SYSTEM
MxlistmbrMXLISTMBR"ACCTU" → MLM-OBJ-TYPE, GCS-DYNAMIC-LIST → MLM-MATRIX-LIST, → MLM-SEQ-NUMBER

Programs

Updated by (7)

Referenced by (506)