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
AC295 AC298 AC90.2 AC90.4 AC90.6 AC90.8
AC95.2 AC95.4 AC95.6 AC96.1 AC97.2 AC97.4
AC97.6 AC98.1 AC98.2 ACCL.1 ACVW.1 SE90.1
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 AC295
FISCAL-YEAR AC298 AC90.2
PERIOD AC90.4 AC90.6
AC90.8 AC95.2
AC95.4 AC95.6
AC96.1 AC97.2
AC97.4 AC97.6
AC98.1 AC98.2
ACCL.1 ACVW.1
SE90.1
CDDSET2 CALENDAR-NAME AC00.1 AC54.1
PER-END-DATE ACCL.1
FISCAL-YEAR
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
|