Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXCALENDAR


                            TXCALENDAR FILE

                          VAT calendar header

This file defines the Period End Dates for tax reporting periods.

REFERENCED BY

TX120     TX125     TX226

UPDATED BY

TX08.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

                         TXCALENDAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXASET1   COMPANY                                                TX08.1  TX120
          TAX-YEAR                                               TX125   TX226

                         TXCALENDAR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Calendar Dtl   TXCALDTL

                            TXA-COMPANY     -> TXB-COMPANY
                            TXA-TAX-YEAR    -> TXB-TAX-YEAR
                                               TXB-TAX-PERIOD