Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRTAXAUTH


                             PRTAXAUTH FILE

                             Tax Authority

This file contains the tax authority that provides the link between the
Payroll system and the Business Software, Inc. tax tables. Tax authorities can
be company or process level specific.

REFERENCED BY

BN100     BN101     BN102     BN103     BN104     BN105
BN145     BN150     BN245     BN31.1    BN31.2    BN32.1
BN32.2    BN32.3    BN340     BN45.1    BN531     BN65.1
BN71.1    BN72.1    BS13.1    BS14.1    BS15.1    BS32.1
HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1    HPRX.1
HR11.1    HR11.2    HR15.1    HR155     HR170     HR211
HR511     HR515     HR54.1    HR55.2    HR70.1    HRS1.1
HRSC.1    PA02.1    PA100     PA102     PA113     PA13.1
PA13.2    PA16.1    PA20.1    PA21.1    PA22.1    PA24.1
PA27.1    PA272     PA34.1    PA35.1    PA36.1    PA38.1
PA502     PA513     PA52.1    PA52.3    PA52.4    PA52.5
PA520     PA53.1    PA54.1    PA66.3    TR21.1    TR22.1
TR26.1    TR500     PR03.1    PR05.1    PR05.4    PR05.5
PR07.9    PR07.1    PR07.2    PR07.3    PR07.4    PR07.5
PR07.6    PR07.7    PR07.8    PR110     PR113     PR120
PR128     PR13.1    PR13.2    PR13.5    PR13.6    PR13.8
PR130     PR131     PR132     PR134     PR136     PR14.1
PR15.1    PR15.2    PR160     PR180     PR197     PR205
PR206     PR225     PR240     PR241     PR242     PR243
PR244     PR245     PR246     PR248     PR25.2    PR250
PR251     PR252     PR253     PR26.1    PR27.1    PR29.1
PR290     PR291     PR292     PR294     PR297     PR298
PR299     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    PR39.2    PR45.1    PR46.2    PR47.1
PR529     PR530     PR560     PR67.1    PR67.2    PR67.3
PR67.4    PR67.5    PR67.6    PR67.7    PR67.8    PR702
PR82.1    PR85.1    PRSC.1    UK06.1    UK102     UK46.2
UK47.1    TA147     TA40.2    TA40.3    TP135     PR227
PR296     TA146     TA148     TP231     PR125     PR925

UPDATED BY

PR06.1    PR08.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PRX-TAX-ID-CODE        Alpha 10                                  PR06.1  PR08.1
Element: Tax Id Code   Contains the tax authority.

PRX-DESCRIPTION        Alpha 30  (Lower Case)                    PR06.1  PR08.1
Element: Description   Contains the tax authority description.

PRX-BSI-AUTHORITY      Alpha 11                                  PR06.1  PR08.1
Element: Bsi Authority Contains the BSI tax code that
                       determines the tax tables the system
                       uses. For proper calculation, you must
                       tie tax deductions to the appropriate
                       BSI tax codes.

PRX-W2-DESC            Alpha 6  (Lower Case)                     PR06.1  PR08.1
Tax Authority Desc.    Contains the tax authority description
for W-2                that prints on the W-2 form created by
                       PR297 (W-2 Forms) for state and local
                       taxes.

PRX-TAX-AUTH-TYPE      Alpha 2                                   PR06.1  PR08.1
Element: Tax Auth Type Contains the tax authority type.
                       FD = Federal
                       ST = State
                       CI = City
                       CN = County
                       SD = School District
                       TD = Transportation District
                       PR = Province

PRX-TAX-STATE          Alpha 2                                   PR06.1  PR08.1
State Taxing           Contains the value that identifies the
Authority Code         state in which the tax authority is
                       located if the authority type is
                       anything but FD (Federal). This field
                       along with the Authority Type field
                       determines if the State Rpt subform is
                       accessible.

PRX-STATE-RECIP        Alpha 1                                   PR06.1  PR08.1
Element: State Recip   Contains the value that indicates if
                       the state associated with the tax
                       authority participates in reciprocity.
                       Y = Yes
                       N = No

PRX-COUNTY-CODE        Numeric 2                                 PR06.1  PR08.1
Element: County Code   Contains the 2-digit county code
                       required for W-2 tape reporting in the
                       state of Indiana.

PRX-SCH-DIST-NBR       Alpha 4                                   PR06.1  PR08.1
Element: Sch Dist Nbr  Contains the school district number
                       required by the state of Ohio for W-2
                       tape reporting.

PRX-GARN-ONLY          Alpha 1                                   PR06.1  PR08.1
Element: Garn Only     Determines what fields are required
                       when adding a tax authority.
                       Y = Yes
                       N = No

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

PRX-TAX-PROVINCE       Alpha 2                                   PR08.1
Element: Province

                         PRTAXAUTH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRXSET1   TAX-ID-CODE                                            BN100   BN101
                                                                 BN102   BN103
                                                                 BN104   BN105
                                                                 BN145   BN150
                                                                 BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN340   BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 HAP3.1  HEP4.1
                                                                 HPOS.1  HPQC.1
                                                                 HPRS.1  HPRX.1
                                                                 ...

PRXSET2   TAX-AUTH-TYPE KeyChange                                PR06.1  PR08.1
          TAX-STATE                                              PR227   PR250
          TAX-PROVINCE                                           PR251   PR252
          TAX-ID-CODE                                            PR253   PR26.1
                                                                 PR291   PR292
                                                                 PR296   PR297
                                                                 PR298   PR299
                                                                 PR47.1  UK47.1
                                                                 TA146   TA148
                                                                 TP231

PRXSET3   COUNTRY-CODE                                           PR05.1  PR06.1
          TAX-ID-CODE                                            PR06.2  PR06.3
                                                                 PR06.4  PR06.5
                                                                 PR06.6  PR06.7
                                                                 PR06.8  PR06.9
                                                                 PR07.1  PR07.2
                                                                 PR07.3  PR07.4
                                                                 PR07.5  PR07.6
                                                                 PR07.7  PR07.8
                                                                 PR08.1  PR08.2
                                                                 PR125   PR206
                                                                 PR250   PR251
                                                                 PR253   PR925

PRXSET4   BSI-AUTHORITY KeyChange                                BN150   HR11.1
          TAX-ID-CODE                                            HR11.2  HR511
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR128   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PR130
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR29.1  PR32.2
                                                                 ...

                         PRTAXAUTH FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Default Tax Id PRTAXID      Required

                            PRX-TAX-ID-CODE     -> PTI-TAX-ID-CODE
                            Zeroes              -> PTI-COMPANY
                            Spaces              -> PTI-PROCESS-LEVEL

Province       PRPROVINCE   Not Required

                            PRX-TAX-PROVINCE    -> PPV-PROVINCE

State          PRSTATE      Required
                            When PRX-TAX-STATE != Spaces

                            PRX-TAX-STATE       -> PSA-STATE

                         PRTAXAUTH FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Minimum Wage   PRMINWAGE    Delete Cascades

                            PRX-TAX-ID-CODE     -> PMW-TAX-ID-CODE
                                                   PMW-EFFECT-DATE

Tax Id Nbrs    PRTAXID      Delete Cascades

                            PRX-TAX-ID-CODE     -> PTI-TAX-ID-CODE
                                                   PTI-COMPANY
                                                   PTI-PROCESS-LEVEL