PRTAXAUTH

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 BN305 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN340 BN45.1 BN531
BN65.1 BN66.1 BN71.1 BN72.1 BS10.1 BS12.1
BS13.1 BS14.1 BS15.1 BS32.1 ZB10.1 ZB31.1
ZB31.2 ZB32.1 ZB32.2 ZB32.3 HAP3.1 HCRE.1
HEP4.1 HPOS.1 HPQC.1 HPRS.1 HPRX.1 HR100
HR11.1 HR11.2 HR11.4 HR15.1 HR155 HR156
HR170 HR211 HR28.1 HR511 HR515 HR54.1
HR55.2 HR70.1 HRS1.1 HRSC.1 LT101 LT11.5
LT111 LT13.5 PR521 ZH156 ZH510 EXI2.1
EXI4.1 LP100 LP101 LP130 PA02.1 PA100
PA102 PA113 PA115 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 PR10.1 PR11.5 PR11.3 PR110 PR113
PR12.6 PR120 PR128 PR13.1 PR13.2 PR13.5
PR13.6 PR13.8 PR13.9 PR131 PR132 PR134
PR135 PR136 PR137 PR139 PR14.1 PR14.2
PR140 PR141 PR15.1 PR15.2 PR160 PR180
PR189 PR195 PR197 PR205 PR206 PR210
PR225 PR227 PR240 PR241 PR242 PR243
PR244 PR245 PR246 PR248 PR249 PR25.2
PR250 PR251 PR252 PR253 PR26.1 PR26.2
PR266 PR27.1 PR27.2 PR29.1 PR290 PR291
PR292 PR294 PR297 PR299 PR30.2 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR36.4 PR37.1 PR39.1 PR39.2 PR45.1
PR46.2 PR47.1 PR47.2 PR512 PR514 PR529
PR530 PR539 PR560 PR582 PR597 PR67.1
PR67.2 PR67.3 PR67.4 PR67.5 PR67.6 PR67.7
PR67.8 PR67.9 PR68.1 PR68.2 PR68.3 PR68.4
PR68.5 PR68.6 PR68.7 PR68.8 PR68.9 PR69.1
PR69.2 PR80.1 PR80.2 PR80.3 PR80.4 PR82.1
PR85.1 PR89.1 PRAT.1 UK102 TA147 TA40.2
TA40.3 PR287 PR296 ZP296 TA148 PR125
PR262 PR925 PRAM.1


UPDATED BY
PR06.1 PR08.1 PR906

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRX-TAX-ID-CODE
Element: Tax Id Code
Alpha 10
Contains the tax authority.
PR06.1 PR08.1
PRX-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains the tax authority description.
PR06.1 PR08.1
PRX-BSI-AUTHORITY
Element: Bsi Authority
Alpha 11
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.
BN66.1 PR06.1
PR08.1 PR89.1
PR906
PRX-W2-DESC
Element: W2 Desc
Alpha 6 (Lower Case)
Contains the tax authority description that prints on the W-2 form created by PR297 (W-2 Forms) for state and local taxes.
PR06.1 PR08.1
PRX-TAX-AUTH-TYPE
Element: Tax Auth Type
Alpha 2
Contains the tax authority type.
FD = Federal
ST = State
CI = City
CN = County
SD = School District
TD = Transportation District
PR = Province
PR06.1 PR08.1
PRX-TAX-STATE
Element: Tax State
Alpha 2
Contains the value that identifies the 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.
PR06.1 PR08.1
PRX-STATE-RECIP
Element: State Recip
Alpha 1
Contains the value that indicates if the state associated with the tax authority participates in reciprocity.
Y = Yes
N = No
PR06.1 PR08.1
PRX-COUNTY-CODE
Element: County Code
Numeric 2
Contains the 2-digit county code required for W-2 tape reporting in the state of Indiana.
PR06.1 PR08.1
PRX-SCH-DIST-NBR
Element: Sch Dist Nbr
Alpha 4
Contains the school district number required by the state of Ohio for W-2 tape reporting.
PR06.1 PR08.1
PRX-GARN-ONLY
Element: Garn Only
Alpha 1
Determines what fields are required when adding a tax authority.
Y = Yes
N = No
PR06.1 PR08.1
PRX-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
CA
US
PR06.1 PR08.1
PRX-TAX-PROVINCE
Element: Province
Alpha 2
PR08.1


PRTAXAUTH FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRXSET1 TAX-ID-CODE
...
BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN340
BN45.1 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BS10.1 BS12.1
BS13.1 BS14.1
BS15.1 BS32.1
ZB10.1 ZB31.1
PRXSET2 TAX-AUTH-TYPE
TAX-STATE
TAX-PROVINCE
TAX-ID-CODE
KeyChange
BN66.1 PR06.1
PR08.1 PR11.3
PR11.5 PR139
PR140 PR189
PR195 PR227
PR250 PR251
PR252 PR253
PR26.1 PR287
PR291 PR292
PR296 PR297
PR299 PR47.1
PR514 PR80.1
PR80.4 PR89.1
PRAT.1 ZP296
TA148
PRXSET3 COUNTRY-CODE
TAX-ID-CODE
...
PR05.1 PR06.1
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 PR262
PR69.2 PR89.1
PR906 PR925
PRXSET4 BSI-AUTHORITY
TAX-ID-CODE
KeyChange
...
BN150 BN305
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PR521
ZH510 EXI2.1
EXI4.1 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120


PRTAXAUTH FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:30:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.