View: Earnings Hourly Report

RotoID: UP0093
Table: UPEHRP
Protocol: Flat
DLL:UPEHRP

Keys: 2

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

Fields: 19

Field Index Type Title Attributes Presentation
RPTTIME 1 Long Time E A K R 
RPTSUMRY 2 Boolean Report Summary E A K R 
EMPLOYEE 3 String*12 Employee E A K R  Mask: %-12N
SORTORDER 4 Integer Sort Order E A K R  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 5 Integer P Line Type E A K R  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 6 String*6 E/D or Tax E A K R  Mask: %-6N
LINETYPE 7 Integer Line Type E A K R  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 8 Boolean Class Summary Line E A K R 
CLASS 9 String*6 Class Code E A K R  Mask: %-6N
MONTHAMT 10 BCD*10.3 Month Amt E A 
QUARTERAMT 11 BCD*10.3 Quarter Amt E A 
YEARAMT 12 BCD*10.3 Year Amt E A 
MHOURS 13 BCD*9.3 Month Hours E A 
QHOURS 14 BCD*9.3 Quarter Hours E A 
YHOURS 15 BCD*9.3 Year Hours E A 
LASTNAME 16 String*20 Last Name E A 
FIRSTNAME 17 String*15 First Name E A 
MIDDLENAME 18 String*15 Middle Name E A 
SHORTDESC 19 String*15 Description E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).