GLCHARTDTL – General Ledger Chart Detail

System
General Ledger Setup (IF)
Prefix
GDT
Primary key
CHART-NAME, SUMRY-ACCT-ID, ACCOUNT, SUB-ACCOUNT
Fields
35
Updated by
57 programs
Referenced by
572 programs

GLCHARTDTL is the General Ledger Chart Detail table in Lawson General Ledger Setup (prefix GDT). It is indexed by CHART-NAME, SUMRY-ACCT-ID, ACCOUNT, SUB-ACCOUNT (GDTSET1); alternate indexes: GDTSET2, GDTSET3, GDTSET4, GDTSET5, GDTSET6 and GDTSET7. It is related 1:1 to GLCHART, CUCODES, GLCHDTLBOD, MXLISTHDR, GLCHARTSUM and TRCODES and 1:M to GLCHTDTLAU, GLACCTVLD, MXLISTMBR, GLCHARTDTL and GLMASTER. It is updated by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 49 more and referenced by AC121, AC123, AC130, AC145, AC20.1, AC20.2, AC20.3, AC20.4 and 564 more. The table has 35 fields, 7 indexes and 14 documented relations.

About GLCHARTDTL

This file contains chart detail records including posting and currency options defined in the Detail Accounts and Account Information subforms form GL00.1 (Chart of Accounts).

Fields (35)

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

Field / columnTypeDescription & valuesUpdated by
GDT-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.3, GL00.9, GL02.1, GL02.2, GL02.3, GL160
GDT-SUMRY-ACCT-ID PK
SUMRY_ACCT_ID		Numeric 6The summary account ID.GL00.3, GL00.6, GL02.1, GL02.2, GL02.3, GL02.6, GL160
GDT-CHART-SECTION
CHART_SECTION		Alpha 1The chart section.
  • 1 Balance Sheet
  • 2 Income Statement
GL00.3, GL02.1, GL02.2, GL02.3, GL160, GL500
GDT-ACCOUNT PK
ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.CA110, FB11.1, FB95.1, FB95.2, FB95.3, FB95.4, FB95.5, FB95.6 +52 more (list truncated in source)
GDT-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.CA110, GL00.3, GL02.1, GL02.2, GL02.3, GL160, RW100
GDT-OLD-ACCT-NBR-D
OLD_ACCT_NBR_D		DerivedThe derived old account number.—
GDT-ACCOUNT-DESC
ACCOUNT_DESC		Alpha 60 (Lower Case)The account description.AP213, GL00.3, GL02.1, GL02.2, GL02.3, GL160, GL284, GL285 +6 more
GDT-SHORT-ACCT-DSC
SHORT_ACCT_DSC		Derived——
GDT-SPACE-CODE
SPACE_CODE		Numeric 1Indicates the number of spaces you want to advance after the account appears on a report.
  • 1 Advance One Line
  • 2 Advance Two Lines
  • 3 Advance Three Lines
  • 9 Advance To Next Page
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-SIGN-CODE
SIGN_CODE		Alpha 1Indicates a negative sign beside a positive amount.
  • N No
  • Y Yes
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-UNITS-CODE
UNITS_CODE		Alpha 1Determines if units are allowed.
  • Y Yes - Not Required
  • N No
  • O Only
  • R Yes - Required
GL00.3, GL00.7, GL02.1, GL02.2, GL02.3, GL03.3, GL100, GL160
GDT-ACTIVITY-REQ
ACTIVITY_REQ		Alpha 1Indicates if an Activity is required.
  • Y Yes
  • N No
  • B Blank
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-POSTING-LEVEL
POSTING_LEVEL		Alpha 1Determines if transactions are interfaced to the Lawson General Ledger system in detail or summary form.
  • D Detail
  • S Summary
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company's base currency code.FB45.1, GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL135, GL160 +16 more
GDT-CURR-CONTROL
CURR_CONTROL		Alpha 1Lets you limit all transactions to one currency.
  • 0 No
  • 1 Yes
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-TRANSL-CODE
TRANSL_CODE		Alpha 2Identifies the translation rate applied against the account balance to calculate the translation value.GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-REVALUE
REVALUE		Alpha 1Lets you revalue non-base transactions of an account into the company base currency.
  • 0 No
  • 1 Yes
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.
  • A Active
  • I Inactive
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-DYNAMIC-LIST
DYNAMIC_LIST		Alpha 12The attribute list associated with the summary account.GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-RESTRICT-SYS
RESTRICT_SYS		Alpha 1Determines if system codes are validated every time the account is used by a system. " " = Sum Acct Default
  • Y Yes
  • N No
