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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PXCSET1
  1. COUNTRY-CODE
  2. ADJUST-PAY
  3. TAX-CATEGORY
PrimaryHPXC.1, HR100, PR05.1, PR205, PR266, PR290, PR294
PXCSET2
  1. COUNTRY-CODE
  2. TAX-CATEGORY
  3. ADJUST-PAY
KeyChangePR05.1, PR141, PR262, PR290, PR294, PR297

Programs

Updated by (1)

Referenced by (9)