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

AC108     AC120     AC121     AC123     AC127     AC130
AC131     AC145     AC165     AC190     AC191     AC20.1
AC20.2    AC20.3    AC20.4    AC20.5    AC21.2    AC21.3
AC21.4    AC22.1    AC27.1    AC295     AC298     AC310
AC32.1    AC346     AC37.1    AC40.1    AC40.4    AC41.1
AC41.4    AC42.1    AC45.1    AC45.4    AC46.1    AC490
AC540     AC580     AC581     AC583     AC65.1    AC65.2
AC90.8    AC96.1    AC96.4    AC98.1    AC98.2    ACAC.1
ACCL.1    ACDL.1    ACDR.1    SE90.1    AP125     AP126
AP131     AP170     AP190     AP193     AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.7    AP21.1    AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP520     API1.1    API2.1    AR115     AR124     AR190
AR20.1    AR21.1    AR21.2    AR21.3    AR24.1    AR29.2
AR30.1    AR32.1    AR34.1    AR42.1    AR42.2    AR42.7
AR43.1    AR560     AR570     AR575     AR580     ARLL.1
BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
BN150     BN66.1    BR124     BR130     BR131     BR140
BR153     BR154     BR165     BR41.1    BR41.4    BR43.1
BR430     BR44.1    BR46.1    BR46.2    BR46.4    BR530
BR65.1    BR65.2    BR65.3    BR96.1    BRIP.1    CB10.1
CB15.1    CB15.2    CB150     CB180     CB191     CB20.1
CB30.1    CB45.1    CB46.1    CB500     CB543     CB544
CB55.1    CB554     CB80.1    CB82.1    CXCP.1    EE135
EE20.3    EE35.1    EE35.2    EE520     ET175     ET530
ET540     ET542     ETI2.1    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    IFGT.1    LP130     MA180
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA65.1    MA66.2    MA66.3    MA67.2
MA67.3    MA68.2    MA68.3    MA68.5    MA70.1    MA75.1
MA80.1    MAI1.1    PA182     PD10.1    PD10.2    PD130
PD20.1    PD20.2    PD20.3    PO100     PO101     PO122
PO131     PO135     PO150     PO190     PO20.1    PO21.1
PO21.2    PO21.3    PO21.4    PO21.5    PO22.1    PO23.1
PO24.1    PO25.1    PO25.5    PO25.6    PO25.7    PO27.2
PO29.1    PO30.1    PO30.2    PO30.3    PO300     PO31.1
PO31.2    PO32.2    PO32.4    PO33.1    PO34.1    PO35.1
PO36.1    PO36.2    PO38.1    PO39.1    PO39.2    PO44.1
PO50.1    PO52.1    PO520     PO536     POCP.1    POD0.1
POI3.1    POID.1    POIF.1    POIG.1    POII.1    POIJ.1
PR128     PR130     PR131     PR132     PR134     PR136
PR137     PR140     PR189     PR195     PR197     PR29.1
PR32.1    PR32.2    PR33.1    PR33.2    PR33.3    PR35.1
PR35.2    PR35.3    PR35.4    PR35.5    PR35.6    PR35.8
PR35.9    PR36.1    PR37.1    PR38.1    PR45.1    PR529
PR530     PR560     PR80.1    PR82.1    PR85.1    PR89.1
UK102     UK330     UK560     RQ10.1    RQ10.2    RQ12.1
RQ13.1    RQ13.2    RQ35.1    RQ500     RQD0.1    RQIF.1
SB15.1    SB515     SNAC.1    TA147     WH130     WH132
WH190     WH20.2    WH20.7    WH222     WH30.1    WH30.2
WH30.3    WH30.4    WH31.1    WH31.2    WH31.3    WH31.4
WH32.1    WH32.2    WH32.3    WH32.4    WH33.1    WH33.2
WH33.3    WH33.4    WH33.5    WH33.6    WH33.8    WH33.9
WH34.1    WH34.2    WH34.3    WH34.4    WH40.1    WH40.2
WH520     WH830     AC10.6    AC110     AC50.2    AC502
AC54.1    AC56.1    AC560     AC70.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  AC108
          FISCAL-YEAR                                            AC120   AC121
          PERIOD                                                 AC123   AC127
                                                                 AC130   AC131
                                                                 AC145   AC165
                                                                 AC190   AC191
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC21.2
                                                                 AC21.3  AC21.4
                                                                 AC22.1  AC27.1
                                                                 AC295   AC298
                                                                 AC310   AC32.1
                                                                 AC346   AC37.1
                                                                 AC40.1  AC40.4
                                                                 ...

CDDSET2   CALENDAR-NAME                                          AC00.1  AC10.6
          PER-END-DATE                                           AC108   AC110
          FISCAL-YEAR                                            AC120   AC121
                                                                 AC123   AC127
                                                                 AC130   AC131
                                                                 AC145   AC165
                                                                 AC190   AC191
                                                                 AC20.1  AC20.2
                                                                 AC20.3  AC20.4
                                                                 AC20.5  AC21.2
                                                                 AC21.3  AC21.4
                                                                 AC22.1  AC27.1
                                                                 AC295   AC298
                                                                 AC310   AC32.1
                                                                 AC346   AC37.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