Table: Cheque Header

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

Keys: 11


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

Fields: 32


Field  Type  Title  Presentation 
EMPLOYEE  String*12  Employee  Mask: %-12N
PEREND  Date  Period End Date   
ENTRYSEQ  Long  Entry Sequence By Employee   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
ENTRYTYPE  Integer  Type of Cheque  List: 5 entries
1=System Check
2=Manual Check
3=Adjustment
4=History Entry
5=Reversed Check
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  G/L Post Status  List: 3 entries
1=Not Posted
2=Posted
3=Not to be Posted
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  PR Class 1   
CLASS2  String*6  PR Class 2   
CLASS3  String*6  PR Class 3   
CLASS4  String*6  PR Class 4   
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   

This page was generated on 2003-May-05

Copyright © 2003 ACCPAC International, Inc. All rights reserved.