Lawson Insight Technical Documentation

                             PRTAXYEAR FILE

REFERENCED BY

AC541     AC542     BN150     BN66.1    PR128     PR130
PR131     PR132     PR134     PR136     PR139     PR140
PR160     PR180     PR189     PR195     PR197     PR29.1
PR32.2    PR33.2    PR33.3    PR35.1    PR35.2    PR35.3
PR35.4    PR35.5    PR35.6    PR35.8    PR36.1    PR39.1
PR45.1    PR529     PR530     PR560     PR80.1    PR80.2
PR82.1    PR85.1    PR89.1    UK102     UK13.1    UK145
UK201     UK202     UK50.2    UK50.3    UK560     TA147
UK120

UPDATED BY

UK85.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TXY-COUNTRY-CODE       Alpha 2                                   UK85.2
Element: Country Code  The country code.  Required for VAT and
                       intrastat reporting.  Must be defined in
                        IN01.1 (Country Maintenance).

TXY-TAX-YR-START       Numeric 4  (mmdd)                         UK85.2
Element: Tax Yr Start

TXY-TAX-YR-END         Numeric 4  (mmdd)                         UK85.2
Element: Tax Yr End

TXY-YEAR-START-FLG     Numeric 1                                 UK85.2
Element: Year Start Flg1 = Year as at Start
                       2 = Year as at End

                         PRTAXYEAR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TXYSET1   COUNTRY-CODE                                           AC541   AC542
                                                                 BN150   BN66.1
                                                                 PR128   PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR139   PR140
                                                                 PR160   PR180
                                                                 PR189   PR195
                                                                 PR197   PR29.1
                                                                 PR32.2  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR39.1
                                                                 ...

                         PRTAXYEAR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Instctrycd     INSTCTRYCD   Required

                            TXY-COUNTRY-CODE    -> INT-COUNTRY-CODE