PRGARNTYPE – Contains the type of garnishments and categories to which they are linked.

System
Payroll (PR)
Prefix
GRT
Primary key
COUNTRY-CODE, TYPE
Fields
4
Updated by
2 programs
Referenced by
20 programs

PRGARNTYPE is the Contains the type of garnishments and categories to which they are linked. table in Lawson Payroll (prefix GRT). It is indexed by COUNTRY-CODE, TYPE (GRTSET1); alternate indexes: GRTSET2. It is updated by PR25.1 and PR46.1 and referenced by BN66.1, PR115, PR139, PR140, PR189, PR195, PR198, PR225 and 12 more. The table has 4 fields, 2 indexes and 0 documented relations.

About PRGARNTYPE

Contains the type of garnishments and categories to which they are linked. Rules may be defined and reporting may be done by category.

Fields (4)

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

Field / columnTypeDescription & valuesUpdated by
GRT-TYPE PK
TYPE		Alpha 2Defines a type of garnishment. Rules may then be defined for this type.PR25.1, PR46.1
GRT-DESC
DESC		Alpha 30 (Lower Case)Describes the type of garnishment.PR25.1, PR46.1
GRT-GARN-CAT
GARN_CAT		Alpha 1Identifies a group of garnishments. Rules may be defined by category. Reporting may be done by category.
  • A Assignment
  • B Bankruptcy
  • G Garnishment
  • L Student Loans
  • S Support
  • T Tax Levy
  • C Revenue Canada
  • Q Quebec Revenue
  • P Priority
  • N Non Priority
PR25.1, PR46.1
GRT-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).PR25.1, PR46.1

Indexes (2)

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

IndexKeysFlagsConditionUsed in
GRTSET1COUNTRY-CODE, TYPEPrimaryBN66.1, PR115, PR139, PR140, PR189, PR195, PR198, PR225 +16 more
GRTSET2COUNTRY-CODE, GARN-CAT, TYPE—

Programs

Updated by (2)

Referenced by (20)