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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2 SET3
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 SET5
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 SET4
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 SET6
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 SET7
OBJ_ID		Numeric 12This is the unique object identifier.GL00.1, GL00.9, GL03.2, GL160
#GCS-LEDGER-GROUP SET8
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 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
GCSSET1
  1. CHART-NAME
  2. CHART-SECTION
  3. SEQ-NUMBER
PrimaryAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GCSSET2
  1. CHART-NAME
  2. SUMMARY-ACCT
KeyChangeAC34.1, ACVW.1, ATVW.1, AD290, AD50.1, AD95.1, AD96.1, AD97.1 +22 more (list truncated in source)
GCSSET3
  1. CHART-NAME
  2. CHART-SECTION
  3. SUMMARY-ACCT
KeyChangeGL00.1, GL160
GCSSET4
  1. CHART-NAME
  2. PARENT-OBJ-ID
  3. CHART-SECTION
  4. SEQ-NUMBER
KeyChange—
GCSSET5
  1. CHART-NAME
  2. SUMRY-ACCT-ID
AC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source)
GCSSET6
  1. RELATION
  2. CHART-NAME
  3. CHART-SECTION
  4. SEQ-NUMBER
KeyChangeSL02.2
GCSSET7
  1. OBJ-ID
SubsetWhere OBJ-ID != ZeroesAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GCSSET8
  1. LEDGER-GROUP
  2. CHART-NAME
  3. CHART-SECTION
  4. SEQ-NUMBER
KeyChange, SubsetWhere LEDGER-GROUP != SpacesML11.1

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Chart Of AcctsGLCHARTRequired
GCS-CHART-NAME→GCH-CHART-NAME
GlchsumbodGLCHSUMBODNot Required, Delete Cascades
GCS-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 Required
GCS-CHART-NAME→GCS-CHART-NAME
GCS-PARENT-OBJ-ID→GCS-SUMRY-ACCT-ID

One to many (4) — child tables

RelationTableRulesConditionField map
ChildrenGLCHARTSUM
GCS-CHART-NAME→GCS-CHART-NAME
GCS-SUMRY-ACCT-ID→GCS-PARENT-OBJ-ID
—→GCS-CHART-SECTION
—→GCS-SEQ-NUMBER
Detail AcctsGLCHARTDTLDelete Restricted
GCS-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)