GLPERIODMP – General Ledger Period Map
- System
- General Ledger (GL)
- Prefix
GPD- Primary key
FROM-COMPANY,TO-COMPANY,FR-FISCAL-YEAR,FR-PERIOD- Fields
- 7
- Updated by
- 2 programs
- Referenced by
- 0 programs
GLPERIODMP is the General Ledger Period Map table in Lawson General Ledger (prefix GPD). It is indexed by FROM-COMPANY, TO-COMPANY, FR-FISCAL-YEAR, FR-PERIOD (GPDSET1); alternate indexes: GPDSET2. It is updated by GL135 and GL36.1. The table has 7 fields, 2 indexes and 0 documented relations.
About GLPERIODMP
No description in the Lawson data dictionary.
Fields (7)
Column = COBOL field name without the GPD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
GPD-FROM-COMPANY PKFROM_COMPANY | Numeric 4 | This is the company that is to be included in the combined financial statements. | GL135, GL36.1 |
GPD-TO-COMPANY PKTO_COMPANY | Numeric 4 | This is the company number to which From Company balances are to be posted. | GL135, GL36.1 |
GPD-FR-FISCAL-YEAR PKFR_FISCAL_YEAR | Numeric 4 | The fiscal year of the From Company to be posted to the To Company. | GL135, GL36.1 |
GPD-TO-FISCAL-YEARTO_FISCAL_YEAR | Numeric 4 | The fiscal year of the To Company to which balances from the From Company fiscal year are to be posted. | GL135, GL36.1 |
GPD-FR-PERIOD PKFR_PERIOD | Numeric 2 | The period of the From Company to be posted to the To Company. | GL135, GL36.1 |
GPD-TO-PERIODTO_PERIOD | Numeric 2 | The period of the To Company to which balances from the From Company period are to be posted. | GL135, GL36.1 |
GPD-PERIOD-CODEPERIOD_CODE | Alpha 1 | The status of the From Company period: open or reported. | GL135 |
Indexes (2)
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 |
|---|---|---|---|---|
GPDSET1 | FROM-COMPANY, TO-COMPANY, FR-FISCAL-YEAR, FR-PERIOD | Primary | GL135, GL36.1 | |
GPDSET2 | TO-COMPANY, FROM-COMPANY, TO-FISCAL-YEAR, TO-PERIOD, FR-FISCAL-YEAR, FR-PERIOD | KeyChange | GL36.1 |