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
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
QTD-COMPANY Element: Company Hr | Numeric 4 |
|
||||||||||
QTD-EMPLOYEE Element: Employee | Numeric 9 Contains 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. |
|
||||||||||
QTD-PAYROLL-YEAR Element: Payroll Year | Numeric 4 Contains the payroll year. |
|
||||||||||
QTD-QUARTER Element: Quarter | Numeric 1 Contains the fiscal quarter for the data stored in this record. 1 = First 2 = Second 3 = Third 4 = Fourth |
|
||||||||||
QTD-DED-CODE Element: Ded Code | Alpha 4 Contains the deduction code associated with this record. |
|
||||||||||
QTD-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 This field contains the tax reporting process level. |
|
||||||||||
QTD-WORK-STATE Element: Work State | Alpha 2 Contains the work state associated with this record. |
|
||||||||||
QTD-DED-AMT Element: Ded Amt | Signed 13.2 Contains the deduction amount associated with this record. |
|
||||||||||
QTD-TAX-WAGES Element: Tax Wages | Signed 13.2 Contains the taxable wages associated with this deduction record. |
|
||||||||||
QTD-WAGE-AMOUNT Element: Wage Amount | Signed 13.2 Contains the sum of all wage amounts from the time records. |
|
||||||||||
QTD-EXCESS Element: Excess | Signed 13.2 Contains excess wages by deduction. |
|
||||||||||
QTD-DED-TAX-CAT Element: Ded Tax Cat | Derived |
|
||||||||||
QTD-DED-TAX-AUTH Element: Ded Tax Auth | Derived |
|
||||||||||
QTD-COUNTRY-CODE Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||||||||||
QTD-REPORT-ENTITY Element: Report Entity | Alpha 5 Contains 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. |
|
||||||||||
QTD-BUS-NBR-GRP Element: Bus Nbr Grp | Alpha 4 Contains the business number group. |
|
||||||||||
QTD-QC-ENT-NBR-GRP Element: Qc Ent Nbr Grp | Alpha 4 Contains the Quebec enterprise number group. |
|
||||||||||
QTD-OBJ-ID Element: Obj Id | Numeric 12 This 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. |
|
||||||||||
QTD-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||
QTD-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||
QTD-PENSION Element: Pension | Alpha 1 " " = No Y = Yes |
|
||||||||||
QTD-HM-PROC-LEVEL Element: Process Lev Hr | Alpha 5 |
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
QTDSET1 |
COMPANY EMPLOYEE PAYROLL-YEAR QUARTER COUNTRY-CODE DED-CODE REPORT-ENTITY BUS-NBR-GRP QC-ENT-NBR-GRP PROCESS-LEVEL WORK-STATE PENSION |
|
| ||||||||||||||||||||||||||||||||||||
QTDSET10 |
COMPANY HM-PROC-LEVEL EMPLOYEE PAYROLL-YEAR QUARTER COUNTRY-CODE DED-CODE REPORT-ENTITY BUS-NBR-GRP QC-ENT-NBR-GRP PROCESS-LEVEL WORK-STATE PENSION |
|
| ||||||||||||||||||||||||||||||||||||
QTDSET2 |
COMPANY COUNTRY-CODE PAYROLL-YEAR EMPLOYEE DED-CODE QUARTER REPORT-ENTITY BUS-NBR-GRP QC-ENT-NBR-GRP PROCESS-LEVEL WORK-STATE PENSION |
|
| ||||||||||||||||||||||||||||||||||||
QTDSET3 |
COMPANY COUNTRY-CODE PAYROLL-YEAR EMPLOYEE REPORT-ENTITY PROCESS-LEVEL DED-CODE QUARTER WORK-STATE |
|
| ||||||||||||||||||||||||||||||||||||
QTDSET4 |
COMPANY COUNTRY-CODE PAYROLL-YEAR REPORT-ENTITY PROCESS-LEVEL EMPLOYEE DED-CODE QUARTER WORK-STATE PENSION |
|
| ||||||||||||||||||||||||||||||||||||
QTDSET5 |
COMPANY COUNTRY-CODE PAYROLL-YEAR EMPLOYEE REPORT-ENTITY BUS-NBR-GRP PROCESS-LEVEL DED-CODE QUARTER WORK-STATE QC-ENT-NBR-GRP |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Company | PRSYSTEM |
Required
| |||||||||
Deduction Code | DEDCODE |
Required
| |||||||||
Employee | EMPLOYEE |
Required
| |||||||||
Process Level | PRSYSTEM |
Required
| |||||||||
Prqcentgrp | PRQCENTGRP |
Not Required
| |||||||||
Tax Authority | PRTAXAUTH |
Required
| |||||||||
Work State | PRSTATE |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Prdeddtl | PRDEDDTL |
|
All trademarks and registered trademarks are the property of their
respective owners.