PRTAXCAT – No description in the Lawson data dictionary

System
Payroll (PR)
Prefix
PXC
Primary key
COUNTRY-CODE, ADJUST-PAY, TAX-CATEGORY
Fields
4
Updated by
1 program
Referenced by
9 programs

PRTAXCAT is a Lawson Payroll table (prefix PXC); no description in the lawson data dictionary. It is indexed by COUNTRY-CODE, ADJUST-PAY, TAX-CATEGORY (PXCSET1); alternate indexes: PXCSET2. It is updated by HR100 and referenced by HPXC.1, PR05.1, PR141, PR205, PR262, PR266, PR290, PR294 and 1 more. The table has 4 fields, 2 indexes and 0 documented relations.

About PRTAXCAT

No description in the Lawson data dictionary.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
PXC-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).—
PXC-ADJUST-PAY PK
ADJUST_PAY		Alpha 1Contains the value that determines how the deduction affects the employee's pay. For selection S (Employee Paid), the application subtracts the deduction from the employee's gross pay. For selection A (Add To Net), the application adds the deduction to the employee's net pay. Use type A for earned income credit deductions. C (Company Paid) deductions do not affect the employee's gross pay.—
PXC-TAX-CATEGORY PK
TAX_CATEGORY		Numeric 2Contains the tax category for the deduction.—
PXC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the tax category description.—

Indexes (2)

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

IndexKeysFlagsConditionUsed in
PXCSET1COUNTRY-CODE, ADJUST-PAY, TAX-CATEGORYPrimaryHPXC.1, HR100, PR05.1, PR205, PR266, PR290, PR294
PXCSET2COUNTRY-CODE, TAX-CATEGORY, ADJUST-PAYKeyChangePR05.1, PR141, PR262, PR290, PR294, PR297

Programs

Updated by (1)

Referenced by (9)