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: 73

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 = Disability
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 A P X  Mask: %-6N
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 A P X  Mask: %-6N
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 
LOCTAXCODE 52 String*10 RESERVED - US Only E A X 
WCBASE 53 BCD*10.3 WC Base A X 
WCRATE 54 BCD*6.6 WC Rate A X 
WCEXTEND 55 BCD*10.5 WC Assessment A C X 
WCEXPACCT 56 String*45 WC Expense Account E A X 
WCLIABACCT 57 String*45 WC Liability Account E A X 
CSEFTSTAT 58 Integer Child Support EFT Status E A X  List:2 entries
0 = Not EFTed
1 = EFTed
DISTCODE 59 String*6 Distribution Code E A  Mask: %-6N
DISTRNAME 60 String*15 Distribution Description E A 
GLSEG4 61 String*15 Cost Center Segment Four E A C X 
GLSEG5 62 String*15 Cost Center Segment Fix E A C X 
GLSEG6 63 String*15 Cost Center Segment Six E A C X 
TAXNONDED 64 BCD*10.3 Non-periodic Deduction E A X 
TAXREPAY 65 BCD*10.3 Repayment Deduction Before Tax E A X 
PROCESSCMD 100 Integer Process Command Code E A C  List:5 entries
0 = No Action
1 = Insert Optional Fields
2 = Calculate Workers' Compensation
3 = Post YTDS
9 = Clear Cache
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 
CHECKDATE 107 Date Check Date E A C 

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