Lawson Insight Technical Documentation |
|
ACCALX
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
AC20.2 AC20.4 AC20.5 AC298 AC90.8 AC96.1
AC96.4 AC98.1 AC98.2 ACCL.1 SE90.1 BR96.1
AC10.6 AC110 AC120 AC50.2 AC502 AC54.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 AC20.2
FISCAL-YEAR AC20.4 AC20.5
PERIOD AC298 AC90.8
AC96.1 AC96.4
AC98.1 AC98.2
ACCL.1 SE90.1
BR96.1
CDDSET2 CALENDAR-NAME AC00.1 AC10.6
PER-END-DATE AC110 AC120
FISCAL-YEAR AC20.2 AC20.4
AC20.5 AC50.2
AC502 AC54.1
ACCL.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
|