View: Cheque Header

RotoID: CP0048
Table: CPCHKH
DLL: CPCHKH

Compositions: 2


RotoID  Table  Title  DLL 
CP0049  CPCHKD  Cheque Details  CPCHKD
CP0052  CPCHKC  Cheque Comment Detail  CPCHKC

Keys: 11


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

Fields: 28


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 By Employee  E A K R   
ENTRYTYPE  4  Integer  Type of Cheque  E A  List: 5 entries
1=System Check
2=Manual Check
3=Adjustment
4=History Entry
5=Reversed Check
BANK  5  String*8  Bank ID  E A   
TRANSNUM  6  BCD*5.0  Transaction Number  E A   
TRANSDATE  7  Date  Transaction Date  E A   
PERSTART  8  Date  Period Start Date  E A   
TIMESLATE  9  Integer  Times Late This Period/Timecard  E A   
CHECKSTAT  10  Integer  Cheque Status  E A  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  List: 2 entries
1=Not Posted
2=Posted
GLPOSTSTAT  12  Integer  G/L Post Status  E A  List: 3 entries
1=Not Posted
2=Posted
3=Not to be Posted
PAYFREQ  13  Integer  Pay Frequency  E A  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  PR Class 1  E A   
CLASS2  15  String*6  PR Class 2  E A   
CLASS3  16  String*6  PR Class 3  E A   
CLASS4  17  String*6  PR Class 4  E A   
SERIAL  18  Long  Bank Serial Number  E A   
CALCSEQ  19  Long  Calculation Sequence  E A   
POSTSEQ  20  Long  Posting Sequence  E A   
PRPERIOD  21  Integer  Payroll Period  E A   
TRANSAMT  22  BCD*10.3  Transaction Amt  E A   
GLSEG1  23  String*15  G/L Segment One  E A   
GLSEG2  24  String*15  G/L Segment Two  E A   
GLSEG3  25  String*15  G/L Segment Three  E A   
BANKACCT  26  String*45  Bank General Ledger Account  E A   
WORKPROV  27  Integer  Province of Employment  E A  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   

This page was generated on 2003-May-05

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