GLCHMPDTL – GL Intraco Chart Map Detail

System
General Ledger (GL)
Prefix
GHD
Primary key
CO-CHART, STAT-CHART, FR-ACCOUNT, FR-SUB-ACCT
Fields
6
Updated by
2 programs
Referenced by
7 programs

GLCHMPDTL is the GL Intraco Chart Map Detail table in Lawson General Ledger (prefix GHD). It is indexed by CO-CHART, STAT-CHART, FR-ACCOUNT, FR-SUB-ACCT (GHDSET1). It is updated by GL134 and GL34.1 and referenced by GL281, GL284, GL285, GL286, GL287, GL288 and GL289. The table has 6 fields, 1 index and 0 documented relations.

About GLCHMPDTL

This file maintains the detail records of each chart map created by GL134 (Intracompany Chart Map Posting) and maintained in GL34 (Intracompany Chart Map Maintenance). For each chart map, it maintains a map of Accounts and subaccounts for the Company chart to the Statutory chart. The Chart Map can then be used in the Grand Livre Reports.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
GHD-CO-CHART PK
CO_CHART
Alpha 12This is the company Chart of Accounts Name.GL134, GL34.1
GHD-STAT-CHART PK
STAT_CHART
Alpha 12This is the Statutory Chart of Accounts.GL134, GL34.1
GHD-FR-ACCOUNT PK
FR_ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.GL134, GL34.1
GHD-FR-SUB-ACCT PK
FR_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.GL134, GL34.1
GHD-TO-ACCOUNT
TO_ACCOUNT
Numeric 6This is the ending account for a range of accounts.GL134, GL34.1
GHD-TO-SUB-ACCT
TO_SUB_ACCT
Numeric 4This is the ending subaccount for a range of subaccounts.GL134, GL34.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
GHDSET1CO-CHART, STAT-CHART, FR-ACCOUNT, FR-SUB-ACCTPrimaryGL134, GL281, GL284, GL285, GL286, GL287, GL288, GL289 +1 more

Programs

Updated by (2)

Referenced by (7)