|
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
AC108 AC120 AC121 AC123 AC127 AC130
AC131 AC145 AC165 AC190 AC191 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC200 AC21.2
AC21.3 AC21.4 AC22.1 AC220 AC27.1 AC295
AC298 AC310 AC32.1 AC346 AC37.1 AC40.1
AC40.4 AC401 AC41.1 AC41.4 AC42.1 AC45.1
AC45.4 AC46.1 AC46.2 AC480 AC490 AC527
AC540 AC580 AC581 AC583 AC65.1 AC65.2
AC70.1 AC90.1 AC90.2 AC90.4 AC90.6 AC90.8
AC92.1 AC92.2 AC92.4 AC92.6 AC95.1 AC95.2
AC95.4 AC95.6 AC96.1 AC96.4 AC98.1 AC98.2
ACAC.1 ACCL.1 ACDL.1 ACDR.1 SE90.1 AP125
AP126 AP131 AP170 AP190 AP193 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP520 API1.1 API2.1 AR115 AR124
AR190 AR20.1 AR21.1 AR21.2 AR21.3 AR24.1
AR29.2 AR30.1 AR32.1 AR34.1 AR42.1 AR42.2
AR42.7 AR43.1 AR560 AR570 AR575 AR580
ARLL.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 BN150 BN66.1 BR124 BR130 BR131
BR140 BR153 BR154 BR165 BR41.1 BR41.4
BR43.1 BR430 BR44.1 BR46.1 BR46.2 BR46.4
BR530 BR65.1 BR65.2 BR65.3 BR96.1 BRIP.1
CB10.1 CB15.1 CB15.2 CB150 CB180 CB191
CB20.1 CB30.1 CB45.1 CB46.1 CB500 CB543
CB544 CB55.1 CB554 CB80.1 CB82.1 CXCP.1
EE135 EE20.3 EE35.1 EE35.2 EE520 ET175
ET530 ET540 ET542 ETI2.1 GL146 GL165
GL170 GL197 GL199 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL70.1 GL70.2
GL70.3 GL70.5 GL70.6 GL75.1 IFGT.1 LP130
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA65.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PA182 PD10.1 PD10.2
PD130 PD20.1 PD20.2 PD20.3 PO100 PO101
PO122 PO131 PO135 PO150 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO32.4 PO33.1 PO34.1
PO35.1 PO36.1 PO36.2 PO38.1 PO39.1 PO39.2
PO44.1 PO50.1 PO52.1 PO520 PO536 POCP.1
POD0.1 POI3.1 POID.1 POIF.1 POIG.1 POII.1
POIJ.1 PR128 PR130 PR131 PR132 PR134
PR136 PR137 PR140 PR189 PR195 PR197
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR37.1 PR38.1 PR45.1
PR529 PR530 PR560 PR80.1 PR82.1 PR85.1
PR89.1 UK102 UK330 UK560 RQ10.1 RQ10.2
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500 RQD0.1
RQIF.1 SB15.1 SB515 TA147 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH30.1 WH30.2
WH30.3 WH30.4 WH31.1 WH31.2 WH31.3 WH31.4
WH32.1 WH32.2 WH32.3 WH32.4 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
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 AC527
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. AC70.1
ACCAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDHSET1 CALENDAR-NAME AC00.1 AC00.2
FISCAL-YEAR AC108 AC120
AC121 AC123
AC127 AC130
AC131 AC145
AC165 AC190
AC191 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC21.2
AC21.3 AC21.4
AC22.1 AC220
AC27.1 AC295
AC298 AC310
AC32.1 AC346
...
CDHSET2 CALENDAR-NAME AC40.1 AC40.4
FISCAL-YEAR* AC41.1 AC41.4
AC42.1 AC45.4
AC46.1 ACAC.1
AP125 AP126
AP170 AP193
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
BR41.1 BR41.4
BR43.1 CB10.1
CB15.1 CB15.2
CB150 CB191
CB20.1 CB30.1
CB45.1 CB46.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
|