# 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 | EMPLOYEE, PEREND, ENTRYSEQ
Cheque Date | TRANSDATE, EMPLOYEE, ENTRYSEQ
Post Status | PRPOSTSTAT, PEREND, EMPLOYEE, ENTRYSEQ
Posting Sequence | POSTSEQ, EMPLOYEE, PEREND, ENTRYSEQ
Bank Code by Cheque | BANK, TRANSNUM, SERIAL
Pay Frequency | PRPOSTSTAT, PAYFREQ, PEREND, EMPLOYEE, ENTRYSEQ
Class 1 | PRPOSTSTAT, CLASS1, PEREND, EMPLOYEE, ENTRYSEQ
Class 2 | PRPOSTSTAT, CLASS2, PEREND, EMPLOYEE, ENTRYSEQ
Class 3 | PRPOSTSTAT, CLASS3, PEREND, EMPLOYEE, ENTRYSEQ
Class 4 | PRPOSTSTAT, CLASS4, PEREND, EMPLOYEE, ENTRYSEQ
Employee by Post Status | PRPOSTSTAT, EMPLOYEE, PEREND, ENTRYSEQ
G/L Drilldown Link | GLDRDWNLNK

## Fields: 43

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
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 |

This page was generated on 2009-Nov-19

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