# Table: Cheque Details

Table: CPCHKD
View: CP0049
Record length: 481
Flags: A R

## Keys: 2

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

## Fields: 55

Field | Type | Title | Presentation
--- | --- | --- | ---
EMPLOYEE | String*12 | Employee | Mask: %-12N
PEREND | Date | Period End Date |
ENTRYSEQ | Long | Entry Sequence |
CATEGORY | Integer | Category | 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 | String*6 | Earning/Deduction-Tax | Mask: %-6N
LINETYPE | Integer | 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 |  |
EARDEDTYPE | Integer | Earning/Deduction-Tax Type | 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 | Date | Earning/Deduction Date |
HOURS | BCD*4.3 | Hours |
ECNTBASE | BCD*10.3 | Employee Pieces/Sales/Base |
ERATE | BCD*9.5 | Employee Rate/Amt/Pct |
EEXTEND | BCD*10.3 | Employee Extended Amount |
EREGRATE | BCD*9.5 | Regular Rate |
RCNTBASE | BCD*10.3 | Employer Pieces/Base |
RRATE | BCD*9.5 | Employer Amt/Pct |
REXTEND | BCD*10.3 | Employer Extended Amount |
EXPACCT | String*45 | Regular Pay Expense G/L Account |
ELIABACCT | String*45 | Employee Liability G/L Account |
RLIABACCT | String*45 | Employer Liability G/L Account |
WCC | String*6 | Workers' Compensation Code |
GLSEG1 | String*15 | Cost Center Segment One |
GLSEG2 | String*15 | Cost Center Segment Two |
GLSEG3 | String*15 | Cost Center Segment Three |
PARTIAL | Boolean | Detail Was Partially Taken or Not |
TAXWEEKS | BCD*4.3 | RESERVED - US Only |
TAXEARNS | BCD*10.3 | No Ceiling Wage |
TXEARNCEIL | BCD*10.3 | Ceiling Wage |
TAXTIPS | BCD*10.3 | RESERVED - US Only |
TXTIPSCEIL | BCD*10.3 | RESERVED - US Only |
TAXONTIPS | BCD*10.3 | RESERVED - US Only |
UNCOLLTAX | BCD*10.3 | RESERVED - US Only |
PCATEGORY | Integer | Print Category | List: 5 entries
1 | = | CHKD Earnings
2 | = | CHKD Deductions
3 | = | CHKD Taxes
4 | = | CHKD Other
5 | = | CHKD Benefits
PLINETYPE | Integer | Print 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
PCONTENTS | Integer | Print Line Contents | 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 | BCD*10.3 | Non-periodic Payment |
TAXEARNBD | BCD*10.3 | Earnings before Deductions |
POOLEDTIPS | BCD*10.3 | Pooled Tips |
DETAILDATE | Date | Detail Date |
STARTTIME | Integer | Start Time |
STOPTIME | Integer | Stop Time |
WCCGROUP | String*6 | Workers Comp. Group |
VALUES | Long | Number of Optional Fields |
SWFLSA | Boolean | Included in Regular Rate OT Calc |
DAYS | Integer | Days Worked |
OTSCHED | String*6 | Overtime Schedule | Mask: %-6N
OTHOURS | BCD*4.3 | Overtime Hours Override |
STAMOUNT | BCD*10.3 | Straight Time Earnings |
PREMIUMRT | BCD*5.5 | Overtime Rate Multiplier |
JOBS | Long | Jobs |
WORKCODE | String*6 | Work Classification Code |

This page was generated on 2009-Nov-19

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