Table: Cheque Details

Table: CPCHKD
View: CP0049
Record Length: 695

Flags: A R 

Keys: 2

Title Flags Fields

Employee EMPLOYEEPERENDENTRYSEQCATEGORYEARNDEDLINETYPELINENO
Print Order EMPLOYEEPERENDENTRYSEQPCATEGORYPLINETYPEEARNDEDLINETYPELINENO

Fields: 69

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 = 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 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 Mask: %-6N
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 Mask: %-6N
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
LOCTAXCODE String*10 RESERVED - US Only
WCBASE BCD*10.3 WC Base
WCRATE BCD*6.6 WC Rate
WCEXTEND BCD*10.5 WC Assessment
WCEXPACCT String*45 WC Expense Account
WCLIABACCT String*45 WC Liability Account
CSEFTSTAT Integer Child Support EFT Status List:2 entries
0 = Not EFTed
1 = EFTed
DISTCODE String*6 Distribution Code Mask: %-6N
DISTRNAME String*15 Distribution Description
GLSEG4 String*15 Cost Center Segment Four
GLSEG5 String*15 Cost Center Segment Fix
GLSEG6 String*15 Cost Center Segment Six
TAXNONDED BCD*10.3 Non-periodic Deduction
TAXREPAY BCD*10.3 Repayment Deduction Before Tax