Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXCALDTL


                             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     TX226

UPDATED BY

TX08.1    TX120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

TXB-STATUS             Numeric 1                                 TX08.1  TX120
Element: 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                                             TX226