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
AP190 BN150 BN66.1 CB180 CB80.1 CB82.1
GL199 PR521 EX175 EX542 EXI2.1 EXI4.1
IFGT.1 IFUC.1 LP130 LP140 PA182 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
TA147


UPDATED BY
AC00.2 AC00.1 AC200 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 CB10.1 CB15.1 CB15.2 CB150
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 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 EX545 IFEB.1 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MAI1.1 PO136 PO190
PO300 PO520 POCP.1 POI3.1 POIG.1 POII.1
POIJ.1

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
CDH-DESCRIPTION
Element: Calendar Description		Alpha 30 (Lower Case)
This is the calendar description.
AC00.1 AC00.2


ACCAL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDHSET1 CALENDAR-NAME
FISCAL-YEAR
...
AC00.1 AC00.2
AC200 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
CDHSET2 CALENDAR-NAME
FISCAL-YEAR*
...
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 CB10.1
CB15.1 CB15.2
CB150 CB191
CB20.1 CB30.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: Wed Jun 08 20:46:54 2016

Home
Contact Us



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