|
|
ACCAL FILE
Activity Calendar
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.
REFERENCED BY
AC200 AC295 AC298 AC401 AC480 AC90.1
AC90.2 AC90.4 AC90.6 AC90.8 AC92.1 AC92.2
AC92.4 AC92.6 AC94.1 AC94.2 AC94.4 AC94.6
AC95.1 AC95.2 AC95.4 AC95.6 AC96.1 AC97.2
AC97.4 AC97.6 AC98.1 ACCL.1 ACVW.1 SE90.1
UPDATED BY
AC00.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDH-CALENDAR-NAME Alpha 12 AC00.2
Element: Calendar Name Required key. This is the name of the
calendar.
CDH-FISCAL-YEAR Numeric 4 AC00.2
Element: Fiscal Year Required key. This is the fiscal year
for the calendar.
CDH-NBR-PERIODS Numeric 2 AC00.2
Element: Number of PeriThis is the number of periods for the
calendar fiscal year.
CDH-DESCRIPTION Alpha 30 (Lower Case) AC00.1 AC00.2
Element: Calendar DescrThis is the calendar description.
ACCAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDHSET1 CALENDAR-NAME AC00.1 AC00.2
FISCAL-YEAR AC200 AC295
AC298 AC401
AC480 AC90.1
AC90.2 AC90.4
AC90.6 AC90.8
AC92.1 AC92.2
AC92.4 AC92.6
AC94.1 AC94.2
AC94.4 AC94.6
AC95.1 AC95.2
AC95.4 AC95.6
AC96.1 AC97.2
AC97.4 AC97.6
AC98.1 ACCL.1
...
ACCAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Caldetail 1 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
1 -> CDD-PERIOD
Caldetail 10 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
10 -> CDD-PERIOD
Caldetail 11 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
11 -> CDD-PERIOD
Caldetail 12 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
12 -> CDD-PERIOD
Caldetail 13 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
13 -> CDD-PERIOD
Caldetail 2 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
2 -> CDD-PERIOD
Caldetail 3 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
3 -> CDD-PERIOD
Caldetail 4 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
4 -> CDD-PERIOD
Caldetail 5 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
5 -> CDD-PERIOD
Caldetail 6 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
6 -> CDD-PERIOD
Caldetail 7 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
7 -> CDD-PERIOD
Caldetail 8 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
8 -> CDD-PERIOD
Caldetail 9 ACCALX Not Required, Delete Cascades
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
9 -> CDD-PERIOD
ACCAL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accalx ACCALX
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
CDD-PERIOD
|
