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=State 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 2003-May-05

Copyright © 2003 ACCPAC International, Inc. All rights reserved.