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

Field / columnTypeDescription & valuesUpdated by
#GPD-FROM-COMPANY PK
FROM_COMPANY		Numeric 4This is the company that is to be included in the combined financial statements.GL135, GL36.1
#GPD-TO-COMPANY PK
TO_COMPANY		Numeric 4This is the company number to which From Company balances are to be posted.GL135, GL36.1
#GPD-FR-FISCAL-YEAR PK
FR_FISCAL_YEAR		Numeric 4The fiscal year of the From Company to be posted to the To Company.GL135, GL36.1
#GPD-TO-FISCAL-YEAR SET2
TO_FISCAL_YEAR		Numeric 4The 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 PK
FR_PERIOD		Numeric 2The period of the From Company to be posted to the To Company.GL135, GL36.1
#GPD-TO-PERIOD SET2
TO_PERIOD		Numeric 2The period of the To Company to which balances from the From Company period are to be posted.GL135, GL36.1
#GPD-PERIOD-CODE
PERIOD_CODE		Alpha 1The status of the From Company period: open or reported.GL135

Indexes (2)

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
GPDSET1
  1. FROM-COMPANY
  2. TO-COMPANY
  3. FR-FISCAL-YEAR
  4. FR-PERIOD
PrimaryGL135, GL36.1
GPDSET2
  1. TO-COMPANY
  2. FROM-COMPANY
  3. TO-FISCAL-YEAR
  4. TO-PERIOD
  5. FR-FISCAL-YEAR
  6. FR-PERIOD
KeyChangeGL36.1

Programs

Updated by (2)