Application: Canadian Payroll 8.0A

Views
Tables
Objects

Views: 137

RotoID Tables Title DLL Compositions
CP0001 Payroll Activation  CPACTV
CP0006 CPCLAS Class Codes  CPCLAS
CP0007 CPDTLM Earnings/Deductions  CPDTLM CP0015, CP0015, CP0015, CP0015, CP0015, CP0009, CP0123, CP0040
CP0008 CPEMPD Employee Earnings/Deductions  CPEMPD CP0014, CP0125, CP0041
CP0009 CPDIST Distribution  CPDIST CP0029, CP0007
CP0010 CPEMPT Employee Taxes  CPEMPT CP0014, CP0062, CP0126
CP0012 CPHSTH Employee History Control  CPHSTH CP0013
CP0013 CPHSHO Employee History Optional Field Values  CPHSHO CP0012
CP0014 CPEMPL Employees  CPEMPL CP0008, CP0010, CP0053, CP0201, CP0122, CP0118, CP0119
CP0015 CPINCL Include List  CPINCL CP0007, CP0029
CP0016 Canadian Payroll Integrity Checker  CPDCHK
CP0017 CPSTAT Status  CPSTAT
CP0018 Delete Inactive Records  CPMAIN
CP0019 CPMCHD Manual Cheque Header  CPMCHD CP0020, CP0129
CP0020 CPMCDT Manual Cheque Detail  CPMCDT CP0019, CP0130, CP0043
CP0021 CPHHAU History Audit Headers  CPHHAU CP0024, CP0135
CP0022 CPOTSC Overtime Schedules  CPOTSC
CP0023 CPOPTS Company Options  CPOPTS
CP0024 CPHDAU History Audit Details  CPHDAU CP0021, CP0136
CP0025 CPSHFT Shift Differential Schedule  CPSHFT CP0038
CP0026 Concurrency controller  CPCTRL
CP0027 CPWRKC Work Classification Codes  CPWRKC
CP0029 CPTXMS Company Payroll Taxes  CPTXMS CP0015, CP0015, CP0015, CP0009, CP0124
CP0030 CPEUIC Employee EI History  CPEUIC
CP0031 CPTCHD Timecard Header  CPTCHD CP0032, CP0127
CP0032 CPTCDT Timecard Detail  CPTCDT CP0031, CP0128, CP0042
CP0036 CPWCCH Workers Compensation Master  CPWCCH CP0037
CP0037 CPWCCD Workers Compensation Codes  CPWCCD CP0036
CP0038 CPSHFD Shift Differential Detail  CPSHFD CP0025, CP0039
CP0039 CPSHFB Shift Differential Billing Detail  CPSHFB CP0038
CP0040 CPDTLB Earnings Billing Detail  CPDTLB CP0007
CP0041 CPEMDB Employee Billing Details  CPEMDB CP0008
CP0042 CPTCJB Timecard Job Details  CPTCJB CP0032, CP0141
CP0043 CPMCJB Manual Cheque Job Details  CPMCJB CP0020, CP0142
CP0044 CPUTJB Employee Timecard Job Details  CPUTJB CP0103, CP0143
CP0045 CPESLH Employee Selection Lists  CPESLH CP0046
CP0046 CPESLD Employee Selection List Members  CPESLD CP0045
CP0047 CPYTDS Employee YTD Summaries  CPYTDS
CP0048 CPCHKH Cheque Header  CPCHKH CP0049, CP0052, CP0202, CP0133, CP0134
CP0049 CPCHKD Cheque Details  CPCHKD CP0048, CP0134, CP0056
CP0050 Payroll Posting Superview  CPPOST
CP0051 CPGLBM Globally Modify List  CPGLBM
CP0052 CPCHKC Cheque Comment Detail  CPCHKC CP0048
CP0053 CPEMPC Employee Notes  CPEMPC CP0014
CP0056 CPCHJB Cheque Job Details  CPCHJB CP0049, CP0144
CP0057 CPGLREF G/L Reference Integration  CPGLREF
CP0058 Globally Modify Process  CPGMET CP0008, CP0041, CP0010
CP0059 G/L Acct Desc Report Extraction  CPGLDX
CP0060 CPGLDD G/L Acct Desc Report List  CPGLDD
CP0062 CPEMTF Employee Tax Fields  CPEMTF CP0010
CP0064 CPXCPT Calc PR Exceptions  CPXCPT
CP0065 Process Manual Cheques  CPPMAN CP0138
CP0066 CPUSLH User Selection Lists  CPUSLH CP0067
CP0067 CPUSLD User Selection List Detail  CPUSLD CP0066
CP0077 CPCHKS Cheque History Summary  CPCHKS
CP0078 Print Cheques Control  CPPCKS
CP0079 CPPCKH Print Cheques Header Extension  CPPCKH CP0080
CP0080 CPPCKD Print Cheques Detail Extension  CPPCKD CP0079
CP0081 Earnings Hours Report  CPERHR
CP0082 Check Reconciliation  CPCREC
CP0083 Calculate Payroll  CPCALC CP0137
CP0084 CPCALE E/D/T List  CPCALE
CP0085 CPCALT Timecard List  CPCALT
CP0086 CPCALA Cost Center Allocations  CPCALA
CP0087 CPCALO Timecard Earnings List  CPCALO
CP0088 CPCHKR Cheque Run Header  CPCHKR CP0139
CP0089 CPPCKF Print Cheques Trans.  CPPCKF
CP0093 CPEHRP Earnings Hourly Report  CPEHRP
CP0094 Payroll Register G/L Accounts  CPPREG
CP0097 PRRSTRT Restart  PRRSTRT
CP0099 CPDTLX Earnings/Deductions (virtual)  CPDTLX
CP0100 CPTXMC Temporary Tax List  CPTXMC
CP0101 Empl Timecards Transfer Ctrl  CPUTTR
CP0102 CPUTCH Employee Timecard Header  CPUTCH CP0103, CP0131
CP0103 CPUTCD Employee Timecard Detail  CPUTCD CP0102, CP0132, CP0044
CP0104 Employee Activity  CPEMAC
CP0105 Find Duplicate SIN  CPESIN
CP0106 CPEDUP Duplicate SIN  CPEDUP
CP0107 Create G/L Batch  CPGLTR
CP0108 Copy Timecard  CPTCCP
CP0109 Employee Sel Lists Superview  CPESLC CP0045, CP0046
CP0110 CPINCX Include List (virtual)  CPINCX
CP0111 G/L Drill Down  CPDLDN
CP0112 Cheque Selection Superview  CPCHKX
CP0113 CPCHKL Cheque Selection List  CPCHKL
CP0115 CPACCO Accrual Carry-over Log File  CPACCO
CP0116 CPLIMH Deduction Groups  CPLIMH CP0117
CP0117 CPLIMD Deduction Group Details  CPLIMD CP0116
CP0118 CPEMCS Employee Garnishment  CPEMCS CP0014
CP0119 CPECMM Employee Comments  CPECMM CP0014
CP0120 CPOFH Optional Field Locations  CPOFH CP0121
CP0121 CPOFD Optional Field Values  CPOFD CP0120
CP0122 CPEMPO Employee Optional Field Values  CPEMPO CP0014
CP0123 CPDTLO Earnings/Deductions Opt Fields  CPDTLO CP0007
CP0124 CPTXMO Taxes Optional Field Values  CPTXMO CP0029
CP0125 CPEMDO Empl Earn/Ded Optional Fields  CPEMDO CP0008
CP0126 CPEMTO Empl Taxes Optional Fields  CPEMTO CP0010
CP0127 CPTCHO Timecard Optional Field Values  CPTCHO CP0031
CP0128 CPTCDO Timecard Details Optional Field Values  CPTCDO CP0032
CP0129 CPMCHO Manual Cheque Optional Field Values  CPMCHO CP0019
CP0130 CPMCDO MC Details Opt Field Values  CPMCDO CP0020
CP0131 CPUTHO Empl Timecard Optional Fields  CPUTHO CP0102
CP0132 CPUTDO Empl Timecard Details Opt Flds  CPUTDO CP0103
CP0133 CPCHHO Cheque Header Optional Field Values  CPCHHO CP0048
CP0134 CPCHDO Cheque Details Optional Fields  CPCHDO CP0049
CP0135 CPHHOA History Audit Header Opt Fields  CPHHOA CP0021
CP0136 CPHDOA History Audit Detail Opt Fields  CPHDOA CP0024
CP0137 CPCLCO Calculate Payroll Optional Fields  CPCLCO CP0083
CP0138 CPPMCO Process Manual Cheque Optional Fields  CPPMCO CP0065
CP0139 CPCHKO Cheque Run Optional Field Values  CPCHKO CP0088
CP0140 PR Optional Field Callbacks  CPOFCMD
CP0141 CPTCJO Timecard Jobs Optional Field Values  CPTCJO CP0042
CP0142 CPMCJO Manual Cheque Jobs Opt Fields  CPMCJO CP0043
CP0143 CPUTJO Employee TC Jobs Opt Field Values  CPUTJO CP0044
CP0144 CPCHJO Cheque Jobs Optional Fields Values  CPCHJO CP0056
CP0200 CPCOBK Company EFT Banks  CPCOBK
CP0201 CPEMBK Employee EFT Banks  CPEMBK CP0014
CP0202 CPCHKE Cheque EFT Details  CPCHKE CP0048
CP0203 EFT Run Superview  CPERUN CP0212
CP0204 CPEREG EFT Run History Header  CPEREG CP0205
CP0205 CPETRN EFT Run History Details  CPETRN CP0204
CP0206 CPEMULH EFT Combine File Header  CPEMULH CP0207
CP0207 CPEMULD EFT Combine File Detail  CPEMULD CP0206
CP0208 CPELST EFT Combine File List  CPELST
CP0209 CPEMRGH EFT Files Combine Setup Header  CPEMRGH CP0210
CP0210 CPEMRGD EFT Files Combine Setup Detail  CPEMRGD CP0209
CP0211 EFT Combine Superview  CPECOMB CP0208
CP0220 CPAUDM Delete Inactive Records Audit  CPAUDM CP0221, CP0222
CP0221 CPAUDMI Delete Audit Inactive Details  CPAUDMI CP0220
CP0222 CPAUDMH Delete Audit Transaction Details  CPAUDMH CP0220
CP0223 CPAUDE Update Earn/Ded Audit  CPAUDE CP0224
CP0224 CPAUDED Update Earn/Ded Audit Details  CPAUDED CP0223
CP0225 CPAUDT Update Taxes Audit  CPAUDT CP0226
CP0226 CPAUDTD Update Taxes Audit Details  CPAUDTD CP0225
CP0227 CPAUDA Assign Earn/Ded Audit  CPAUDA CP0228
CP0228 CPAUDAD Assign Earn/Ded Audit Details  CPAUDAD CP0227, CP0229
CP0229 CPAUDAB Assign Earn/Ded Audit Billing  CPAUDAB CP0228

