Table: Cheque Header

Table: CPCHKH
View: CP0048
Record Length: 318

Flags: A R 

Keys: 12

Title Flags Fields

Employee EMPLOYEEPERENDENTRYSEQ
Cheque Date TRANSDATEEMPLOYEEENTRYSEQ
Post Status M  PRPOSTSTATPERENDEMPLOYEEENTRYSEQ
Posting Sequence M  POSTSEQEMPLOYEEPERENDENTRYSEQ
Bank Code by Cheque D M  BANKTRANSNUMSERIAL
Pay Frequency M  PRPOSTSTATPAYFREQEMPLOYEEPERENDENTRYSEQ
Class 1 M  PRPOSTSTATCLASS1EMPLOYEEPERENDENTRYSEQ
Class 2 M  PRPOSTSTATCLASS2EMPLOYEEPERENDENTRYSEQ
Class 3 M  PRPOSTSTATCLASS3EMPLOYEEPERENDENTRYSEQ
Class 4 M  PRPOSTSTATCLASS4EMPLOYEEPERENDENTRYSEQ
Employee by Post Status M  PRPOSTSTATEMPLOYEEPERENDENTRYSEQ
G/L Drilldown Link D M  GLDRDWNLNK

Fields: 48

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
PEREND Date Period End Date
ENTRYSEQ Long Entry Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
ENTRYTYPE Integer Type of Cheque List:5 entries
1 = System Cheque
2 = Manual Cheque
3 = Adjustment
4 = History Entry
5 = Reversed Cheque
BANK String*8 Bank ID
TRANSNUM BCD*5.0 Transaction Number
TRANSDATE Date Transaction Date
PERSTART Date Period Start Date
TIMESLATE Integer Times Late This Period/Timecard
CHECKSTAT Integer Cheque Status List:8 entries
1 = Align
2 = Void
3 = Outstanding
4 = Reversed
5 = Cleared
6 = Cleared With Error
7 = Non-negotiable
8 = Continuation
PRPOSTSTAT Integer PR Post Status List:2 entries
1 = Not Posted
2 = Posted
GLPOSTSTAT Integer Sent to G/L List:3 entries
1 = Not sent
2 = Sent
3 = Not to be sent
PAYFREQ Integer Pay Frequency List:9 entries
2 = Daily
3 = Weekly
4 = Biweekly
5 = Semimonthly
10 = Twenty-two per Year
9 = Thirteen per Year
6 = Monthly
8 = Ten per Year
7 = Quarterly
CLASS1 String*6 Class 1 Mask: %-6N
CLASS2 String*6 Class 2 Mask: %-6N
CLASS3 String*6 Class 3 Mask: %-6N
CLASS4 String*6 Class 4 Mask: %-6N
SERIAL Long Bank Serial Number
CALCSEQ Long Calculation Sequence
POSTSEQ Long Posting Sequence
PRPERIOD Integer Payroll Period
TRANSAMT BCD*10.3 Transaction Amt
GLSEG1 String*15 G/L Segment One
GLSEG2 String*15 G/L Segment Two
GLSEG3 String*15 G/L Segment Three
BANKACCT String*45 Bank General Ledger Account
WORKPROV Integer Province of Employment List:14 entries
1 = Alberta
2 = British Columbia
3 = Manitoba
4 = New Brunswick
5 = Newfoundland & Labrador
6 = Northwest Territories
7 = Nova Scotia
8 = Ontario
9 = Outside Canada
10 = Prince Edward Island
11 = Quebec
12 = Saskatchewan
13 = Yukon Territory
14 = Nunavut
TAXPLAN String*6 Employee EI ID
EXRATE BCD*8.7 Exchange Rate
RATEOP Integer Rate Operator
EFTSTAT Integer EFT Status List:3 entries
0 = Not to be EFTed
1 = Not EFTed
2 = EFTed
EFTRUNSEQ Long EFT Run Sequence
VALUES Long Number of Optional Fields
GLDRDWNLNK BCD*10.0 G/L Drilldown Link
OTOVERRIDE Boolean Overtime Override
OTCALCTYPE Integer Overtime Calculation List:6 entries
0 = Hourly Rate
1 = Minimum Wage
2 = Shift Rate
3 = Regular Rate-Hourly
4 = Regular Rate-Salary Fixed Hours
5 = Regular Rate-Salary Fluctuating Hours
SWEXTERNTC Integer Based on External Timecards List:2 entries
0 = No
1 = Yes
SWJOB Boolean Job Related
EXRATEDATE Date Exchange Rate Date
ORGTYPE Integer Original Type List:5 entries
1 = System Cheque
2 = Manual Cheque
3 = Adjustment
4 = History Entry
5 = Reversed Cheque
CSEFTSTAT Integer Child Support EFT Status List:2 entries
0 = Not EFTed
1 = EFTed
GLSEG4 String*15 G/L Segment Four
GLSEG5 String*15 G/L Segment Five
GLSEG6 String*15 G/L Segment Six