# View: Cheque Details

RotoID: CP0049
Table: CPCHKD
Protocol: Detail, Ordered revisions
DLL: CPCHKD

## Compositions: 3

RotoID | Tables | Title | DLL
--- | --- | --- | ---
CP0048 | CPCHKH | Cheque Header | CPCHKH
CP0134 | CPCHDO | Cheque Details Optional Fields | CPCHDO
CP0056 | CPCHJB | Cheque Job Details | CPCHJB

## Keys: 2

Title | Fields
--- | ---
Employee | EMPLOYEE, PEREND, ENTRYSEQ, CATEGORY, EARNDED, LINETYPE, LINENO
Print Order | EMPLOYEE, PEREND, ENTRYSEQ, PCATEGORY, PLINETYPE, EARNDED, LINETYPE, LINENO

## Fields: 58

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
EMPLOYEE | 1 | String*12 | Employee | E A K R | Mask: %-12N
PEREND | 2 | Date | Period End Date | E A K R |
ENTRYSEQ | 3 | Long | Entry Sequence | E A K R |
CATEGORY | 4 | Integer | Category | E A K R | List: 10 entries
1 | = | Accrual
2 | = | Earning
3 | = | Advance
4 | = | Deduction
5 | = | Expense Reimbursement
6 | = | Benefit
7 | = | Federal Tax
8 | = | Provincial Tax
9 | = | Local Tax
10 | = | User Tax
EARNDED | 5 | String*6 | Earning/Deduction-Tax | E A K R | Mask: %-6N
LINETYPE | 6 | Integer | Type | E A K R X | 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
LINENO | 7 | Integer | Line Number | E A K R |
EARDEDTYPE | 8 | Integer | Earning/Deduction-Tax Type | E A C X | List: 16 entries
1 | = | Salary & Wages
2 | = | Reported Tips
3 | = | Allocated Tips
7 | = | Vacation
8 | = | Sick
9 | = | Banked Time
10 | = |
13 | = | Cash
14 | = | Noncash
18 | = | Insurance Tax
19 | = | Income Tax
20 | = | Employment Tax
21 | = | Pension Plan Tax
22 | = | Health Tax
23 | = | Other Tax
25 | = | n/a
EARDEDDATE | 9 | Date | Earning/Deduction Date | E A X |
HOURS | 10 | BCD*4.3 | Hours | E A X |
ECNTBASE | 11 | BCD*10.3 | Employee Pieces/Sales/Base | E A X |
ERATE | 12 | BCD*9.5 | Employee Rate/Amt/Pct | E A X |
EEXTEND | 13 | BCD*10.3 | Employee Extended Amount | E A X |
EREGRATE | 14 | BCD*9.5 | Regular Rate | E A X |
RCNTBASE | 15 | BCD*10.3 | Employer Pieces/Base | E A X |
RRATE | 16 | BCD*9.5 | Employer Amt/Pct | E A X |
REXTEND | 17 | BCD*10.3 | Employer Extended Amount | E A X |
EXPACCT | 18 | String*45 | Regular Pay Expense G/L Account | E A |
ELIABACCT | 19 | String*45 | Employee Liability G/L Account | E A |
RLIABACCT | 20 | String*45 | Employer Liability G/L Account | E A |
WCC | 21 | String*6 | Workers' Compensation Code | P X |
GLSEG1 | 22 | String*15 | Cost Center Segment One | E A C X |
GLSEG2 | 23 | String*15 | Cost Center Segment Two | E A C X |
GLSEG3 | 24 | String*15 | Cost Center Segment Three | E A C X |
PARTIAL | 25 | Boolean | Detail Was Partially Taken or Not | E A |
TAXWEEKS | 26 | BCD*4.3 | RESERVED - US Only | E A X |
TAXEARNS | 27 | BCD*10.3 | No Ceiling Wage | E A X |
TXEARNCEIL | 28 | BCD*10.3 | Ceiling Wage | E A X |
TAXTIPS | 29 | BCD*10.3 | RESERVED - US Only | E A X |
TXTIPSCEIL | 30 | BCD*10.3 | RESERVED - US Only | E A X |
TAXONTIPS | 31 | BCD*10.3 | RESERVED - US Only | E A X |
UNCOLLTAX | 32 | BCD*10.3 | RESERVED - US Only | E A X |
PCATEGORY | 33 | Integer | Print Category | A C | List: 5 entries
1 | = | CHKD Earnings
2 | = | CHKD Deductions
3 | = | CHKD Taxes
4 | = | CHKD Other
5 | = | CHKD Benefits
PLINETYPE | 34 | Integer | Print Line Type | A C | 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
PCONTENTS | 35 | Integer | Print Line Contents | A C | List: 5 entries
1 | = | CHKD Employee Only
2 | = | CHKD Both EmpE And EmpR
3 | = | CHKD Employer Only
4 | = | CHKD Historical Entry
5 | = | CHKD Tax Info Only Entry
TAXNONPER | 36 | BCD*10.3 | Non-periodic Payment | E A X |
TAXEARNBD | 37 | BCD*10.3 | Earnings before Deductions | E A X |
POOLEDTIPS | 38 | BCD*10.3 | Pooled Tips | E A X |
DETAILDATE | 39 | Date | Detail Date | E A |
STARTTIME | 40 | Integer | Start Time | E A X |
STOPTIME | 41 | Integer | Stop Time | E A X |
WCCGROUP | 42 | String*6 | Workers Comp. Group | P X |
VALUES | 43 | Long | Number of Optional Fields | E A C |
SWFLSA | 44 | Boolean | Included in Regular Rate OT Calc | E A |
DAYS | 45 | Integer | Days Worked | E A X |
OTSCHED | 46 | String*6 | Overtime Schedule | E A | Mask: %-6N
OTHOURS | 47 | BCD*4.3 | Overtime Hours Override | E A X |
STAMOUNT | 48 | BCD*10.3 | Straight Time Earnings | E A |
PREMIUMRT | 49 | BCD*5.5 | Overtime Rate Multiplier | E A |
JOBS | 50 | Long | Jobs | C X |
WORKCODE | 51 | String*6 | Work Classification Code | X |
PROCESSCMD | 100 | Integer | Process Command Code | E A C | List: 2 entries
0 | = | No Action
1 | = | Insert Optional Fields
DTLTYPE | 101 | Integer | Detail Type | E A C | List: 2 entries
1 | = | Earning/Deduction
2 | = | Tax
ECALCMETH | 102 | Integer | Employee Calculation Method | E A C |
RCALCMETH | 103 | Integer | Employer Calculation Method | E A C |
HTAXSIDE | 104 | Integer | History Entry - Tax Side | E A C | List: 4 entries
0 | = | Not Applicable
1 | = | Employer Tax
2 | = | Employee Tax
3 | = | Employee and Employer Tax
TAXEARNSNT | 105 | BCD*10.3 | RESERVED - US Only | E A X |
TXEARNCLNT | 106 | BCD*10.3 | RESERVED - US Only | E A X |

This page was generated on 2009-Nov-19

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