# Table: Employee YTD Summaries

Table: CPYTDS
View: CP0047
Record length: 70
Flags: A R

## Keys: 4

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

## Fields: 12

Field | Type | Title | Presentation
--- | --- | --- | ---
YEARYTDS | Integer | Year |
EMPLOYEE | String*12 | Employee | Mask: %-12N
EARNDED | String*6 | Earning/Deduction | Mask: %-6N
EARDEDCLAS | Integer | Earning/Deduction Class | 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
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CATEGORY | Integer | Category | 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 | Integer | Earning/Deduction Type | 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 | BCD*10.3 | Sum of All Unposted Amounts |
POSTEDAMT | BCD*10.3 | Sum of All YTD Posted Amounts |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.