View: Manual Cheque Header

RotoID: CP0019
Table: CPMCHD
Protocol: Header
DLL:CPMCHD

Compositions: 2

RotoID Tables Title DLL
CP0020 CPMCDT Manual Cheque Detail CPMCDT
CP0129 CPMCHO Manual Cheque Optional Field Values CPMCHO

Keys: 3

Title Fields
Cheque Date EMPLOYEE, BANK, CHECKNUM, PEREND, CHECKDATE
Cheque Number EMPLOYEE, BANK, CHECKNUM
Period End Date EMPLOYEE, PEREND, CHECKNUM

Fields: 64

Field Index Type Title Attributes Presentation
EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
BANK 2 String*8 Bank Code E A K R X  Mask: %-8N
CHECKNUM 3 BCD*5.0 Cheque Number E A K R X 
PEREND 4 Date Period End Date E A K R 
CHECKDATE 5 Date Cheque Date E A K R 
CHECKDESC 6 String*15 Description E A 
PERSTART 7 Date Period Start Date E A 
TIMESLATE 8 Integer Times Late E A 
ACTIVE 9 Boolean Cheque Active E A 
PRINT 10 Boolean Print Cheque E A 
BANKFORM 11 String*6 Cheque Stock Code E A  Mask: %-6N
PROCESSED 13 Integer Processed E A C 
GROSSPAY 14 BCD*10.3 Gross Pay E A C 
CONTRIBS 15 BCD*10.3 Benefits E A C 
DEDUCTIONS 16 BCD*10.3 Deductions E A C 
TAXES 17 BCD*10.3 Taxes E A C 
NETPAY 18 BCD*10.3 Net Pay E A C 
LASTNAME 19 String*20 Last Name A C 
FIRSTNAME 20 String*15 First Name A C 
MIDDLENAME 21 String*15 Middle Name A C 
CREGHRS 22 BCD*4.3 Regular Hours E A C 
CSHIFTHRS 23 BCD*4.3 Shift Hours E A C 
COTHRS 24 BCD*4.3 Overtime Hours E A C 
CVACHRSP 25 BCD*4.3 Vacation Hours Paid A C 
CVACHRSA 26 BCD*4.3 Vacation Hours Accrued A C 
CSICKHRSP 27 BCD*4.3 Sick Hours Paid A C 
CSICKHRSA 28 BCD*4.3 Sick Hours Accrued A C 
CCOMPHRSP 29 BCD*4.3 Banked Time Hours Paid A C 
CCOMPHRSA 30 BCD*4.3 Banked Time Hours Accrued A C 
CVACAMTP 31 BCD*10.3 Vacation Dollars Paid A C 
CVACAMTA 32 BCD*10.3 Vacation Dollars Accrued A C 
CSICKAMTP 33 BCD*10.3 Sick Time Dollars Paid A C 
CSICKAMTA 34 BCD*10.3 Sick Time Dollars Accrued A C 
CCOMPAMTP 35 BCD*10.3 Banked Time Dollars Paid A C 
CCOMPAMTA 36 BCD*10.3 Banked Time Dollars Accrued A C 
ESSWAGES 37 BCD*10.3 RESERVED - US Only A C 
ESSWH 38 BCD*10.3 RESERVED - US Only A C 
EMEDWAGES 39 BCD*10.3 RESERVED - US Only A C 
EMEDWH 40 BCD*10.3 RESERVED - US Only A C 
KEYACTION 41 Integer INTERNAL USE - Key Action E A C 
CDISIHRSP 42 BCD*4.3 RESERVED - Disability A C 
CDISIHRSA 43 BCD*4.3 RESERVED - Disability A C 
CDISIAMTP 44 BCD*10.3 RESERVED - Disability A C 
CDISIAMTA 45 BCD*10.3 RESERVED - Disability A C 
HIREDATE 46 Date Hire Date E A 
FIREDATE 47 Date Termination Date E A 
PARTTIME 48 Boolean Part-Time E A 
PAYFREQ 49 Integer Pay Frequency E A 
OTSCHED 50 String*6 Overtime Schedule E A 
SHIFTSCHED 51 String*6 Shift Differential Schedule E A 
SHIFTNUM 52 Integer Shift Number E A 
GLSEG1 53 String*15 Segment Code 1 E A 
GLSEG2 54 String*15 Segment Code 2 E A 
GLSEG3 55 String*15 Segment Code 3 E A 
WORKPROV 56 Integer Province of Employment E A 
STATUS 57 Integer Employment Status E A 
INACTDATE 58 Date Inactive Date E A 
PROCESSCMD 59 Integer Process Command Code E A C  List:2 entries
0 = Key Action
1 = Insert Optional Fields
WORKCODE 60 String*6 Work Classification A C 
TOTALJOBS 61 Long Total Jobs E A C 
USERSEC 62 Integer Security Flag E A 
VALUES 75 Long Number of Optional Fields E A C 
MCDLINES 76 Integer Manual Cheque Lines E A C 
SWJOB 77 Boolean Job Related E A 

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).