Lawson Insight Technical Documentation

                             PRTAXYEAR FILE

REFERENCED BY

BN150     PR128     PR130     PR131     PR132     PR134
PR136     PR160     PR180     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     PR560     PR82.1    PR85.1
UK102     UK145     UK201     UK202     UK50.2    UK50.3
TA147     TP135

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   PR128
                                                                 PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR160
                                                                 PR180   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   PR560
                                                                 PR82.1  PR85.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