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

AP272     TX101     TX125     TX130     TX226     TX301

UPDATED BY

TX08.1    TX120

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TXB-COMPANY            Numeric 4                                 TX08.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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: Period End DatThe 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   AP272   TX08.1
          TAX-YEAR      lines.                                   TX101   TX120
          TAX-PERIOD                                             TX125   TX130
                                                                 TX226   TX301