|
ACCALX FILE
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 AC120 AC121 AC123 AC127 AC130
AC131 AC145 AC165 AC190 AC191 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC21.2 AC21.3
AC21.4 AC22.1 AC27.1 AC295 AC298 AC310
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 AC65.1 AC65.2
AC90.8 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 SNAC.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 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 AC10.6 AC110 AC50.2 AC502
AC54.1 AC56.1 AC560 AC70.1
UPDATED BY
AC00.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDD-CALENDAR-NAME Alpha 12 AC00.2
Element: Calendar Name Required key. This is the name of the
calendar.
CDD-FISCAL-YEAR Numeric 4 AC00.2
Element: Fiscal Year Required key. This is the fiscal year
for the calendar.
CDD-PERIOD Numeric 2 AC00.2
Element: Period Required key. This is the fiscal period
for the calendar.
CDD-PER-END-DATE Numeric 8 (yyyymmdd) AC00.2
Element: Period End DatThis is the period end date for this
fiscal period.
ACCALX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDDSET1 CALENDAR-NAME AC00.2 AC108
FISCAL-YEAR AC120 AC121
PERIOD AC123 AC127
AC130 AC131
AC145 AC165
AC190 AC191
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC21.2
AC21.3 AC21.4
AC22.1 AC27.1
AC295 AC298
AC310 AC32.1
AC346 AC37.1
AC40.1 AC40.4
...
CDDSET2 CALENDAR-NAME AC00.1 AC10.6
PER-END-DATE AC108 AC110
FISCAL-YEAR AC120 AC121
AC123 AC127
AC130 AC131
AC145 AC165
AC190 AC191
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC21.2
AC21.3 AC21.4
AC22.1 AC27.1
AC295 AC298
AC310 AC32.1
AC346 AC37.1
...
ACCALX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accal ACCAL Required
CDD-CALENDAR-NAME -> CDH-CALENDAR-NAME
CDD-FISCAL-YEAR -> CDH-FISCAL-YEAR
|