ACCALX

Activity Calendar Detail

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

REFERENCED BY
AC108 AC121 AC130 AC131 AC145 AC165
AC190 AC191 AC195 AC196 AC295 AC297
AC310 AC311 AC32.1 AC346 AC37.1 AC40.1
AC40.4 AC41.1 AC41.4 AC42.1 AC45.1 AC45.4
AC46.1 AC490 AC540 AC580 AC581 AC583
AC90.8 AC97.2 AC97.4 AC97.6 ACAC.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
ARLL.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 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 CB57.1
CB80.1 CB82.1 CX05.1 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 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 GL76.1 PR521 DR100 IC140 IC66.1
IC83.1 EX175 EX542 EX545 EXI2.1 EXI4.1
IFEB.1 IFGT.1 IFUC.1 LP130 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 PA182 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO135 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 POD0.1 POI3.1 POID.1 POIF.1 POIG.1
POII.1 POIJ.1 POIK.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 RQ10.1 RQ10.2
RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ500
RQD0.1 RQIF.1 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 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 AC127 AC21.2 AC21.3
AC21.4 AC21.5 AC22.1 AC27.1 AC47.1 AC47.2
AC65.1 AC65.2 AC96.1 AC96.4 ACCL.1 ACDL.1
BR65.1 BR65.2 BR65.3 BR96.1 SNAC.1 AC110
AC502 AC70.1


UPDATED BY
AC00.2 AC10.6 AC120 AC123 AC20.2 AC20.4
AC20.5 AC247 AC298 AC50.2 AC54.1 AC56.1
AC560 AC98.1 AC98.2

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDD-CALENDAR-NAME
Element: Calendar Name		Alpha 12
Required key. This is the name of the calendar.
AC00.2
CDD-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
Required key. This is the fiscal year for the calendar.
AC00.2
CDD-PERIOD
Element: Period		Numeric 2
Required key. This is the fiscal period for the calendar.
AC00.2
CDD-PER-END-DATE
Element: Period End Date		Numeric 8 (yyyymmdd)
This is the period end date for this fiscal period.
AC00.2


ACCALX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDDSET1 CALENDAR-NAME
FISCAL-YEAR
PERIOD
...
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 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
AC247 AC27.1
AC295 AC297
AC298 AC310
CDDSET2 CALENDAR-NAME
PER-END-DATE
FISCAL-YEAR
...
AC00.1 AC10.6
AC108 AC110
AC120 AC121
AC123 AC127
AC130 AC131
AC145 AC165
AC190 AC191
AC195 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
AC247 AC27.1
AC295 AC297


ACCALX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accal ACCAL Required
CDD-CALENDAR-NAME->CDH-CALENDAR-NAME
CDD-FISCAL-YEAR->CDH-FISCAL-YEAR

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

Home
Contact Us



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