Lawson Insight Technical Documentation |
|
ACCAL
ACCAL FILE
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
AC200 AC220 AC298 AC401 AC46.2 AC46.1
AC480 AC90.1 AC90.2 AC90.4 AC90.6 AC90.8
AC92.1 AC92.2 AC92.4 AC92.6 AC94.1 AC94.2
AC94.4 AC94.6 AC95.1 AC95.2 AC95.4 AC95.6
AC96.1 AC96.4 AC98.1 ACCL.1 ACDR.1 SE90.1
BR96.1 AC40.1 AC40.4 AC41.1 AC41.4 AC42.1
ACAC.1 AP125 AP126 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP520 BR41.1 BR41.4 BR43.1
CB10.1 CB15.1 CB15.2 CB191 CB20.1 CB30.1
CB500 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
MA65.1
UPDATED BY
AC00.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CDH-CALENDAR-NAME Alpha 12 AC00.2
Element: Calendar Name Required key. This is the name of the
calendar.
CDH-FISCAL-YEAR Numeric 4 AC00.2
Element: Fiscal Year Required key. This is the fiscal year
for the calendar.
CDH-NBR-PERIODS Numeric 2 AC00.2
Element: Number of PeriThis is the number of periods for the
calendar fiscal year.
CDH-DESCRIPTION Alpha 30 (Lower Case) AC00.1 AC00.2
Element: Calendar DescrThis is the calendar description.
ACCAL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDHSET1 CALENDAR-NAME AC00.1 AC00.2
FISCAL-YEAR AC200 AC220
AC298 AC401
AC46.2 AC480
AC90.1 AC90.2
AC90.4 AC90.6
AC90.8 AC92.1
AC92.2 AC92.4
AC92.6 AC94.1
AC94.2 AC94.4
AC94.6 AC95.1
AC95.2 AC95.4
AC95.6 AC96.1
AC96.4 AC98.1
ACCL.1 ACDR.1
...
CDHSET2 CALENDAR-NAME AC40.1 AC40.4
FISCAL-YEAR* AC41.1 AC41.4
AC42.1 AC46.1
ACAC.1 AP125
AP126 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP520 BR41.1
BR41.4 BR43.1
CB10.1 CB15.1
CB15.2 CB191
CB20.1 CB30.1
CB500 EE135
EE20.3 EE35.1
EE35.2 EE520
...
ACCAL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accalx ACCALX
CDH-CALENDAR-NAME -> CDD-CALENDAR-NAME
CDH-FISCAL-YEAR -> CDD-FISCAL-YEAR
CDD-PERIOD
|