|
|
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
AC120 AC121 AC123 AC127 AC130 AC160
AC165 AC170 AC190 AC191 AC20.1 AC20.2
AC20.3 AC20.4 AC200 AC21.1 AC21.2 AC21.3
AC22.1 AC27.1 AC295 AC297 AC30.2 AC30.3
AC310 AC32.1 AC40.1 AC401 AC41.1 AC42.1
AC470 AC480 AC530 AC580 AC65.1 AC65.2
AC90.1 AC90.2 AC95.1 AC95.2 AC96.1 AC97.1
AC97.2 AC980 ACAC.1 ACDL.1 AP125 AP126
AP170 AP193 AP225 AP226 AP25.1 AP25.2
AP26.1 AP30.2 AP30.4 AP32.2 AP520 AP981
AR115 AR124 AR190 AR20.1 AR21.1 AR21.2
AR21.3 AR24.1 AR29.2 AR30.1 AR30.2 AR30.4
AR42.1 AR42.2 AR42.7 AR43.1 AR560 AR570
AR575 AR580 BL120 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 BL940 BN150 CB10.1 CB180 CB191
CB20.1 CB30.1 CB80.1 CB980 EE135 EE35.1
EE35.2 EE520 GL199 DR100 IC130 IC141
IC142 IC83.1 IFGT.1 IN20.1 MA40.1 MA41.4
MA41.6 MA43.3 MA43.4 MA520 MA530 MA540
OE10.1 OE10.2 OE10.3 OE10.4 OE10.5 OE10.6
OE10.7 OE10.8 OE11.1 OE11.4 OE11.8 OE11.9
OE110 OE113 OE114 OE129 OE14.4 OE15.1
OE15.2 OE15.3 OE15.4 OE15.5 OE15.7 OE30.1
OE30.2 OE30.3 OE30.4 OE30.5 OE30.6 OE30.7
OE30.9 OE510 OE810 OE830 OE920 OE950
PO100 PO135 PO180 PO20.1 PO21.1 PO21.2
PO21.3 PO21.5 PO21.6 PO22.1 PO22.2 PO22.3
PO25.1 PO25.2 PO25.4 PO26.1 PO28.6 PO30.1
PO31.1 PO32.1 PO33.1 PO34.1 PO35.1 PO530
PO821 PO990 PR128 PR131 PR132 PR134
PR136 PR137 PR140 PR150 PR195 PR199
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR36.1 PR37.1 PR38.1 PR45.1 PR530 PR80.1
PR82.1 PR85.1 PRSA.1 UK102 UK330 RQ10.1
RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1 RQ20.1
RQ20.3 RQ20.4 RQ35.1 RQ500 RQ990 UK120
WH130 WH132 WH190 WH20.2 WH20.7 WH30.1
WH30.2 WH30.3 WH31.1 WH31.2 WH31.3 WH32.1
WH32.2 WH32.3 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
WO132 WO140
UPDATED BY
AC00.2 AC730
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDH-CALENDAR-NAME Alpha 12 AC00.2 AC730
Calendar Name Required key. This is the name of the
calendar.
CDH-FISCAL-YEAR Numeric 4 AC00.2 AC730
Fiscal Year Required key. This is the fiscal year
for the calendar.
CDH-NBR-PERIODS Numeric 2 AC00.2 AC730
Number of Periods This is the number of periods for the
calendar fiscal year.
CDH-DESCRIPTION Alpha 30 (Lower Case) AC00.1 AC00.2
Calendar Description This is the calendar description. AC730
ACCAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDHSET1 CALENDAR-NAME AC00.1 AC00.2
FISCAL-YEAR AC120 AC121
AC123 AC127
AC130 AC160
AC165 AC170
AC190 AC191
AC20.1 AC20.2
AC20.3 AC20.4
AC200 AC21.1
AC21.2 AC21.3
AC22.1 AC27.1
AC295 AC297
AC30.2 AC30.3
AC310 AC32.1
AC40.1 AC401
...
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
|