TAXIDEXMP – Pay/Deduction Exemption Code
- System
- Payroll (PR)
- Prefix
TID- Primary key
COMPANY,PAY-DED-FLAG,PAY-CODE,DED-CODE- Fields
- 6
- Updated by
- 7 programs
- Referenced by
- 10 programs
TAXIDEXMP is the Pay/Deduction Exemption Code table in Lawson Payroll (prefix TID). It is indexed by COMPANY, PAY-DED-FLAG, PAY-CODE, DED-CODE (TIDSET1). It is related 1:1 to PRSYSTEM, DEDCODE and PAYSUMGRP. It is updated by HR00.1, HR01.1, PR05.1, PR05.2, PR05.8, PR20.2 and PR20.5 and referenced by BN66.1, PR140, PR189, PR195, PR220, PR262, PR80.1, PR80.4 and 2 more. The table has 6 fields, 1 index and 4 documented relations.
About TAXIDEXMP
The Pay/Deduction Exemption Code file contains two types of records. PR05.2 (Taxable Wages Table) creates type D records that represent withholding deductions whose taxable wage is to be reduced by the amount of a designated deduction. PR20.5 (Withholding Exemptions) creates type P records that represent withholding deductions that are not to be used in calculating taxes for a designated pay code.
Fields (6)
Column = COBOL field name without the TID- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
TID-COMPANY PKCOMPANY | Numeric 4 | — | PR05.2, PR05.8, PR20.5 |
TID-PAY-DED-FLAG PKPAY_DED_FLAG | Alpha 1 | Contains the value that indicates if the record is a type D (created by PR05.2 - Taxable Wages Table) or a type P (created by PR20.5 - Withholding Exemptions).
| PR05.2, PR05.8, PR20.5 |
TID-PAY-CODE PKPAY_CODE | Alpha 4 | For type D (created by PR05.2 - Taxable Wages Table) records, this field contains a deduction. For type P (created by PR20.5 - Withholding Exemptions) records, this field contains a pay code. | PR05.2, PR05.8, PR20.5 |
TID-DED-CODE PKDED_CODE | Alpha 4 | Contains a deduction for both types of records. | PR05.2, PR05.8, PR20.5 |
TID-TAXABLE-FLAGTAXABLE_FLAG | Alpha 1 | Contains a value that identifies how the deduction is treated. The system uses this field only with type P records. If the value in this field is E (Exempt), the deduction entered is exempt from the pay code amount. If the value in this field is T (Taxable Wages only), the taxable wages associated with the deduction entered are updated by the amount of the pay code. The tax amount for the deduction is not withheld.
| PR20.5 |
TID-DED-TAXABLEDED_TAXABLE | Alpha 1 | — | PR05.8 |
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 |
|---|---|---|---|---|
TIDSET1 | COMPANY, PAY-DED-FLAG, PAY-CODE, DED-CODE | Primary | BN66.1, HR00.1, HR01.1, PR05.1, PR05.2, PR05.8, PR140, PR189 +9 more |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | TID-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Ded Code | DEDCODE | Required | When TID-PAY-DED-FLAG = "D" | TID-COMPANY → DDC-COMPANY, TID-PAY-CODE → DDC-DED-CODE |
| Deduction | DEDCODE | Required | TID-COMPANY → DDC-COMPANY, TID-DED-CODE → DDC-DED-CODE | |
| Pay Sum Grp | PAYSUMGRP | Required | When TID-PAY-DED-FLAG = "P" | TID-COMPANY → PSG-COMPANY, TID-PAY-CODE → PSG-PAY-SUM-GRP |
Programs
Updated by (7)
- HR00.1 Company
- HR01.1 Process Level
- PR05.1 Deduction
- PR05.2 Taxable Wages Table
- PR05.8 ALLTAX Taxable Wage Table
- PR20.2 Pay Summary Group
- PR20.5 Tax Exemptions