TAXGROUP – Payroll Tax Reporting Group

System
Payroll (PR)
Prefix
TXG
Primary key
COMPANY, HEAD-PROC-LEV, PROCESS-LEVEL
Fields
4
Updated by
3 programs
Referenced by
120 programs

TAXGROUP is the Payroll Tax Reporting Group table in Lawson Payroll (prefix TXG). It is indexed by COMPANY, HEAD-PROC-LEV, PROCESS-LEVEL (TXGSET1); alternate indexes: TXGSET2. It is related 1:1 to PRSYSTEM. It is updated by HR00.1, HR01.1 and PR09.1 and referenced by BN150, BN305, BN66.1, EXI2.1, EXI4.1, HR11.1, HR11.2, HR11.4 and 112 more. The table has 4 fields, 2 indexes and 3 documented relations.

About TAXGROUP

The Payroll Tax Reporting Group serves as both the header and detail file for tax reporting groups. Tax reporting groups are used for quarterly and W-2 reporting and payment taxation processing. When the system generates W-2s or quarterly reports, it uses information from the head process level, such as name, address, and tax ID, instead of the company information. For payment taxation processing, the system checks for a link to a head process level if the employee's home process level is not to be treated independently for tax reporting (Independent field value = N). If the system finds a head process level, the head process level determines the tax authority and tax company used for the employee's payment taxation processing. If the system does not find a head process level, all taxation processing takes place at the company level.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
TXG-COMPANY PK
COMPANY		Numeric 4—PR09.1
TXG-HEAD-PROC-LEV PK
HEAD_PROC_LEV		Alpha 5Contains the process level that is defined as a head process level. A federal taxing authority for this process level must exist in the Taxing Authority Code Header file.PR09.1
TXG-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5Contains the process level. When a record in this file is created as the header record for the head process level, this value is the same as the value in the Head Process Level field.PR09.1
TXG-PL-OPTION
PL_OPTION		Alpha 1Contains the value that represents if the head process level is an independent process level or not. " " = No ; Not Independent
  • N No ; Not Independent
  • Y Yes; Independent
HR00.1, HR01.1, PR09.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
TXGSET1COMPANY, HEAD-PROC-LEV, PROCESS-LEVELPrimaryHR00.1, HR01.1, PR05.5, PR09.1, PR209, PR227, PR252, PR289 +9 more
TXGSET2COMPANY, PROCESS-LEVELBN150, BN305, BN66.1, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredTXG-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Head Proc LevPRSYSTEMRequiredTXG-COMPANY → PRS-COMPANY, TXG-HEAD-PROC-LEV → PRS-PROCESS-LEVEL
Process LevelPRSYSTEMRequiredWhen TXG-PROCESS-LEVEL != SpacesTXG-COMPANY → PRS-COMPANY, TXG-PROCESS-LEVEL → PRS-PROCESS-LEVEL

Programs

Updated by (3)

Referenced by (120)