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

AC541     AC542     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    BN66.1    BN71.1    BN72.1    BS13.1
BS14.1    BS15.1    BS32.1    HGLM.1    HPOS.1    HPQC.1
HPRS.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     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     PR139     PR14.1    PR140     PR15.1
PR15.2    PR160     PR180     PR189     PR195     PR197
PR205     PR206     PR225     PR240     PR241     PR242
PR243     PR244     PR245     PR246     PR248     PR25.2
PR250     PR251     PR252     PR253     PR26.1    PR26.2
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    PR36.1    PR39.1    PR39.2    PR45.1    PR46.2
PR47.1    PR47.2    PR514     PR529     PR530     PR560
PR67.1    PR67.2    PR67.3    PR67.4    PR67.5    PR67.6
PR67.7    PR67.8    PR702     PR80.1    PR80.2    PR80.3
PR82.1    PR85.1    PR89.1    PRSC.1    UK06.1    UK102
UK46.2    UK47.1    UK47.2    UK560     TA147     TA40.2
TA40.3    UK120     PR227     PR296     TA146     TA148
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                                  BN66.1  PR06.1
Element: 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
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                                            AC541   AC542
                                                                 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
                                                                 BN66.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HGLM.1
                                                                 HPOS.1  HPQC.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  UK47.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