View: Print Cheques Detail Extension

RotoID: CP0080
Table: CPPCKD
Protocol: Detail
DLL:CPPCKD

Compositions: 1

RotoID Tables Title DLL

CP0079 CPPCKH Print Cheques Header Extension CPPCKH

Keys: 2

Title Fields

Sort Code SORTCODECATEGORYEARNDEDLINETYPELINENO
Print Order SORTCODEPCATEGORYPLINETYPEEARNDEDLINETYPELINENO

Fields: 19

Field Index Type Title Attributes Presentation

SORTCODE 1 BCD*10.0 Sort Code E A K R 
CATEGORY 2 Integer Category E A K R  List:11 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
11 = EFT Entry
EARNDED 3 String*6 Earning/Deduction/Tax Code E A K R  Mask: %-6N
LINETYPE 4 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
LINENO 5 Integer Line Number E A K R 
SHORTDESC 6 String*15 Short Desc E A 
HOURS 7 BCD*4.3 Number of Hours E A 
ECNTBASE 8 BCD*10.3 Base Amount E A 
RATEFMT 9 Integer Rate Format E A 
RATE 10 BCD*9.5 Hourly Rate/Percent/Amount E A 
CURRAMT 11 BCD*10.3 Current Amount E A 
YTDAMT 12 BCD*10.3 YTD Amount E A 
BALANCE 13 BCD*10.3 Accrual Balance E A 
PCATEGORY 14 Integer Printing Category E A  List:6 entries
1 = CHKD Earnings
2 = CHKD Deductions
3 = CHKD Taxes
4 = CHKD Other
5 = CHKD Benefits
6 = CHKE EFT Entries
PLINETYPE 15 Integer Printing Line type E A  List:45 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
91 = CHKE EFT Entry - Fixed Amount
92 = CHKE EFT Entry - % of Gross Earnings
93 = CHKE EFT Entry - % of Net Pay
POOLEDTIPS 16 BCD*10.3 Pooled Tips E A 
DISTCODE 17 String*6 Distribution Code E A  Mask: %-6N
DISTRNAME 18 String*15 Distribution Description E A 
OYTDAMT 19 BCD*10.3 Other YTD Amount - RESERVED E A