Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            INCALENDAR FILE

This file maintains Intrastat calendar information.

UPDATED BY

IN08.1    IN120

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

INL-TAX-PERIOD       Numeric 2                                   IN08.1
Tax Period

INL-PER-END-DATE     Numeric 8  (yyyymmdd)                       IN08.1
Period End Date

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

INL-STATUS           Numeric 1                                   IN08.1  IN120
Status               The status of the reporting period:

                     1 - Open
                     2 - Reported

                         INCALENDAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

INLSET1   COMPANY       Used to access an Intrastat calendar     IN08.1  IN120
          TAX-YEAR      year for a company.
          TAX-PERIOD

INLSET2   COMPANY       Used to access a company's Intrastat     IN120
          TAX-YEAR      calendar periods with a status of 1
          TAX-PERIOD    (Open).
                        Subset
                        Where STATUS = 1

INLSET3   COMPANY       Used to access a company's Intrastat     IN120
          TAX-YEAR      calendar periods with a status of 2
          TAX-PERIOD    (Reported).
                        Subset
                        Where STATUS = 2