View: Manual Cheque Detail

RotoID: CP0020
Table: CPMCDT
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:CPMCDT

Compositions: 3

RotoID Tables Title DLL
CP0019 CPMCHD Manual Cheque Header CPMCHD
CP0130 CPMCDO MC Details Opt Field Values CPMCDO
CP0043 CPMCJB Manual Cheque Job Details CPMCJB

Keys: 2

Title Fields
Employee/Line Number EMPLOYEE, BANK, CHECKNUM, PEREND, CHECKDATE, LINENUM
Employee/Earn Ded EMPLOYEE, BANK, CHECKNUM, PEREND, CHECKDATE, EARNDED, LINENUM

Fields: 75

Field Index Type Title Attributes Presentation
EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
BANK 2 String*8 Bank ID E A K R  Mask: %-8N
CHECKNUM 3 BCD*5.0 Cheque Number E A K R 
PEREND 4 Date Period End Date E A K R 
CHECKDATE 5 Date Cheque Date E A K R 
LINENUM 6 Integer Line Number E A K R 
EARNDED 7 String*6 Earning/Deduction E A R  Mask: %-6N
CATEGORY 8 Integer Category E A C  List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = Provincial Tax
9 = Local Tax
10 = User Tax
EARDEDTYPE 9 Integer Type E A C  List:16 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
7 = Vacation
8 = Sick
9 = Banked Time
10 = Disability
13 = Cash
14 = Noncash
18 = Insurance Tax
19 = Income Tax
20 = Employment Tax
21 = Pension Plan Tax
22 = Health Tax
23 = Other Tax
25 = n/a
LINETYPE 10 Integer Transaction Type E A P X  List:6 entries
1 = Payment
2 = Accrual
3 = Regular
4 = Overtime
5 = Shift Diff.
6 = n/a
EARDEDDATE 11 Date Date E A X 
GLSEG1 12 String*15 G/L Segment One E A X  Mask: %-15N
GLSEG2 13 String*15 G/L Segment Two E A X  Mask: %-15N
GLSEG3 14 String*15 G/L Segment Three E A X  Mask: %-15N
HOURS 15 BCD*4.3 Hours E A X 
CALCMETH 16 Integer Calculation Method E A C P 
LIMITBASE 17 Integer Base Limit E A C P 
CNTBASE 18 BCD*10.3 Pieces/Base X 
RATE 19 BCD*9.5 Rate/Amt/Percent E A X 
EXTEND 20 BCD*10.3 Extended Amt E A X 
EXPACCT 21 String*45 Regular Pay Expense G/L Account E A X D 
LIABACCT 22 String*45 Liability G/L Account X 
OTACCT 23 String*45 Overtime Expense G/L Account X 
SHIFTACCT 24 String*45 Shift Diff. Expense G/L Account X 
ASSETACCT 25 String*45 Asset G/L Account X 
WCC 26 String*6 Workers' Compensation Code P X 
TAXWEEKS 27 BCD*4.3 RESERVED - US Only X 
TAXANNUAL 28 BCD*5.5 RESERVED - US Only X 
WEEKLYNTRY 29 Boolean INTERNAL USE X 
ENTRYTYPE 30 Integer Entry Type E A C 
CALCSS 31 Integer RESERVED - US Only E A C 
CALCMED 32 Integer RESERVED - US Only E A C 
POOLEDTIPS 33 BCD*10.3 Pooled Tips X 
SHORTDESC 34 String*15 E/D/Tax Description E A C 
LONGDESC 35 String*60 E/D/Tax Name E A C 
OCCASIONAL 36 Integer INTERNAL USE - Occasional Tax E A C 
GLSEGID1 37 String*6 G/L Segment Name One E A C 
GLSEGDESC1 38 String*60 G/L Segment Description One E A C 
GLSEGID2 39 String*6 G/L Segment Name Two E A C 
GLSEGDESC2 40 String*60 G/L Segment Description Two E A C 
GLSEGID3 41 String*6 G/L Segment Name Three E A C 
GLSEGDESC3 42 String*60 G/L Segment Description Three E A C 
TIPDISB 43 Integer Tip Disbursement E A C 
KEYACTION 44 Integer INTERNAL USE - Key Action E A C 
WORKPROV 45 Integer Province of Employment E A C 
PROCESSCMD 46 Integer Process Command Code E A C  List:6 entries
0 = Process Cost Centers
1 = Insert Optional Fields
2 = Transfer Optional Fields
3 = Update Info to Match Jobs
4 = Clear Jobs
5 = Verify Optional Fields
NKEMPLOYEE 47 String*12 INTERNAL USE - New Key Employee E A C 
NKBANK 48 String*8 INTERNAL USE - New Key Bank ID E A C 
NKCHECKNUM 49 BCD*5.0 INTERNAL USE - New Key Cheque Number E A C 
NKPEREND 50 Date INTERNAL USE - New Key Period End E A C 
NKCHECKDAT 51 Date INTERNAL USE - New Key Cheque Date E A C 
NKLINENUM 52 Integer INTERNAL USE - New Key Line Number E A C 
GLSEGID4 53 String*6 RESERVED - G/L Segment Name Four E A C 
GLSEGDESC4 54 String*60 RESERVED - G/L Segment Description Four E A C 
GLSEGID5 55 String*6 RESERVED - G/L Segment Name Five E A C 
GLSEGDESC5 56 String*60 RESERVED - G/L Segment Description Five E A C 
GLSEGID6 57 String*6 RESERVED - G/L Segment Name Six E A C 
GLSEGDESC6 58 String*60 RESERVED - G/L Segment Description Six E A C 
WCCGROUP 100 String*6 Workers Comp. Group P X 
VALUES 101 Long Number of Optional Fields E A C 
DISTCODE 102 String*6 Distribution Code E A X  Mask: %-6N
REXPACCT 103 String*45 Employer Expense G/L Account X 
RLIABACCT 104 String*45 Employer Liability G/L Account X 
JOBS 105 Long Jobs E A C X 
WORKCODE 106 String*6 Work Classification Code E A  Mask: %-6N
JOBHOURS 107 BCD*4.3 Total Job Hours E A C X 
JOBBASE 108 BCD*10.3 Total Job Pieces/Sales/Amt C X 
RCALCMETH 109 Integer Employer Calc. Method E A C 
RLIMITBASE 110 Integer Employer Base Limit E A C 
RRATEOVER 111 Boolean Override Employer Rate/Amt/Pct X 
RRATE 112 BCD*9.5 Employer Rate/Amt/Pct X 
DEFRRATE 113 BCD*9.5 Default Employer Rate/Amt/Pct E A C 
GLSEG4 114 String*15 RESERVED - G/L Segment Four X 
GLSEG5 115 String*15 RESERVED - G/L Segment Five X 
GLSEG6 116 String*15 RESERVED - G/L Segment Six X 

This page was generated on 2023-Aug-31

© 2023 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).