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 defines the Period End Dates for Intrastat reporting periods.

UPDATED BY

IN08.1    IN120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

INL-COMPANY            Numeric 4                                 IN08.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

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: 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