Table: Earnings Hourly Report

Table: UPEHRP
View: UP0093
Record length: 184
Flags: A R 

Keys: 2

Title  Flags  Fields

Employee  RPTTIME, RPTSUMRY, EMPLOYEE, SORTORDER, PLINETYPE, EARNDED, LINETYPE, CLASSSUM, CLASS
Class  RPTTIME, RPTSUMRY, CLASS, CLASSSUM, EMPLOYEE, SORTORDER, PLINETYPE, EARNDED, LINETYPE

Fields: 23

Field  Type  Title  Presentation 

RPTTIME  Long  Time   
RPTSUMRY  Boolean  Report Summary   
EMPLOYEE  String*12  Employee  Mask: %-12N
SORTORDER  Integer  Sort Order  List: 16 entries
1=n/a
2=Earning
3=Gross Pay
4=Cash Benefit
5=Total Earnings
6=Expense Reimbursemnt
7=Cash Advance
8=Taxes and Deductions
9=Net Pay
10=NonCash Item
11=NonCash Advance
12=Accural
13=Hours
14=Hours
15=Pieces
16=Sales
PLINETYPE  Integer  P Line Type  List: 42 entries
11=CHKD Regular Line
11=CHKD Overtime Line
11=CHKD Shift Diff Line
14=CHKD Disbursed Tips
15=CHKD Vacation Payment
16=CHKD Sick Payment
17=CHKD Comp. Time Payment
21=CHKD Deduction Entry
31=CHKD Federal Income Entry
32=CHKD Federal Insurance Entry
33=CHKD Federal UI Entry
34=CHKD Federal Pension Entry
35=CHKD Federal Health Entry
36=CHKD Federal Other Entry
41=CHKD State Income Entry
42=CHKD State Insurance Entry
43=CHKD State UI Entry
44=CHKD State Pension Entry
45=CHKD State Health Entry
46=CHKD State Other Entry
51=CHKD Local Income Entry
52=CHKD Local Insurance Entry
53=CHKD Local UI Entry
54=CHKD Local Pension Entry
55=CHKD Local Health Entry
56=CHKD Local Other Entry
61=CHKD User Income Entry
62=CHKD User Insurance Entry
63=CHKD User UI Entry
64=CHKD User Pension Entry
65=CHKD User Health Entry
66=CHKD User Other Entry
71=CHKD Exp Reimbursement
72=CHKD Cash Advance
73=CHKD Reported Tips
74=CHKD Allocated Tips
75=CHKD Noncash Advance
76=CHKD Vac Accrual
77=CHKD Sick Accrual
78=CHKD Comp Accrual
81=CHKD Cash Benefit
82=CHKD Noncash Benefit
EARNDED  String*6  E/D or Tax  Mask: %-6N
LINETYPE  Integer  Line Type  List: 9 entries
1=Payment
2=Accrual
3=Regular
4=Overtime
5=Shift Differential
6=n/a
7=Normal Withholding
8=Backup Withholding
9=Supplemental Withholding
CLASSSUM  Boolean  Class Summary Line   
CLASS  String*6  Class Code  Mask: %-6N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
MONTHAMT  BCD*10.3  Month Amt   
QUARTERAMT  BCD*10.3  Quarter Amt   
YEARAMT  BCD*10.3  Year Amt   
MHOURS  BCD*9.3  Month Hours   
QHOURS  BCD*9.3  Quarter Hours   
YHOURS  BCD*9.3  Year Hours   
LASTNAME  String*20  Last Name   
FIRSTNAME  String*15  First Name   
MIDDLENAME  String*15  Middle Name   
SHORTDESC  String*15  Description   

This page was generated on 2008-May-02

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