Lawson Insight Technical Documentation

                            TXCALENDAR FILE

                          VAT calendar header

REFERENCED BY

AP272     TX101     TX120     TX125     TX226     TX301

UPDATED BY

TX08.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TXA-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.

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                                                AP272   TX08.1
          TAX-YEAR                                               TX101   TX120
                                                                 TX125   TX226
                                                                 TX301

                         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