PRTAXAUTH – Tax Authority

System: Payroll (PR)
Prefix: PRX
Primary key: TAX-ID-CODE
Fields: 12
Updated by: 3 programs
Referenced by: 249 programs

PRTAXAUTH is the Tax Authority table in Lawson Payroll (prefix PRX). It is indexed by TAX-ID-CODE (PRXSET1); alternate indexes: PRXSET2, PRXSET3 and PRXSET4. It is related 1:1 to PRTAXID, PRPROVINCE and PRSTATE and 1:M to PRMINWAGE and PRTAXID. It is updated by PR06.1, PR08.1 and PR906 and referenced by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 241 more. The table has 12 fields, 4 indexes and 5 documented relations.

About PRTAXAUTH

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.

Fields (12)

Column = COBOL field name without the PRX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PRX-TAX-ID-CODE` PK TAX_ID_CODE	Alpha 10	Contains the tax authority.	PR06.1, PR08.1
`PRX-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains the tax authority description.	PR06.1, PR08.1
`PRX-BSI-AUTHORITY` 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` 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` 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` 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` 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` 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` 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` 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` 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` TAX_PROVINCE	Alpha 2	—	PR08.1

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`PRXSET1`	`TAX-ID-CODE`	Primary	BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)
`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 +21 more
`PRXSET3`	`COUNTRY-CODE`, `TAX-ID-CODE`		PR05.1, PR06.1, PR06.2, PR06.3, PR06.4, PR06.5, PR06.6, PR06.7 +22 more (list truncated in source)
`PRXSET4`	`BSI-AUTHORITY`, `TAX-ID-CODE`	KeyChange	BN150, BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Condition	Field map
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`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
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`

Programs

Updated by (3)

PR06.1 United States Tax Authority
PR08.1 Canada Tax Authority
PR906 ALLTAX Tax Code Update

Referenced by (249)

