PRTAXLEVY – Payroll Tax Levy

System
Payroll (PR)
Prefix
TXL
Primary key
TAX-ID-CODE, LEVY-YEAR, LEVY-FILING-ST, LEVY-EXEMPTS
Fields
6
Updated by
2 programs
Referenced by
124 programs

PRTAXLEVY is the Payroll Tax Levy table in Lawson Payroll (prefix TXL). It is indexed by TAX-ID-CODE, LEVY-YEAR, LEVY-FILING-ST, LEVY-EXEMPTS (TXLSET1). It is related 1:1 to PRTAXAUTH. It is updated by HR100 and PR10.1 and referenced by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 116 more. The table has 6 fields, 1 index and 1 documented relation.

About PRTAXLEVY

Contains the information that makes up the tax table used for tax levies.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
TXL-LEVY-YEAR PK
LEVY_YEAR		Numeric 4Contains the year that identifies the IRS table.PR10.1
TXL-LEVY-FILING-ST PK
LEVY_FILING_ST		Alpha 1Contains the levy filing status.PR10.1
TXL-LEVY-EXEMPTS PK
LEVY_EXEMPTS		Numeric 2Contains the number of levy exemptions.PR10.1
TXL-LEVY-EXEMP-AMT
LEVY_EXEMP_AMT		Signed 6.2 Occurs 4 Times ×4Contains the levy exemption amount.PR10.1
TXL-TAX-ID-CODE PK
TAX_ID_CODE		Alpha 10—PR10.1
TXL-TXL-TYPE
TXL_TYPE		Alpha 1——

Indexes (1)

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

IndexKeysFlagsConditionUsed in
TXLSET1TAX-ID-CODE, LEVY-YEAR, LEVY-FILING-ST, LEVY-EXEMPTSPrimaryBN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PrtaxauthPRTAXAUTHRequiredTXL-TAX-ID-CODE → PRX-TAX-ID-CODE

Programs

Updated by (2)

Referenced by (124)