ACCAL

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 AC130 AC131
AC145 AC165 AC190 AC191 AC195 AC196
AC20.1 AC20.2 AC20.3 AC20.4 AC20.5 AC247
AC295 AC297 AC298 AC310 AC311 AC32.1
AC346 AC37.1 AC480 AC490 AC540 AC580
AC581 AC583 AC97.2 AC97.4 AC97.6 AC98.1
AC98.2 SE90.1 AP190 ARLL.1 BN150 BN66.1
BR124 BR130 BR131 BR140 BR153 BR154
BR165 BR430 BR44.1 BR46.1 BR46.2 BR46.4
BR530 BRIP.1 CB180 CB57.1 CB80.1 CB82.1
CX05.1 GL199 PR521 EX175 EX542 EXI2.1
EXI4.1 IFGT.1 IFUC.1 LP130 PA182 PO135
POD0.1 POIF.1 PR128 PR130 PR131 PR132
PR134 PR135 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 PR582
PR80.1 PR80.4 PR82.1 PR85.1 PR89.1 UK102
UK330 UK560 ZP530 RQD0.1 TA147 AC127
AC21.2 AC21.3 AC21.4 AC21.5 AC22.1 AC27.1
AC47.1 AC47.2 AC65.1 AC65.2 AC70.1 AC96.1
AC96.4 ACCL.1 ACDL.1 BR65.1 BR65.2 BR65.3
BR96.1


UPDATED BY
AC00.2 AC200 AC220 AC40.1 AC40.4 AC401
AC41.1 AC41.4 AC42.1 AC45.4 AC46.1 AC527
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 ACAC.1 ACDR.1 AP125 AP126 AP131
AP170 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 BR41.1 BR41.4 BR43.1 CB10.1 CB15.1
CB15.2 CB150 CB191 CB20.1 CB30.1 CB45.1
CB46.1 CB500 CB543 CB544 CB55.1 CB554
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 EE11.1 EE135
EE20.3 EE35.1 EE35.2 EE520 GL146 GL165
GL170 GL197 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 GL76.1 DR100 IC140
IC66.1 IC83.1 EX545 IFEB.1 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA42.2 MA43.2 MA43.7
MA44.1 MA44.2 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO136
PO150 PO190 PO20.1 PO20.6 PO20.9 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO22.3
PO22.4 PO23.1 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO28.2 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 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 PO54.5 POCP.1 POI3.1
POID.1 POIG.1 POII.1 POIJ.1 POIK.1 RQ10.1
RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIF.1 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 WH32.5 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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDH-CALENDAR-NAME
Element: Calendar Name		Alpha 12
Required key. This is the name of the calendar.
AC00.2
CDH-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
Required key. This is the fiscal year for the calendar.
AC00.2
CDH-NBR-PERIODS
Element: Number of Periods		Numeric 2
This is the number of periods for the calendar fiscal year.
AC00.2 AC527
CDH-DESCRIPTION
Element: Calendar Description		Alpha 30 (Lower Case)
This is the calendar description.
AC00.1 AC00.2
AC70.1


ACCAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDHSET1 CALENDAR-NAME
FISCAL-YEAR
...
AC00.1 AC00.2
AC108 AC120
AC121 AC123
AC127 AC130
AC131 AC145
AC165 AC190
AC191 AC195
AC196 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
AC220 AC247
AC27.1 AC295
CDHSET2 CALENDAR-NAME
FISCAL-YEAR*
...
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.4
AC46.1 ACAC.1
AP125 AP126
AP131 AP170
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


ACCAL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accalx ACCALX
CDH-CALENDAR-NAME->CDD-CALENDAR-NAME
CDH-FISCAL-YEAR->CDD-FISCAL-YEAR
  CDD-PERIOD

File created: Thu Jun 09 11:03:55 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.