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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#PRX-TAX-ID-CODE PKTAX_ID_CODE | Alpha 10 | Contains the tax authority. | PR06.1, PR08.1 |
#PRX-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | Contains the tax authority description. | PR06.1, PR08.1 |
#PRX-BSI-AUTHORITY SET4BSI_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-DESCW2_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 SET2TAX_AUTH_TYPE | Alpha 2 | Contains the tax authority type.
| PR06.1, PR08.1 |
#PRX-TAX-STATE SET2TAX_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-RECIPSTATE_RECIP | Alpha 1 | Contains the value that indicates if the state associated with the tax authority participates in reciprocity.
| PR06.1, PR08.1 |
#PRX-COUNTY-CODECOUNTY_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-NBRSCH_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-ONLYGARN_ONLY | Alpha 1 | Determines what fields are required when adding a tax authority.
| PR06.1, PR08.1 |
#PRX-COUNTRY-CODE SET3COUNTRY_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 SET2TAX_PROVINCE | Alpha 2 | — | PR08.1 |
Indexes (4)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PRXSET1 |
| Primary | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source) | |
PRXSET2 |
| KeyChange | BN66.1, PR06.1, PR08.1, PR11.3, PR11.5, PR139, PR140, PR189 +21 more | |
PRXSET3 |
| PR05.1, PR06.1, PR06.2, PR06.3, PR06.4, PR06.5, PR06.6, PR06.7 +22 more (list truncated in source) | ||
PRXSET4 |
| 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 |
| ||||||||||
| Province | PRPROVINCE | Not Required |
| ||||||||||
| State | PRSTATE | Required | When PRX-TAX-STATE != Spaces |
|
One to many (2) — child tables
Programs
Updated by (3)
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