BN100 Employee Change Benefit Update
BN101 Mass Benefit Add
BN102 Plan Employee Update
BN103 Mass Benefit Termination
BN104 Frequency Table Update
BN105 Plan Update
BN145 Flex Dollars Calculation
BN150 Life Insurance Reportable Income
BN245 Benefit Election Form
BN305 Highly Compensated Employees
BN31.1 Speed Benefit Entry
BN31.2 Employee Benefit Entry
BN32.1 Employee Benefit Changes
BN32.2 Employee Benefit Detail Changes
BN32.3 Benefit Add
BN340 ADP and ACP Tests
BN45.1 Employee Flex Credits
BN531 Batch Benefit Enrollment
BN65.1 Election Simulation
BN66.1 Estimated Pay Calculation
BN71.1 COBRA Benefit Entry
BN72.1 Retiree Benefit Entry
BS10.1 Web Enrollment Current Benefit Inquiry
BS12.1 Web Enrollment Eligible New Plans
BS13.1 Web Enrollment Coverage Options
BS14.1 Web Enrollment Coverage Amounts
BS15.1 Web Enrollment Contribution Limits
BS32.1 Web Enrollment Stop Benefits Update
EXI2.1 Invoke for PRTRDPD
EXI4.1 Invoke for PRPRBPD
HAP3.1 Applicant Option 4 Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HPRX.1 Prtaxauth Select Invoke
HR100 Lawson Delivered Files Purge
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR15.1 User Fields
HR155 Employee Group Update
HR156 Employee Group Company Update
HR170 Human Resource Writer Report Request
HR211 Employee Listing
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR515 User Field Conversion
HR54.1 Employee History Correction
HR55.2 Employee Groups By Employees
HR70.1 Human Resource Writer Inquiry
HRS1.1 Select Control
HRSC.1 Select Control
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP130 Absence Plan Payout
LT101 HRM Receiver Update
LT11.5 HRM User Field Interface
LT111 HRM Receiver Update
LT13.5 HRM User Field Interface History
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA113 Retroactive History Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA16.1 Company Property
PA20.1 Education
PA21.1 Competencies
PA22.1 Certifications
PA24.1 Relocation
PA27.1 Contracts
PA272 Budget and Assigned Resource Listing
PA34.1 Applicant Education
PA35.1 Applicant Competencies
PA36.1 Applicant Certification
PA38.1 Applicant Relocation
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA520 Employee and Applicant Code Conversion
PA53.1 Personnel Action Workflow Override
PA54.1 Personnel Action History Correction
PA66.3 Employee Action Detail
PR03.1 Deduction Required Code
PR05.1 Deduction
PR05.4 Employment Health Tax Wages
PR05.5 Employment Health Tax Exemptions
PR07.1 State Reporting Information
PR07.2 State Reporting Information
PR07.3 State Reporting Information
PR07.4 State Reporting Information
PR07.5 State Reporting Information
PR07.6 State Reporting Information
PR07.7 State Reporting Information
PR07.8 State Reporting Information
PR07.9 State Reporting Information
PR10.1 United States Tax Levy Table
PR11.3 Employee HIRE Act Tax Reporting Info
PR11.5 Employee Year-End PA TCD Override
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR125 Employee Wages for Employment Health Tax
PR128 Offset Time Record Creation
PR13.1 Employee United States Taxes
PR13.2 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR131 Retroactive Pay Calculation
PR132 FLSA Overtime Calculation
PR134 Automatic Time Records
PR135 Time Record Edit
PR136 Missing Time Records
PR137 Batch Time Record Update
PR139 Arrears Automation
PR14.1 Employee Deduction
PR14.2 Tax Withholding Lock-In
PR140 Earnings and Deductions Calculation
PR141 Payroll Register
PR15.1 Deduction Speed Entry
PR15.2 Employee Deduction Speed Entry
PR160 Payment Print
PR180 Manual Payment Print
PR189 Gross Up Calculation
PR195 Accrual Program
PR197 Payroll Close
PR205 Deduction Listing
PR206 Tax Authority Listing
PR210 Tax Levy Table Listing
PR225 United States Garnishment Rules Listing
PR227 Year-End Parameter Report
PR240 T4-T4A Slips
PR241 T4-T4A XML
PR242 T4-T4A Reports
PR243 Releve Slips
PR244 Releve Magnetic Media
PR245 Releve Reports
PR246 Canada Garnishment Rules Listing
PR248 Canada Annual Reports
PR249 PIER Audit Report
PR25.2 United States Garnishment Rules
PR250 1099-R Form Reporting
PR251 1099-R File Creation
PR252 United States Territory W-2 Form Printing
PR253 1099-R Reporting
PR26.1 United States Employee Garnishment
PR26.2 United States Employee Garnishment Inquiry
PR262 Taxable Wage CSV
PR266 Quarterly Tax Balancing Report
PR27.1 Year-End Parameters
PR27.2 Tax Authority Year-End Parameters
PR287 Quarterly Federal Tax Return
PR29.1 Pension Payment Maintenance
PR290 Quarterly Report
PR291 Unemployment Continuation Form
PR292 Quarterly Unemployment Ins
PR294 United States Balancing Report
PR296 New Hire Reporting
PR297 W-2 Forms
PR299 EFW2 File Creation
PR30.2 Employee Automatic Time Record
PR32.1 Employee Daily Time Entry
PR32.2 Employee Daily Time Entry
PR33.1 Speed Entry Setup
PR33.2 Speed Entry by Number
PR33.3 Speed Entry by Name
PR35.1 Time Entry
PR35.2 Detail Time Entry
PR35.3 Speed Time Entry
PR35.4 Step and Grade, Grade Range Time Entry
PR35.5 Attendance Time Entry
PR35.6 Activity Time Entry
PR35.8 Position Time Entry
PR35.9 Reason Code Time Entry
PR36.1 Time Record Entry
PR36.4 Manual Time Record Maintenance
PR37.1 Batch Time Control
PR39.1 One Time Deduction
PR39.2 One Time Deduction Speed
PR45.1 Error Processing
PR46.2 Canada Garnishment Rules
PR47.1 Canada Employee Garnishment
PR47.2 Canada Employee Garnishment Inquiry
PR512 Employee ACH Distribution Interface
PR514 Employee Deduction Master Load
PR521 Nonstandard Pay and Work Period CSV Load
PR529 Pension Payroll Conversion
PR530 Time Record Interface CSV
PR539 One Time Deduction Load
PR560 Payroll History Load CSV
PR582 Mass Adjustment Load
PR597 Employee Year-End PA TCD Override Upload
PR67.1 State Reporting Information
PR67.2 State Reporting Information
PR67.3 State Reporting Information
PR67.4 State Reporting Information
PR67.5 State Reporting Information
PR67.6 State Reporting Information
PR67.7 State Reporting Information
PR67.8 State Reporting Information
PR67.9 State Reporting Information
PR68.1 New Mexico State Report
PR68.2 Not Used
PR68.3 Florida
PR68.4 Missouri
PR68.5 Tennessee
PR68.6 Nevada
PR68.7 Oklahoma
PR68.8 Vermont
PR68.9 Michigan
PR69.1 Additional Information
PR69.2 Additional Information
PR80.1 Manual Check
PR80.2 Manual Payment Print
PR80.3 Manual Payment One Time Deduction
PR80.4 Manual Payment
PR82.1 Adjustment
PR85.1 Bank Account Reconciliation
PR89.1 Payment Modeling
PR925 Load Required US Federal Garnishment Rules
PRAM.1 ALLTAX Tax Authority Mapping
PRAT.1 Alltax connection test
TA147 Canada Vacation Audit
TA148 Canada Vacation Rollover
TA40.2 Canada Vacation Hours Schedule
TA40.3 Canada Vacation Date Schedule
TR21.1 Employee Training History
TR22.1 Session Completion
TR26.1 Employee Training Competency Maintenance
TR500 Training Conversion
UK102 Bonus Pay Update
ZB10.1 Coverage Options Calculator
ZB31.1 Speed Benefit Entry
ZB31.2 Employee Benefit Entry
ZB32.1 Employee Benefit Changes
ZB32.2 Employee Benefit Detail Changes
ZB32.3 Benefit Add
ZH156 Employee Group Company Update
ZH510 Update PCP from ZPENDPCP
ZP296 New Hire Reporting