Table: Employee YTD Summaries

Table: UPYTDS
View: UP0047
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: 15 entries
1=Salary & Wages
2=Reported Tips
3=Allocated Tips
7=Vacation
8=Sick
9=Compensatory Time
13=Cash
14=Noncash
18=Insurance Tax
19=Income Tax
20=Unemployment 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 2008-May-02

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