Lawson Insight Technical Documentation

                              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

AC298     AC720     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
Calendar Name        Required key. This is the name of the
                     calendar.

CDD-FISCAL-YEAR      Numeric 4                                   AC00.2
Fiscal Year          Required key. This is the fiscal year
                     for the calendar.

CDD-PERIOD           Numeric 2                                   AC00.2
Period               Required key. This is the fiscal period
                     for the calendar.

CDD-PER-END-DATE     Numeric 8  (yyyymmdd)                       AC00.2
Period End Date      This 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  AC298
          FISCAL-YEAR                                            AC720   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