# 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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.