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  Integer  Year  E A K R   
EMPLOYEE  String*12  Employee  E A K R  Mask: %-12N
EARNDED  String*6  Earning/Deduction  E A K R  Mask: %-6N
EARDEDCLAS  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  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  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  BCD*10.3  Sum of All Unposted Amounts  E A   
POSTEDAMT  BCD*10.3  Sum of All YTD Posted Amounts  E A   

This page was generated on 2008-May-02

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