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
ACAC.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
BN150 BN66.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 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 PR521 EX175 EX542 EX545 EXI2.1
EXI4.1 IFEB.1 IFGT.1 IFUC.1 LP130 LP140
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PA182
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POIF.1 POIG.1 POII.1 POIJ.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 SNAC.1 TA147


UPDATED BY
AC00.2 AC00.1 AC10.6

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 ACAC.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 BN150
BN66.1 CB10.1
CB15.1 CB15.2
CDDSET2 CALENDAR-NAME
PER-END-DATE
FISCAL-YEAR
...
AC00.1 AC10.6
ACAC.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
BN150 BN66.1
CB10.1 CB15.1


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: Wed Jun 08 20:46:54 2016

Home
Contact Us



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