Tables: 103

Table RotoID Title
CPACCO CP0115 Accrual Carry-over Log File 
CPAUDA CP0227 Assign Earn/Ded Audit 
CPAUDAB CP0229 Assign Earn/Ded Audit Billing 
CPAUDAD CP0228 Assign Earn/Ded Audit Details 
CPAUDE CP0223 Update Earn/Ded Audit 
CPAUDED CP0224 Update Earn/Ded Audit Details 
CPAUDM CP0220 Delete Inactive Records Audit 
CPAUDMH CP0222 Delete Audit Transaction Details 
CPAUDMI CP0221 Delete Audit Inactive Details 
CPAUDT CP0225 Update Taxes Audit 
CPAUDTD CP0226 Update Taxes Audit Details 
CPCALA CP0086 Cost Center Allocations 
CPCHDO CP0134 Cheque Details Optional Fields 
CPCHHO CP0133 Cheque Header Optional Field Values 
CPCHJB CP0056 Cheque Job Details 
CPCHJO CP0144 Cheque Jobs Optional Fields Values 
CPCHKC CP0052 Cheque Comment Detail 
CPCHKD CP0049 Cheque Details 
CPCHKE CP0202 Cheque EFT Details 
CPCHKH CP0048 Cheque Header 
CPCHKL CP0113 Cheque Selection List 
CPCHKO CP0139 Cheque Run Optional Field Values 
CPCHKR CP0088 Cheque Run Header 
CPCHKS CP0077 Cheque History Summary 
CPCLAS CP0006 Class Codes 
CPCLCO CP0137 Calculate Payroll Optional Fields 
CPCOBK CP0200 Company EFT Banks 
CPDIST CP0009 Distribution 
CPDTLB CP0040 Earnings Billing Detail 
CPDTLM CP0007 Earnings/Deductions 
CPDTLO CP0123 Earnings/Deductions Opt Fields 
CPECMM CP0119 Employee Comments 
CPEDUP CP0106 Duplicate SIN 
CPEHRP CP0093 Earnings Hourly Report 
CPELST CP0208 EFT Combine File List 
CPEMBK CP0201 Employee EFT Banks 
CPEMCS CP0118 Employee Garnishment 
CPEMDB CP0041 Employee Billing Details 
CPEMDO CP0125 Empl Earn/Ded Optional Fields 
CPEMPC CP0053 Employee Notes 
CPEMPD CP0008 Employee Earnings/Deductions 
CPEMPL CP0014 Employees 
CPEMPO CP0122 Employee Optional Field Values 
CPEMPT CP0010 Employee Taxes 
CPEMRGD CP0210 EFT Files Combine Setup Detail 
CPEMRGH CP0209 EFT Files Combine Setup Header 
CPEMTF CP0062 Employee Tax Fields 
CPEMTO CP0126 Empl Taxes Optional Fields 
CPEMULD CP0207 EFT Combine File Detail 
CPEMULH CP0206 EFT Combine File Header 
CPEREG CP0204 EFT Run History Header 
CPESLD CP0046 Employee Selection List Members 
CPESLH CP0045 Employee Selection Lists 
CPETRN CP0205 EFT Run History Details 
CPEUIC CP0030 Employee EI History 
CPGLBM CP0051 Globally Modify List 
CPGLDD CP0060 G/L Acct Desc Report List 
CPGLREF CP0057 G/L Reference Integration 
CPHDAU CP0024 History Audit Details 
CPHDOA CP0136 History Audit Detail Opt Fields 
CPHHAU CP0021 History Audit Headers 
CPHHOA CP0135 History Audit Header Opt Fields 
CPINCL CP0015 Include List 
CPLIMD CP0117 Deduction Group Details 
CPLIMH CP0116 Deduction Groups 
CPMCDO CP0130 MC Details Opt Field Values 
CPMCDT CP0020 Manual Cheque Detail 
CPMCHD CP0019 Manual Cheque Header 
CPMCHO CP0129 Manual Cheque Optional Field Values 
CPMCJB CP0043 Manual Cheque Job Details 
CPMCJO CP0142 Manual Cheque Jobs Opt Fields 
CPOFD CP0121 Optional Field Values 
CPOFH CP0120 Optional Field Locations 
CPOPTS CP0023 Company Options 
CPOTSC CP0022 Overtime Schedules 
CPPCKD CP0080 Print Cheques Detail Extension 
CPPCKH CP0079 Print Cheques Header Extension 
CPPMCO CP0138 Process Manual Cheque Optional Fields 
CPSHFB CP0039 Shift Differential Billing Detail 
CPSHFD CP0038 Shift Differential Detail 
CPSHFT CP0025 Shift Differential Schedule 
CPSTAT CP0017 Status 
CPTCDO CP0128 Timecard Details Optional Field Values 
CPTCDT CP0032 Timecard Detail 
CPTCHD CP0031 Timecard Header 
CPTCHO CP0127 Timecard Optional Field Values 
CPTCJB CP0042 Timecard Job Details 
CPTCJO CP0141 Timecard Jobs Optional Field Values 
CPTXMO CP0124 Taxes Optional Field Values 
CPTXMS CP0029 Company Payroll Taxes 
CPUSLD CP0067 User Selection List Detail 
CPUSLH CP0066 User Selection Lists 
CPUTCD CP0103 Employee Timecard Detail 
CPUTCH CP0102 Employee Timecard Header 
CPUTDO CP0132 Empl Timecard Details Opt Flds 
CPUTHO CP0131 Empl Timecard Optional Fields 
CPUTJB CP0044 Employee Timecard Job Details 
CPUTJO CP0143 Employee TC Jobs Opt Field Values 
CPWCCD CP0037 Workers Compensation Codes 
CPWCCH CP0036 Workers Compensation Master 
CPWRKC CP0027 Work Classification Codes 
CPXCPT CP0064 Calc PR Exceptions 
CPYTDS CP0047 Employee YTD Summaries 

