Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             TXCALDTL FILE

                          VAT calendar detail

This file contains the details of the tax calendar maintained in the
TXCALENDAR file. It maintains the year and periods and the status of the
periods.

REFERENCED BY

TX125     TX130

UPDATED BY

TX08.1    TX120

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

TXB-TAX-PERIOD       Numeric 2                                   TX08.1
Tax Period           The number for the tax period within
                     the tax year.

TXB-PER-END-DATE     Numeric 8  (yyyymmdd)                       TX08.1
Period End Date      The period end date for that tax period.

TXB-STATUS           Numeric 1                                   TX08.1  TX120
Status               The status of the period:

                     1 - Open
                     2 - Reported
                     3 - Closed.
                     1 = Open
                     2 = Reported
                     3 = Closed

                         TXCALDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXBSET1   COMPANY       Used to access the tax calendar detail   TX08.1  TX120
          TAX-YEAR      lines.                                   TX125   TX130
          TAX-PERIOD