Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

TXCALENDAR


                            TXCALENDAR FILE

                          VAT calendar header

REFERENCED BY

AP272     TX101     TX120     TX125     TX222     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   TX222
                                                                 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