Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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
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           The tax period of the specified year.

INL-PER-END-DATE     Numeric 8  (yyyymmdd)                       IN08.1
Period End Date      The period end date of the specified
                     year.

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

INL-STATUS           Numeric 1                                   IN08.1  IN120
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