Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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