Lawson Insight Technical Documentation |
|
QUARTDED
QUARTDED FILE
Quarterly Deduction
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.
REFERENCED BY
BN232 BN335 BN66.1 PR139 PR140 PR189
PR50.1 PR50.4 PR50.3 PR80.1 PR89.1 HR170
HR70.1 PR240 PR241 PR242 PR243 PR244
PR245 PR249 PR251 PR266 PR52.2 PR252
PR297 PR299 PR287 PR290 PR291 PR292
PR294 PR248
UPDATED BY
BN305 ET530 HR11.1 HR11.2 HR511 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR195 PR197 PR300 PR560 PR82.1 PR85.1
UK560
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
QTD-COMPANY Numeric 4 ET530 PR195
Element: Company Hr PR197 PR560
PR82.1 PR85.1
UK560
QTD-EMPLOYEE Numeric 9 ET530 PR195
Element: Employee Contains the employee number. Each PR197 PR560
person employed by the company is PR82.1 PR85.1
assigned a unique number. The system UK560
uses the employee number to correlate
all of the information related to that
person.
QTD-PAYROLL-YEAR Numeric 4 ET530 PR195
Element: Payroll Year Contains the payroll year. PR197 PR560
PR82.1 PR85.1
UK560
QTD-QUARTER Numeric 1 ET530 PR195
Element: Quarter Contains the fiscal quarter for the PR197 PR560
data stored in this record. PR82.1 PR85.1
1 = First UK560
2 = Second
3 = Third
4 = Fourth
QTD-DED-CODE Alpha 4 ET530 PR195
Element: Ded Code Contains the deduction code associated PR197 PR560
with this record. PR82.1 PR85.1
UK560
QTD-PROCESS-LEVEL Alpha 5 ET530 PR195
Element: Process Lev HrThis field contains the tax reporting PR197 PR560
process level. PR82.1 PR85.1
UK560
QTD-WORK-STATE Alpha 2 ET530 PR195
Element: Work State Contains the work state associated with PR197 PR240
this record. PR241 PR242
PR299 PR560
PR82.1 PR85.1
UK560
QTD-DED-AMT Signed 13.2 ET530 PR195
Element: Ded Amt Contains the deduction amount PR197 PR560
associated with this record. PR82.1 PR85.1
UK560
QTD-TAX-WAGES Signed 13.2 ET530 PR195
Element: Tax Wages Contains the taxable wages associated PR197 PR50.1
with this deduction record. PR50.3 PR560
PR82.1 PR85.1
UK560
QTD-WAGE-AMOUNT Signed 13.2 ET530 PR195
Element: Wage Amount Contains the sum of all wage amounts PR197 PR560
from the time records. PR82.1 PR85.1
UK560
QTD-EXCESS Signed 13.2 ET530 PR195
Element: Excess Contains excess wages by deduction. PR197 PR560
PR82.1 PR85.1
UK560
QTD-DED-TAX-CAT Derived
Element: Ded Tax Cat
QTD-DED-TAX-AUTH Derived
Element: Ded Tax Auth
QTD-COUNTRY-CODE Alpha 2 ET530 PR195
Element: Country Code The country code. Required for VAT and PR197 PR560
intrastat reporting. Must be defined in PR82.1 PR85.1
IN01.1 (Country Maintenance). UK560
QTD-REPORT-ENTITY Alpha 5 ET530 PR195
Element: Report Entity Contains the report entity. PR197 PR560
PR82.1 PR85.1
Report Entity is the Process Level or UK560
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.
QTD-BUS-NBR-GRP Alpha 4 ET530 PR195
Element: Bus Nbr Grp Contains the business number group. PR197 PR560
PR82.1 PR85.1
UK560
QTD-QC-ENT-NBR-GRP Alpha 4 ET530 PR195
Element: Qc Ent Nbr GrpContains the Quebec enterprise number PR197 PR560
group. PR82.1 PR85.1
UK560
QTD-OBJ-ID Numeric 12 ET530 PR195
Element: Obj Id This is the object identifier. It is PR197 PR82.1
used to relate commitments or posted PR85.1
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.
QTD-CURRENCY-CODE Alpha 5 ET530 PR195
Element: Currency Code This field contains the company base PR197 PR560
currency code established in Company PR82.1 PR85.1
(GL10.1 ). UK560
QTD-CURR-ND Numeric 1 ET530 PR195
Element: Acct Nd The number of decimals assigned to a PR197 PR560
particular account as determined by the PR82.1 PR85.1
account currency. UK560
QTD-PENSION Alpha 1 ET530 PR195
Element: Pension " " = No PR197 PR560
Y = Yes PR82.1 PR85.1
UK560
QTD-HM-PROC-LEVEL Alpha 5 BN305 ET530
Element: Process Lev Hr HR11.1 HR11.2
HR511 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR110
PR113 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR195 PR197
PR560 PR82.1
PR85.1 UK560
QUARTDED FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
QTDSET1 COMPANY BN232 BN305
EMPLOYEE BN335 BN66.1
PAYROLL-YEAR ET530 HR11.1
QUARTER HR11.2 HR511
COUNTRY-CODE PA02.1 PA100
DED-CODE PA102 PA115
REPORT-ENTITY PA13.1 PA13.2
BUS-NBR-GRP PA502 PA513
QC-ENT-NBR-GRP PA52.1 PA52.3
PROCESS-LEVEL PA52.4 PA52.5
WORK-STATE PR110 PR113
PENSION PR120 PR13.1
PR13.5 PR13.6
PR13.8 PR139
PR140 PR189
...
QTDSET10 COMPANY KeyChange HR170 HR70.1
HM-PROC-LEVEL PR560 UK560
EMPLOYEE
PAYROLL-YEAR
QUARTER
COUNTRY-CODE
DED-CODE
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
QTDSET2 COMPANY KeyChange BN335 PR240
COUNTRY-CODE PR241 PR242
PAYROLL-YEAR PR243 PR244
EMPLOYEE PR245 PR249
DED-CODE PR251 PR266
QUARTER PR50.1 PR50.3
REPORT-ENTITY PR50.4 PR52.2
BUS-NBR-GRP PR560 UK560
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PENSION
QTDSET3 COMPANY KeyChange, Subset PR252 PR297
COUNTRY-CODE Where COUNTRY-CODE = "US" PR299
PAYROLL-YEAR And PENSION != "Y"
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL
DED-CODE
QUARTER
WORK-STATE
QTDSET4 COMPANY KeyChange, Subset PR287 PR290
COUNTRY-CODE Where COUNTRY-CODE = "US" PR291 PR292
PAYROLL-YEAR PR294
REPORT-ENTITY
PROCESS-LEVEL
EMPLOYEE
DED-CODE
QUARTER
WORK-STATE
PENSION
QTDSET5 COMPANY Subset PR248
COUNTRY-CODE Where COUNTRY-CODE = "CA"
PAYROLL-YEAR And PENSION != "Y"
EMPLOYEE
REPORT-ENTITY
BUS-NBR-GRP
PROCESS-LEVEL
DED-CODE
QUARTER
WORK-STATE
QC-ENT-NBR-GRP
QUARTDED FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
QTD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduction Code DEDCODE Required
QTD-COMPANY -> DDC-COMPANY
QTD-DED-CODE -> DDC-DED-CODE
Employee EMPLOYEE Required
QTD-COMPANY -> EMP-COMPANY
QTD-EMPLOYEE -> EMP-EMPLOYEE
Process Level PRSYSTEM Required
QTD-COMPANY -> PRS-COMPANY
QTD-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Prqcentgrp PRQCENTGRP Not Required
QTD-COMPANY -> PQC-COMPANY
QTD-PROCESS-LEVEL -> PQC-PROCESS-LEVEL
QTD-QC-ENT-NBR-GRP -> PQC-QC-ENT-NBR-GRP
Tax Authority PRTAXAUTH Required
When DDC-CALC-TYPE = "T"
DDC-TAX-ID-CODE -> PRX-TAX-ID-CODE
Work State PRSTATE Required
When QTD-WORK-STATE != Spaces
QTD-WORK-STATE -> PSA-STATE
QUARTDED FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Prdeddtl PRDEDDTL
QTD-OBJ-ID -> PDE-QTD-OBJ-ID
PDE-TAX-STATUS
PDE-PYD-OBJ-ID
|