Lawson Insight Technical Documentation

                             PRTAXPRDS 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.1    UK85.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

TPS-COMPANY            Numeric 4                                 UK85.1  UK85.3
Element: Company Hr    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.

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

TPS-PAYROLL-YEAR       Numeric 4                                 UK85.1  UK85.3
Element: Current PayrolContains the payroll year in which the
                       allocation was taken.

TPS-PLAN-CODE          Alpha 4                                   UK85.1  UK85.3
Element: Plan          Contains the user-defined code that
                       represents a benefit plan.

TPS-PD-START-D         Numeric 8  (yyyymmdd)                     UK85.1  UK85.3
Element: Pd Start D

TPS-PD-END-D           Numeric 8  (yyyymmdd)                     UK85.1  UK85.3
Element: Pd End D

TPS-PERIOD-NBR         Numeric 3                                 UK85.1  UK85.3
Element: Period Nbr

TPS-DFLT-PAY-DATE      Numeric 8  (yyyymmdd)                     UK85.1  UK85.3
Element: Dflt Pay Date

                         PRTAXPRDS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TPSSET1   COMPANY                                                UK85.1
          COUNTRY-CODE
          PAYROLL-YEAR
          PLAN-CODE
          PD-END-D

TPSSET2   COMPANY       KeyChange                                BN150   PR128
          COUNTRY-CODE                                           PR130   PR131
          PLAN-CODE                                              PR132   PR134
          PAYROLL-YEAR                                           PR136   PR160
          PERIOD-NBR                                             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
                                                                 ...

TPSSET3   COMPANY                                                BN150   PR128
          COUNTRY-CODE                                           PR130   PR131
          PLAN-CODE                                              PR132   PR134
          PD-END-D                                               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
                                                                 ...

                         PRTAXPRDS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            TPS-COMPANY         -> PRS-COMPANY
                            Spaces              -> PRS-PROCESS-LEVEL

Country        INSTCTRYCD   Required

                            TPS-COUNTRY-CODE    -> INT-COUNTRY-CODE

Instctrycd     INSTCTRYCD   Required

                            TPS-COUNTRY-CODE    -> INT-COUNTRY-CODE