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

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 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
CDHSET1
  1. CALENDAR-NAME
  2. FISCAL-YEAR
PrimaryAC00.1, AC00.2, AC108, AC120, AC121, AC123, AC127, AC130 +22 more (list truncated in source)
CDHSET2
  1. CALENDAR-NAME
  2. FISCAL-YEAR ↓
AC40.1, AC40.4, AC41.1, AC41.4, AC42.1, AC45.4, AC46.1, AC540 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ACCALXACCALXACCAL

One to one (13) — lookups and parents

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

One to many (1) — child tables

RelationTableRulesConditionField map
AccalxACCALX
CDH-CALENDAR-NAME→CDD-CALENDAR-NAME
CDH-FISCAL-YEAR→CDD-FISCAL-YEAR
—→CDD-PERIOD

Programs

Updated by (1)

Referenced by (440)