Table: Cheque Header

Table: CPCHKH
View: CP0048
Record length: 271
Flags: A R 

Keys: 12

Title  Flags  Fields

Employee  EMPLOYEE, PEREND, ENTRYSEQ
Cheque Date  TRANSDATE, EMPLOYEE, ENTRYSEQ
Post Status  M  PRPOSTSTAT, PEREND, EMPLOYEE, ENTRYSEQ
Posting Sequence  M  POSTSEQ, EMPLOYEE, PEREND, ENTRYSEQ
Bank Code by Cheque  D M  BANK, TRANSNUM, SERIAL
Pay Frequency  M  PRPOSTSTAT, PAYFREQ, EMPLOYEE, PEREND, ENTRYSEQ
Class 1  M  PRPOSTSTAT, CLASS1, EMPLOYEE, PEREND, ENTRYSEQ
Class 2  M  PRPOSTSTAT, CLASS2, EMPLOYEE, PEREND, ENTRYSEQ
Class 3  M  PRPOSTSTAT, CLASS3, EMPLOYEE, PEREND, ENTRYSEQ
Class 4  M  PRPOSTSTAT, CLASS4, EMPLOYEE, PEREND, ENTRYSEQ
Employee by Post Status  M  PRPOSTSTAT, EMPLOYEE, PEREND, ENTRYSEQ
G/L Drilldown Link  D M  GLDRDWNLNK

Fields: 44

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

This page was generated on 2009-Nov-19

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