Lawson Insight Technical Documentation

                             PRTAXYEAR FILE

REFERENCED BY

BN150     BN66.1    ET530     ETI2.1    LP130     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    PR35.9
PR36.1    PR39.1    PR45.1    PR529     PR530     PR539
PR560     PR80.1    PR80.2    PR82.1    PR85.1    PR89.1
UK102     UK13.1    UK145     UK201     UK202     UK50.2
UK50.3    UK560     TA147

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                                           BN150   BN66.1
                                                                 ET530   ETI2.1
                                                                 LP130   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  PR35.9
                                                                 ...

                         PRTAXYEAR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Instctrycd     INSTCTRYCD   Required

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