GL00.3, GL02.1, GL02.2, GL02.3, GL03.5, GL100, GL160
GDT-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.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-DAILY-BALANCE
DAILY_BALANCE		Alpha 1Determines whether transactions can be viewed on a daily basis.
  • Y Yes
  • N No
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-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.3, GL02.1, GL02.2, GL02.3, GL100
GDT-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.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-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.
  • D Debit
  • C Credit
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-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. " " = Sum Acct Default
  • Y Yes
  • N No
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-OBJ-ID
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.GL00.3, GL00.9, GL02.1, GL02.2, GL02.3, GL160
GDT-LEDGER-GROUP
LEDGER_GROUP		Alpha 15—GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-GL-BUD-FL
GL_BUD_FL		Alpha 1This is the Yes/No flag for budget editing. " " = Sum Acct Default
  • N No
  • Y Yes
GL00.3, GL02.1, GL02.2, GL02.3, GL100, GL160
GDT-GL-ACCT-TYPE
GL_ACCT_TYPE		Numeric 2—
  • 01 Asset
  • 02 Liability
  • 03 Equity
  • 04 Revenue
  • 05 Expense
  • 06 Statistical
GL00.3, GL100, GL160
GDT-XBRL-TAG-ID
XBRL_TAG_ID		Alpha 60—GL00.3, GL160
GDT-CREATED-BY
CREATED_BY		Alpha 10—GL00.3, GL00.9, GL02.1, GL02.2, GL02.3, GL160
GDT-LAST-UPDT-DATE
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—GL00.3, GL00.6, GL00.7, GL00.9, GL02.1, GL02.2, GL02.3, GL02.6 +4 more
GDT-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—GL00.3, GL00.6, GL00.7, GL00.9, GL02.1, GL02.2, GL02.3, GL02.6 +4 more
GDT-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—GL00.3, GL00.6, GL00.7, GL00.9, GL02.1, GL02.2, GL02.3, GL02.6 +4 more

Indexes (7)

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

IndexKeysFlagsConditionUsed in
GDTSET1CHART-NAME, SUMRY-ACCT-ID, ACCOUNT, SUB-ACCOUNTPrimaryAC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source)
GDTSET2CHART-NAME, ACCOUNT, SUB-ACCOUNTAC145, AC191, AC40.4, AC41.4, AC42.1, AC45.1, ACVW.1, ATVW.1 +22 more (list truncated in source)
GDTSET3CHART-NAME, CHART-SECTION, ACCOUNT, SUB-ACCOUNTKeyChangeGL146, GL194, GL197, GL199, GL215, GL40.1, GL40.2, GL40.3 +16 more
GDTSET4ACCOUNT, SUB-ACCOUNT, CHART-NAME, SUMRY-ACCT-IDAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GDTSET5RELATION, CHART-NAME, SUMRY-ACCT-ID, ACCOUNT, SUB-ACCOUNTKeyChangeSL02.2
GDTSET6OBJ-IDSubsetWhere OBJ-ID != ZeroesAC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GDTSET7LEDGER-GROUP, CHART-NAME, SUMRY-ACCT-ID, ACCOUNT, SUB-ACCOUNTKeyChange, SubsetWhere LEDGER-GROUP != SpacesML11.1

