Table: Earnings Hourly Report

Table: CPEHRP
View: CP0093
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 EI 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 EI 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 EI 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 EI 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 2023-Aug-31

© 2023 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).