Objects: 39

Object Protocol Views
CPCALCULAT ORDERED  CP0083, CP0137
CPCHECKS ORD5  CP0048, CP0049, CP0052, CP0202, CP0133, CP0134
CPCLASSIDS SET  CP0006
CPCONTROL SUPER  CP0026
CPCPYTCARD SUPER  CP0108
CPDCHK FLAT  CP0016
CPDELINREC FLAT  CP0018
CPDISTCODE SET  CP0009
CPEARNDED ORD4  CP0007, CP0009, CP0015, CP0123, CP0040
CPEFTCOBK SET  CP0200
CPEFTMERGE ORDERED  CP0211, CP0208
CPEFTMERGESTP ORDERED  CP0209, CP0210
CPEFTTRANS ORDERED  CP0204, CP0205
CPEMASTER ORD9  CP0014, CP0008, CP0010, CP0053, CP0201, CP0062, CP0122, CP0125, CP0126, CP0041
CPERNGHRS SUPER  CP0081
CPESELECT ORDERED  CP0045, CP0046
CPEUIHST SET  CP0030
CPGENEFT SUPER  CP0203
CPGMET SUPER  CP0058
CPINCLIST SET  CP0015
CPMANCHK ORD5  CP0019, CP0020, CP0129, CP0130, CP0043, CP0142
CPMANCKDTL ORD3  CP0020, CP0130, CP0043, CP0142
CPOPTFLDS ORDERED  CP0120, CP0121
CPOPTIONS FLAT  CP0023
CPOTSCHED FLAT  CP0022
CPPRCHECKS SUPER  CP0078
CPPRMANCHK ORDERED  CP0065, CP0138
CPREGISTER SUPER  CP0094
CPSECURITY ORDERED  CP0066, CP0067
CPSHFTSCH ORD2  CP0025, CP0038, CP0039
CPTAXFLD FLAT  CP0062
CPTAXMASTR ORD3  CP0029, CP0009, CP0015, CP0124
CPTIMECARD ORD5  CP0031, CP0032, CP0127, CP0128, CP0042, CP0141
CPTMCRDDTL ORD3  CP0032, CP0128, CP0042, CP0141
CPUTCARD ORD5  CP0102, CP0103, CP0131, CP0132, CP0044, CP0143
CPUTCTRF SUPER  CP0101
CPWORKCODE FLAT  CP0027
CPWORKCOMP ORDERED  CP0036, CP0037
CPYTDSUM FLAT  CP0047

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