| 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 |
| 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 | |
| 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 | |
| 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 | ||
| 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 |
| 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 |
| CPEDUP | CP0106 | Duplicate SIN |
| CPEHRP | CP0093 | Earnings Hourly Report |
| CPELST | CP0208 | EFT Combine File List |
| CPEMBK | CP0201 | Employee EFT Banks |
| 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 |
| 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 |
This page was generated on 2009-Nov-19
Copyright © 2001–2009 Sage Software, Inc. All rights reserved.