Relations

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Chart Of AcctsGLCHARTRequiredGDT-CHART-NAME → GCH-CHART-NAME
Currency CodeCUCODESNot RequiredGDT-CURRENCY-CODE → CUC-CURRENCY-CODE
GlchdtlbodGLCHDTLBODNot Required, Delete CascadesGDT-CHART-NAME → YCJ-CHART-NAME, GDT-SUMRY-ACCT-ID → YCJ-SUMRY-ACCT-ID, GDT-ACCOUNT → YCJ-ACCOUNT, GDT-SUB-ACCOUNT → YCJ-SUB-ACCOUNT
MxlisthdrMXLISTHDRNot Required"ACCTU" → MLH-OBJ-TYPE, GDT-DYNAMIC-LIST → MLH-MATRIX-LIST
Sumry AccountGLCHARTSUMRequiredGDT-CHART-NAME → GCS-CHART-NAME, GDT-SUMRY-ACCT-ID → GCS-SUMRY-ACCT-ID
Transl CodeTRCODESNot RequiredGDT-TRANSL-CODE → TRC-TRANSL-CODE

One to many (8) — child tables

RelationTableRulesConditionField map
ChartdtlauditGLCHTDTLAUGDT-CHART-NAME → GDA-CHART-NAME, GDT-ACCOUNT → GDA-ACCOUNT, GDT-SUB-ACCOUNT → GDA-SUB-ACCOUNT, → GDA-ACTION, → GDA-DATE, → GDA-TIME, → GDA-UNIQUE-I-D
Glacctvld DtlGLACCTVLDGDT-CHART-NAME → VLD-CHART-NAME, GDT-ACCOUNT → VLD-ACCOUNT, GDT-SUB-ACCOUNT → VLD-SUB-ACCOUNT, → VLD-SYSTEM
Glacctvld GlmGLACCTVLD"M" → VLD-RECORD-TYPE, Spaces → VLD-CHART-NAME, Zeroes → VLD-SUMRY-ACCT-ID, GDT-ACCOUNT → VLD-ACCOUNT, GDT-SUB-ACCOUNT → VLD-SUB-ACCOUNT, → VLD-COMPANY, → VLD-ACCT-UNIT, → VLD-SYSTEM
Glacctvld SumGLACCTVLD"S" → VLD-RECORD-TYPE, GDT-CHART-NAME → VLD-CHART-NAME, GDT-SUMRY-ACCT-ID → VLD-SUMRY-ACCT-ID, Zeroes → VLD-ACCOUNT, Zeroes → VLD-SUB-ACCOUNT, Zeroes → VLD-COMPANY, Spaces → VLD-ACCT-UNIT, → VLD-SYSTEM
Glacctvld SysGLACCTVLD"D" → VLD-RECORD-TYPE, GDT-CHART-NAME → VLD-CHART-NAME, GDT-SUMRY-ACCT-ID → VLD-SUMRY-ACCT-ID, GDT-ACCOUNT → VLD-ACCOUNT, GDT-SUB-ACCOUNT → VLD-SUB-ACCOUNT, Zeroes → VLD-COMPANY, Spaces → VLD-ACCT-UNIT, → VLD-SYSTEM
MxlistmbrMXLISTMBR"ACCTU" → MLM-OBJ-TYPE, GDT-DYNAMIC-LIST → MLM-MATRIX-LIST, → MLM-SEQ-NUMBER
Other ChartsGLCHARTDTLGDT-ACCOUNT → GDT-ACCOUNT, GDT-SUB-ACCOUNT → GDT-SUB-ACCOUNT, → GDT-CHART-NAME, → GDT-SUMRY-ACCT-ID
Posting AcctsGLMASTERGDT-CHART-NAME → GLM-CHART-NAME, GDT-ACCOUNT → GLM-ACCOUNT, GDT-SUB-ACCOUNT → GLM-SUB-ACCOUNT, → GLM-COMPANY, → GLM-ACCT-UNIT

Programs

Updated by (57)

Referenced by (572)