GLCHMAPDTL – GL Interco Chart Map Detail
- System
- General Ledger (GL)
- Prefix
GMD- Primary key
FROM-COMPANY,TO-COMPANY,FR-ACCT-UNIT,FR-ACCOUNT,FR-SUB-ACCT- Fields
- 8
- Updated by
- 2 programs
- Referenced by
- 1 program
GLCHMAPDTL is the GL Interco Chart Map Detail table in Lawson General Ledger (prefix GMD). It is indexed by FROM-COMPANY, TO-COMPANY, FR-ACCT-UNIT, FR-ACCOUNT, FR-SUB-ACCT (GMDSET1). It is updated by GL130 and GL35.1 and referenced by GL135. The table has 8 fields, 1 index and 0 documented relations.
About GLCHMAPDTL
This file maintains the detail records of each chart map created by GL130 (Chart Map Creation) and fine-tuned by GL35.1 (Chart Map Maintenance). For each chart map, it maintains a map of account units, accounts and subaccounts from the From Company to the To Company. When you run GL135 (Intercompany Chart Map Posting), the posting account balances of the To Company are posted to the accounts recorded in this file as the corresponding accounts for the To Company.
Fields (8)
Column = COBOL field name without the GMD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GMD-FROM-COMPANY PKFROM_COMPANY | Numeric 4 | This is the company that is reported on. The Account balances from this company will be posted to accounts in the From Company, as mapped in the chart map for the two companies. | GL130, GL35.1 |
GMD-TO-COMPANY PKTO_COMPANY | Numeric 4 | This is the company to which the account balances of the From Company will be posted. | GL130, GL35.1 |
GMD-FR-ACCT-UNIT PKFR_ACCT_UNIT | Alpha 15 | This is an account unit in the From Company. The chart map must indicate what a corresponding account unit or account in the To Company that will receive the account unit balances from the From Company. | GL130, GL35.1 |
GMD-FR-ACCOUNT PKFR_ACCOUNT | Numeric 6 | This is an account within the account unit in the From Company. The chart map must specify a corresponding To Company account or subaccount where the From Company account balance amounts will be posted. | GL130, GL35.1 |
GMD-FR-SUB-ACCT PKFR_SUB_ACCT | Numeric 4 | This is a subaccount for an account unit and account in the From Company. The chart map must specify an account or subaccount in the To Company where the balances from this subaccount will be posted. | GL130, GL35.1 |
GMD-TO-ACCT-UNITTO_ACCT_UNIT | Alpha 15 | An account unit in the reporting company chart of account. You can specify what account unit (or units) in the From Company will post to this account unit. | GL130, GL35.1 |
GMD-TO-ACCOUNTTO_ACCOUNT | Numeric 6 | An account in the To Company chart of accounts. You can specify which account unit, account, or accounts from the From Company will post to this account. | GL130, GL35.1 |
GMD-TO-SUB-ACCTTO_SUB_ACCT | Numeric 4 | A subaccount in the To Company chart of Accounts. You can specify which account (accounts) or subaccount (subaccounts) from the From Company will be posted to this subaccount. | GL130, GL35.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
GMDSET1 | FROM-COMPANY, TO-COMPANY, FR-ACCT-UNIT, FR-ACCOUNT, FR-SUB-ACCT | Primary | GL130, GL135, GL35.1 |
Programs
Updated by (2)
Referenced by (1)
- GL135 Intercompany Chart Map Posting