ACCAL – Activity Calendar

System
Activity Management (AC)
Prefix
CDH
Primary key
CALENDAR-NAME, FISCAL-YEAR
Fields
4
Updated by
1 program
Referenced by
440 programs

ACCAL is the Activity Calendar table in Lawson Activity Management (prefix CDH). It is indexed by CALENDAR-NAME, FISCAL-YEAR (CDHSET1); alternate indexes: CDHSET2. It is related 1:1 to ACCALX and 1:M to ACCALX. It is updated by AC00.2 and referenced by AC108, AC120, AC121, AC123, AC127, AC130, AC131, AC145 and 432 more. The table has 4 fields, 2 indexes and 14 documented relations.

About ACCAL

This file contains calendar information from AC00.2 (Calendar Header). It includes the calendar name and description, as well as the fiscal year and periods.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
CDH-CALENDAR-NAME PK
CALENDAR_NAME		Alpha 12Required key. This is the name of the calendar.AC00.2
CDH-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Required key. This is the fiscal year for the calendar.AC00.2
CDH-NBR-PERIODS
NBR_PERIODS		Numeric 2This is the number of periods for the calendar fiscal year.AC00.2, AC527
CDH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the calendar description.AC00.1, AC00.2, AC70.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CDHSET1CALENDAR-NAME, FISCAL-YEARPrimaryAC00.1, AC00.2, AC108, AC120, AC121, AC123, AC127, AC130 +22 more (list truncated in source)
CDHSET2CALENDAR-NAME, FISCAL-YEAR*AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC45.4, AC46.1, AC540 +22 more (list truncated in source)

Relations

One to one (13) — lookups and parents

RelationTableRulesConditionField map
Caldetail 1ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 1 → CDD-PERIOD
Caldetail 10ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 10 → CDD-PERIOD
Caldetail 11ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 11 → CDD-PERIOD
Caldetail 12ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 12 → CDD-PERIOD
Caldetail 13ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 13 → CDD-PERIOD
Caldetail 2ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 2 → CDD-PERIOD
Caldetail 3ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 3 → CDD-PERIOD
Caldetail 4ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 4 → CDD-PERIOD
Caldetail 5ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 5 → CDD-PERIOD
Caldetail 6ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 6 → CDD-PERIOD
Caldetail 7ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 7 → CDD-PERIOD
Caldetail 8ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 8 → CDD-PERIOD
Caldetail 9ACCALXNot Required, Delete CascadesCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, 9 → CDD-PERIOD

One to many (1) — child tables

RelationTableRulesConditionField map
AccalxACCALXCDH-CALENDAR-NAME → CDD-CALENDAR-NAME, CDH-FISCAL-YEAR → CDD-FISCAL-YEAR, → CDD-PERIOD

Programs

Updated by (1)

Referenced by (440)