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

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 SET3
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 SET5
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 SET6
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 SET7
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 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
GDTSET1
  1. CHART-NAME
  2. SUMRY-ACCT-ID
  3. ACCOUNT
  4. SUB-ACCOUNT
PrimaryAC121, AC123, AC130, AC191, AC20.1, AC20.2, AC20.3, AC20.4 +22 more (list truncated in source)
GDTSET2
  1. CHART-NAME
  2. ACCOUNT
  3. SUB-ACCOUNT
AC145, AC191, AC40.4, AC41.4, AC42.1, AC45.1, ACVW.1, ATVW.1 +22 more (list truncated in source)
GDTSET3
  1. CHART-NAME
  2. CHART-SECTION
  3. ACCOUNT
  4. SUB-ACCOUNT
KeyChangeGL146, GL194, GL197, GL199, GL215, GL40.1, GL40.2, GL40.3 +16 more
GDTSET4
  1. ACCOUNT
  2. SUB-ACCOUNT
  3. CHART-NAME
  4. SUMRY-ACCT-ID
AC121, AC123, AC130, AC20.1, AC20.2, AC20.3, AC20.4, AC20.5 +22 more (list truncated in source)
GDTSET5
  1. RELATION
  2. CHART-NAME
  3. SUMRY-ACCT-ID
  4. ACCOUNT
  5. SUB-ACCOUNT
KeyChangeSL02.2
GDTSET6
  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)
GDTSET7
  1. LEDGER-GROUP
  2. CHART-NAME
  3. SUMRY-ACCT-ID
  4. ACCOUNT
  5. SUB-ACCOUNT
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)
GLCHARTCUCODESGLCHDTLBODMXLISTHDRGLCHARTSUMTRCODESGLCHTDTLAUGLACCTVLDMXLISTMBRGLCHARTDTLGLMASTERGLCHARTDTL

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Chart Of AcctsGLCHARTRequired
GDT-CHART-NAME→GCH-CHART-NAME
Currency CodeCUCODESNot Required
GDT-CURRENCY-CODE→CUC-CURRENCY-CODE
GlchdtlbodGLCHDTLBODNot Required, Delete Cascades
GDT-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 AccountGLCHARTSUMRequired
GDT-CHART-NAME→GCS-CHART-NAME
GDT-SUMRY-ACCT-ID→GCS-SUMRY-ACCT-ID
Transl CodeTRCODESNot Required
GDT-TRANSL-CODE→TRC-TRANSL-CODE

One to many (8) — child tables

RelationTableRulesConditionField map
ChartdtlauditGLCHTDTLAU
GDT-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 DtlGLACCTVLD
GDT-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 ChartsGLCHARTDTL
GDT-ACCOUNT→GDT-ACCOUNT
GDT-SUB-ACCOUNT→GDT-SUB-ACCOUNT
—→GDT-CHART-NAME
—→GDT-SUMRY-ACCT-ID
Posting AcctsGLMASTER
GDT-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)