Table: Print Cheques Detail Extension

Table: CPPCKD
View: CP0080
Record Length: 161

Flags: A R 

Keys: 2

Title Flags Fields
Sort Code SORTCODE, CATEGORY, EARNDED, LINETYPE, LINENO
Print Order SORTCODE, PCATEGORY, PLINETYPE, EARNDED, LINETYPE, LINENO

Fields: 23

Field Type Title Presentation
SORTCODE BCD*10.0 Sort Code
CATEGORY Integer Category 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 String*6 Earning/Deduction/Tax Code 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
LINENO Integer Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
SHORTDESC String*15 Short Desc
HOURS BCD*4.3 Number of Hours
ECNTBASE BCD*10.3 Base Amount
RATEFMT Integer Rate Format
RATE BCD*9.5 Hourly Rate/Percent/Amount
CURRAMT BCD*10.3 Current Amount
YTDAMT BCD*10.3 YTD Amount
BALANCE BCD*10.3 Accrual Balance
PCATEGORY Integer Printing Category List:6 entries
1 = CHKD Earnings
2 = CHKD Deductions
3 = CHKD Taxes
4 = CHKD Other
5 = CHKD Benefits
6 = CHKE EFT Entries
PLINETYPE Integer Printing Line type 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 BCD*10.3 Pooled Tips
DISTCODE String*6 Distribution Code Mask: %-6N
DISTRNAME String*15 Distribution Description
OYTDAMT BCD*10.3 Other YTD Amount - RESERVED

This page was generated on 2022-Aug-18

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