Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

INCALENDAR


                            INCALENDAR FILE

                           Intrastat Calendar

This file maintains Intrastat calendar information.

UPDATED BY

IN08.1    IN120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

INL-COMPANY            Numeric 4                                 IN08.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

INL-TAX-YEAR           Numeric 4                                 IN08.1
Element: Tax Year      The tax year for which the calendar was
                       defined.

INL-TAX-PERIOD         Numeric 2                                 IN08.1
Element: Tax Period    The tax period of the specified year.

INL-PER-END-DATE       Numeric 8  (yyyymmdd)                     IN08.1
Element: Per End Date  Identifies period end date in
                       distribution record; used during PR198
                       to relieve salary encumbrance
                       commitments for pay period (updated from
                       TIMERECORD.PER-END-DATE).

INL-PER-NAME           Alpha 15  (Lower Case)                    IN08.1
Element: Per Name      The period name.

INL-STATUS             Numeric 1                                 IN08.1  IN120
Element: Status        This field displays the status of the
                       transaction.
                       1 = Open
                       2 = Reported

                         INCALENDAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INLSET1   COMPANY                                                IN08.1  IN120
          TAX-YEAR
          TAX-PERIOD

INLSET2   COMPANY       Subset                                   IN120
          TAX-YEAR      Where STATUS = 1
          TAX-PERIOD

INLSET3   COMPANY       Subset                                   IN120
          TAX-YEAR      Where STATUS = 2
          TAX-PERIOD