Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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

AC542     BN340     BN66.1    HPRX.1    HR11.1    HR11.2
HR15.1    HR155     HR170     HR211     HR511     HR515
HR54.1    HR55.2    HR650     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     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     PR13.1    PR13.5
PR13.6    PR13.8    PR139     PR140     PR160     PR180
PR189     PR195     PR197     PR206     PR225     PR240
PR241     PR242     PR243     PR244     PR245     PR246
PR248     PR25.2    PR250     PR251     PR252     PR253
PR26.1    PR27.1    PR290     PR291     PR292     PR294
PR297     PR298     PR299     PR46.2    PR47.1    PR514
PR67.1    PR67.2    PR67.3    PR67.4    PR67.5    PR702
PR80.1    PR80.2    PR82.1    PR85.1    PR89.1    PRSC.1
TA40.2    TA40.3    PR227     PR296     TA146     TA148
PR125     PR925     AC541     BN150     PR128     PR130
PR131     PR132     PR134     PR136     PR29.1    PR32.2
PR33.2    PR33.3    PR35.1    PR35.2    PR35.3    PR35.4
PR35.5    PR35.6    PR35.8    PR36.1    PR45.1    PR529
PR530     PR560     UK102     TA147     UK120

UPDATED BY

PR06.1    PR08.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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


PRX-BSI-AUTHORITY    Alpha 11                                    BN66.1  PR06.1
Bsi Authority        Contains the BSI tax code that              PR08.1  PR89.1
                     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
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
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
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
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
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
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
Tax Province

                         PRTAXAUTH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRXSET1   TAX-ID-CODE                                            AC542   BN340
                                                                 BN66.1  HPRX.1
                                                                 HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR170   HR211
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   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
                                                                 ...

PRXSET2   TAX-AUTH-TYPE KeyChange                                BN66.1  PR06.1
          TAX-STATE                                              PR08.1  PR139
          TAX-PROVINCE                                           PR140   PR189
          TAX-ID-CODE                                            PR195   PR227
                                                                 PR250   PR251
                                                                 PR252   PR253
                                                                 PR26.1  PR291
                                                                 PR292   PR296
                                                                 PR297   PR298
                                                                 PR299   PR47.1
                                                                 PR514   PR80.1
                                                                 PR89.1  TA146
                                                                 TA148

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   PR89.1
                                                                 PR925

PRXSET4   BSI-AUTHORITY KeyChange                                AC541   AC542
          TAX-ID-CODE                                            BN150   HR11.1
                                                                 HR11.2  HR511
                                                                 HR650   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
                                                                 ...

                         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