QUARTDED – Quarterly Deduction

System
Payroll (PR)
Prefix
QTD
Primary key
COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, DED-CODE, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSION
Fields
22
Updated by
43 programs
Referenced by
34 programs

QUARTDED is the Quarterly Deduction table in Lawson Payroll (prefix QTD). It is indexed by COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, DED-CODE, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSION (QTDSET1); alternate indexes: QTDSET10, QTDSET2, QTDSET3, QTDSET4 and QTDSET5. It is related 1:1 to PRSYSTEM, DEDCODE, EMPLOYEE, PRQCENTGRP, PRTAXAUTH and PRSTATE and 1:M to PRDEDDTL. It is updated by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 and 35 more and referenced by BN232, BN335, BN66.1, HR170, HR70.1, PR11.3, PR11.5, PR139 and 26 more. The table has 22 fields, 6 indexes and 8 documented relations.

About QUARTDED

This file contains all deduction history for an employee, summarized by quarter, and is updated every time you run PR199 (Payroll Close) to close a payroll cycle. One of the primary functions of this file is to produce W-2 information. Therefore, deduction history for an employee is stored by work state, process level, and department. Creating records by process level is necessary to accommodate tax processing by process level, and including department level storage enables reporting summary totals by department.

Fields (22)

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

Field / columnTypeDescription & valuesUpdated by
QTD-COMPANY PK
COMPANY		Numeric 4—PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-PAYROLL-YEAR PK
PAYROLL_YEAR		Numeric 4Contains the payroll year.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-QUARTER PK
QUARTER		Numeric 1Contains the fiscal quarter for the data stored in this record.
  • 1 First
  • 2 Second
  • 3 Third
  • 4 Fourth
PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-DED-CODE PK
DED_CODE		Alpha 4Contains the deduction code associated with this record.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5This field contains the tax reporting process level.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-WORK-STATE PK
WORK_STATE		Alpha 2Contains the work state associated with this record.PR195, PR197, PR240, PR241, PR242, PR299, PR560, PR582 +2 more
QTD-DED-AMT
DED_AMT		Signed 13.2Contains the deduction amount associated with this record.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-TAX-WAGES
TAX_WAGES		Signed 13.2Contains the taxable wages associated with this deduction record.PR195, PR197, PR50.1, PR50.3, PR560, PR582, PR82.1, PR85.1 +1 more
QTD-WAGE-AMOUNT
WAGE_AMOUNT		Signed 13.2Contains the sum of all wage amounts from the time records.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-EXCESS
EXCESS		Signed 13.2Contains excess wages by deduction.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-DED-TAX-CAT
DED_TAX_CAT		Derived——
QTD-DED-TAX-AUTH
DED_TAX_AUTH		Derived——
QTD-COUNTRY-CODE PK
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-REPORT-ENTITY PK
REPORT_ENTITY		Alpha 5Contains the report entity. Report Entity is the Process Level or Company that this Process Level reports to for tax reporting. If the Process Level itself is independent then the independent Process Level is the Report Entity. If the Process Level is non independent and is associated to a independent head Process Level then the independent head Process Level is the Report Entity. If the Process Level is non independent and is not associated to a independent head Process Level then the Company is the Report Entity.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-BUS-NBR-GRP PK
BUS_NBR_GRP		Alpha 4Contains the business number group.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-QC-ENT-NBR-GRP PK
QC_ENT_NBR_GRP		Alpha 4Contains the Quebec enterprise number group.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-OBJ-ID
OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.PR195, PR197, PR582, PR82.1, PR85.1
QTD-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-PENSION PK
PENSION		Alpha 1" " = No
  • Y Yes
PR195, PR197, PR560, PR582, PR82.1, PR85.1
QTD-HM-PROC-LEVEL
HM_PROC_LEVEL		Alpha 5—BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +30 more

Indexes (6)

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

IndexKeysFlagsConditionUsed in
QTDSET1COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, DED-CODE, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSIONPrimaryBN232, BN305, BN335, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1 +22 more (list truncated in source)
QTDSET10COMPANY, HM-PROC-LEVEL, EMPLOYEE, PAYROLL-YEAR, QUARTER, COUNTRY-CODE, DED-CODE, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSIONKeyChangeHR170, HR70.1, PR560
QTDSET2COMPANY, COUNTRY-CODE, PAYROLL-YEAR, EMPLOYEE, DED-CODE, QUARTER, REPORT-ENTITY, BUS-NBR-GRP, QC-ENT-NBR-GRP, PROCESS-LEVEL, WORK-STATE, PENSIONKeyChangeBN335, BN66.1, PR11.3, PR11.5, PR140, PR189, PR195, PR240 +19 more
QTDSET3COMPANY, COUNTRY-CODE, PAYROLL-YEAR, EMPLOYEE, REPORT-ENTITY, PROCESS-LEVEL, DED-CODE, QUARTER, WORK-STATEKeyChange, SubsetWhere COUNTRY-CODE = "US" And PENSION != "Y"PR252, PR297, PR299
QTDSET4COMPANY, COUNTRY-CODE, PAYROLL-YEAR, REPORT-ENTITY, PROCESS-LEVEL, EMPLOYEE, DED-CODE, QUARTER, WORK-STATE, PENSIONKeyChange, SubsetWhere COUNTRY-CODE = "US"PR287, PR290, PR291, PR292, PR294
QTDSET5COMPANY, COUNTRY-CODE, PAYROLL-YEAR, EMPLOYEE, REPORT-ENTITY, BUS-NBR-GRP, PROCESS-LEVEL, DED-CODE, QUARTER, WORK-STATE, QC-ENT-NBR-GRPSubsetWhere COUNTRY-CODE = "CA" And PENSION != "Y"PR248

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredQTD-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Deduction CodeDEDCODERequiredQTD-COMPANY → DDC-COMPANY, QTD-DED-CODE → DDC-DED-CODE
EmployeeEMPLOYEERequiredQTD-COMPANY → EMP-COMPANY, QTD-EMPLOYEE → EMP-EMPLOYEE
Process LevelPRSYSTEMRequiredQTD-COMPANY → PRS-COMPANY, QTD-PROCESS-LEVEL → PRS-PROCESS-LEVEL
PrqcentgrpPRQCENTGRPNot RequiredQTD-COMPANY → PQC-COMPANY, QTD-PROCESS-LEVEL → PQC-PROCESS-LEVEL, QTD-QC-ENT-NBR-GRP → PQC-QC-ENT-NBR-GRP
Tax AuthorityPRTAXAUTHRequiredWhen DDC-CALC-TYPE = "T"DDC-TAX-ID-CODE → PRX-TAX-ID-CODE
Work StatePRSTATERequiredWhen QTD-WORK-STATE != SpacesQTD-WORK-STATE → PSA-STATE

One to many (1) — child tables

RelationTableRulesConditionField map
PrdeddtlPRDEDDTLQTD-OBJ-ID → PDE-QTD-OBJ-ID, → PDE-TAX-STATUS, → PDE-PYD-OBJ-ID

Programs

Updated by (43)

Referenced by (34)