PSGTAXES – Pay Summary Group Taxes

System: Payroll (PR)
Prefix: PTX
Primary key: COMPANY, PAY-SUM-GRP, TAX-AUTH-TYPE
Fields: 7
Updated by: 2 programs
Referenced by: 9 programs

PSGTAXES is the Pay Summary Group Taxes table in Lawson Payroll (prefix PTX). It is indexed by COMPANY, PAY-SUM-GRP, TAX-AUTH-TYPE (PTXSET1). It is related 1:1 to PRSYSTEM and PAYSUMGRP. It is updated by PR20.2 and PR20.6 and referenced by BN66.1, PR140, PR189, PR195, PR220, PR80.1, PR80.4, PR89.1 and 1 more. The table has 7 fields, 1 index and 2 documented relations.

About PSGTAXES

This file contains tax override information for specific pay summary groups.

Fields (7)

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

Field / column	Type	Description & values	Updated by
`PTX-COMPANY` PK COMPANY	Numeric 4	—	PR20.6
`PTX-PAY-SUM-GRP` PK PAY_SUM_GRP	Alpha 3	Contains status M (Manual Override) pay summary groups for which tax overrides are defined.	PR20.6
`PTX-TAX-AUTH-TYPE` PK TAX_AUTH_TYPE	Alpha 2	Contains the tax authority type to which the tax override applies. `FD` Federal `ST` State `CI` City `CN` County `SD` School District `TD` Transportation District	PR20.6
`PTX-TAX-AMT-PCT` TAX_AMT_PCT	Signed 13.4	Contains the amount of the override.	PR20.6
`PTX-AMT-PCT-FLAG` AMT_PCT_FLAG	Alpha 1	Contains the value that indicates if the amount defined for the override is an amount or percent. `A` Amount `P` Percent	PR20.6
`PTX-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	—
`PTX-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	—

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`PTXSET1`	`COMPANY`, `PAY-SUM-GRP`, `TAX-AUTH-TYPE`	Primary		BN66.1, PR140, PR189, PR195, PR20.2, PR20.6, PR220, PR80.1 +3 more

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PTX-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Pay Sum Grp	PAYSUMGRP	Required		`PTX-COMPANY` → `PSG-COMPANY`, `PTX-PAY-SUM-GRP` → `PSG-PAY-SUM-GRP`

Programs

Updated by (2)

PR20.2 Pay Summary Group
PR20.6 Tax Overrides

Referenced by (9)

BN66.1 Estimated Pay Calculation
PR140 Earnings and Deductions Calculation
PR189 Gross Up Calculation
PR195 Accrual Program
PR220 Pay Code Listing
PR80.1 Manual Check
PR80.4 Manual Payment
PR89.1 Payment Modeling
PRAT.1 Alltax connection test