View: Cheque Header

RotoID: CP0048
Table: CPCHKH
Protocol: Header
DLL:CPCHKH

Compositions: 5

RotoID Tables Title DLL

CP0049 CPCHKD Cheque Details CPCHKD
CP0052 CPCHKC Cheque Comment Detail CPCHKC
CP0202 CPCHKE Cheque EFT Details CPCHKE
CP0133 CPCHHO Cheque Header Optional Field Values CPCHHO
CP0134 CPCHDO Cheque Details Optional Fields CPCHDO

Keys: 12

Title Fields

Employee EMPLOYEEPERENDENTRYSEQ
Cheque Date TRANSDATEEMPLOYEEENTRYSEQ
Post Status PRPOSTSTATPERENDEMPLOYEEENTRYSEQ
Posting Sequence POSTSEQEMPLOYEEPERENDENTRYSEQ
Bank Code by Cheque BANKTRANSNUMSERIAL
Pay Frequency PRPOSTSTATPAYFREQPERENDEMPLOYEEENTRYSEQ
Class 1 PRPOSTSTATCLASS1PERENDEMPLOYEEENTRYSEQ
Class 2 PRPOSTSTATCLASS2PERENDEMPLOYEEENTRYSEQ
Class 3 PRPOSTSTATCLASS3PERENDEMPLOYEEENTRYSEQ
Class 4 PRPOSTSTATCLASS4PERENDEMPLOYEEENTRYSEQ
Employee by Post Status PRPOSTSTATEMPLOYEEPERENDENTRYSEQ
G/L Drilldown Link GLDRDWNLNK

Fields: 47

Field Index Type Title Attributes Presentation

EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
PEREND 2 Date Period End Date E A K R 
ENTRYSEQ 3 Long Entry Sequence E A K R 
ENTRYTYPE 4 Integer Type of Cheque E A X  List:5 entries
1 = System Cheque
2 = Manual Cheque
3 = Adjustment
4 = History Entry
5 = Reversed Cheque
BANK 5 String*8 Bank ID E A X 
TRANSNUM 6 BCD*5.0 Transaction Number E A X 
TRANSDATE 7 Date Transaction Date E A X 
PERSTART 8 Date Period Start Date E A X 
TIMESLATE 9 Integer Times Late This Period/Timecard E A X 
CHECKSTAT 10 Integer Cheque Status E A X  List:8 entries
1 = Align
2 = Void
3 = Outstanding
4 = Reversed
5 = Cleared
6 = Cleared With Error
7 = Non-negotiable
8 = Continuation
PRPOSTSTAT 11 Integer PR Post Status E A X  List:2 entries
1 = Not Posted
2 = Posted
GLPOSTSTAT 12 Integer Sent to G/L E A X  List:3 entries
1 = Not sent
2 = Sent
3 = Not to be sent
PAYFREQ 13 Integer Pay Frequency E A X  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 14 String*6 Class 1 E A X  Mask: %-6N
CLASS2 15 String*6 Class 2 E A X  Mask: %-6N
CLASS3 16 String*6 Class 3 E A X  Mask: %-6N
CLASS4 17 String*6 Class 4 E A X  Mask: %-6N
SERIAL 18 Long Bank Serial Number E A X 
CALCSEQ 19 Long Calculation Sequence E A X 
POSTSEQ 20 Long Posting Sequence E A X 
PRPERIOD 21 Integer Payroll Period E A X 
TRANSAMT 22 BCD*10.3 Transaction Amt E A X 
GLSEG1 23 String*15 G/L Segment One E A X 
GLSEG2 24 String*15 G/L Segment Two E A X 
GLSEG3 25 String*15 G/L Segment Three E A X 
BANKACCT 26 String*45 Bank General Ledger Account E A X 
WORKPROV 27 Integer Province of Employment E A X  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 28 String*6 Employee EI ID E A X 
EXRATE 29 BCD*8.7 Exchange Rate E A X 
RATEOP 30 Integer Rate Operator E A X 
EFTSTAT 31 Integer EFT Status E A X  List:3 entries
0 = Not to be EFTed
1 = Not EFTed
2 = EFTed
EFTRUNSEQ 32 Long EFT Run Sequence E A X 
VALUES 33 Long Number of Optional Fields E A C X 
GLDRDWNLNK 34 BCD*10.0 G/L Drilldown Link E A X 
OTOVERRIDE 35 Boolean Overtime Override E A X 
OTCALCTYPE 36 Integer Overtime Calculation E A X  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 37 Integer Based on External Timecards E A X  List:2 entries
0 = No
1 = Yes
SWJOB 38 Boolean Job Related E A X 
EXRATEDATE 39 Date Exchange Rate Date E A 
ORGTYPE 40 Integer Original Type E A X  List:5 entries
1 = System Cheque
2 = Manual Cheque
3 = Adjustment
4 = History Entry
5 = Reversed Cheque
CSEFTSTAT 41 Integer Child Support EFT Status E A X  List:2 entries
0 = Not EFTed
1 = EFTed
GLSEG4 42 String*15 G/L Segment Four E A X 
GLSEG5 43 String*15 G/L Segment Five E A X 
GLSEG6 44 String*15 G/L Segment Six E A X 
PROCESSCMD 100 Integer Process Command Code E A C X  List:2 entries
0 = No Action
1 = Insert Optional Fields
LINENO 101 Integer Next Line Number E A C X 
USERSEC 102 Integer Security Flag E A