ACCALX – Activity Calendar Detail

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

ACCALX is the Activity Calendar Detail table in Lawson Activity Management (prefix CDD). It is indexed by CALENDAR-NAME, FISCAL-YEAR, PERIOD (CDDSET1); alternate indexes: CDDSET2. It is related 1:1 to ACCAL and CDDBOD. It is updated by AC00.2 and referenced by AC02.1, AC05.2, AC05.3, AC08.1, AC08.2, AC08.3, AC08.4, AC08.5 and 434 more. The table has 4 fields, 2 indexes and 2 documented relations.

About ACCALX

This file contains detailed calendar information from AC00.2 (Calendar). It includes calendar name, fiscal year, period, and period end date.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
CDD-CALENDAR-NAME PK
CALENDAR_NAME		Alpha 12Required key. This is the name of the calendar.AC00.2
CDD-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Required key. This is the fiscal year for the calendar.AC00.2
CDD-PERIOD PK
PERIOD		Numeric 2Required key. This is the fiscal period for the calendar.AC00.2
CDD-PER-END-DATE
PER_END_DATE		Numeric 8 (yyyymmdd)This is the period end date for this fiscal period.AC00.2

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CDDSET1CALENDAR-NAME, FISCAL-YEAR, PERIODPrimaryAC00.1, AC00.2, AC00.3, AC02.1, AC05.2, AC05.3, AC08.1, AC08.2 +22 more (list truncated in source)
CDDSET2CALENDAR-NAME, PER-END-DATE, FISCAL-YEARAC00.1, AC10.6, AC108, AC110, AC120, AC121, AC123, AC127 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AccalACCALRequiredCDD-CALENDAR-NAME → CDH-CALENDAR-NAME, CDD-FISCAL-YEAR → CDH-FISCAL-YEAR
CddbodCDDBODRequiredCDD-CALENDAR-NAME → CFB-CALENDAR-NAME, CDD-FISCAL-YEAR → CFB-FISCAL-YEAR, CDD-PERIOD → CFB-PERIOD

Programs

Updated by (1)

Referenced by (442)