# View: Employee YTD Summaries

RotoID: CP0047
Table: CPYTDS
Protocol: Flat
DLL: CPYTDS

## Compositions: 0

## Keys: 4

Title | Fields
--- | ---
Year Summaries | YEARYTDS, EMPLOYEE, EARNDED, EARDEDCLAS
YTD Summaries by Category | YEARYTDS, EMPLOYEE, CATEGORY, EARNDED, EARDEDCLAS
YTD Summaries by Employee | EMPLOYEE, YEARYTDS, EARNDED, EARDEDCLAS
YTD by Earning/Deduction | EARNDED

## Fields: 8

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
YEARYTDS | 1 | Integer | Year | E A K R |
EMPLOYEE | 2 | String*12 | Employee | E A K R | Mask: %-12N
EARNDED | 3 | String*6 | Earning/Deduction | E A K R | Mask: %-6N
EARDEDCLAS | 4 | Integer | Earning/Deduction Class | E A K R | List: 20 entries
1 | = | YTD Amount
2 | = | Employer Contribution
3 | = | Wages Subject To
4 | = | Wages Subject To, Ceiling
5 | = | Not Withheld
6 | = | Tips Subject To
7 | = | Tips Subject To, Ceiling
8 | = | Tax On Tips
9 | = | Base Hours
10 | = | Base Count
11 | = | Base Amount
12 | = | Base Sales
16 | = | Weeks Worked
17 | = | Hours Worked
18 | = | Backup Withholding
13 | = | Accrued Dollars
14 | = | Accrued Hours
15 | = | Accrued Hours Paid
19 | = | Taxable Non-periodic Earnings
20 | = | Subject to Income tax before deductions
CATEGORY | 5 | Integer | Category | E A | List: 10 entries
1 | = | Accrual
2 | = | Earning
3 | = | Advance
4 | = | Deduction
5 | = | Expense Reimbursement
6 | = | Benefit
7 | = | Federal Tax
8 | = | Provincial Tax
9 | = | Local Tax
10 | = | User Tax
EARDEDTYPE | 6 | Integer | Earning/Deduction Type | E A | List: 16 entries
1 | = | Salary & Wages
2 | = | Reported Tips
3 | = | Allocated Tips
7 | = | Vacation
8 | = | Sick
9 | = | Banked Time
10 | = |
13 | = | Cash
14 | = | Noncash
18 | = | Insurance Tax
19 | = | Income Tax
20 | = | Employment Tax
21 | = | Pension Plan Tax
22 | = | Health Tax
23 | = | Other Tax
25 | = | n/a
UNPSTEDAMT | 7 | BCD*10.3 | Sum of All Unposted Amounts | E A |
POSTEDAMT | 8 | BCD*10.3 | Sum of All YTD Posted Amounts | E A |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.