View: Earnings/Deductions

RotoID: CP0007
Table: CPDTLM
Protocol: Header
DLL: CPDTLM

Compositions: 8

RotoID  Tables  Title  DLL 

CP0015  CPINCL  Include List  CPINCL
CP0015  CPINCL  Include List  CPINCL
CP0015  CPINCL  Include List  CPINCL
CP0015  CPINCL  Include List  CPINCL
CP0015  CPINCL  Include List  CPINCL
CP0009  CPDIST  Distribution  CPDIST
CP0123  CPDTLO  Earnings/Deductions Opt Fields  CPDTLO
CP0040  CPDTLB  Earnings Billing Detail  CPDTLB

Keys: 2

Title  Fields

Earning/Deduction  EARNDED
Category  CATEGORY, EARDEDTYPE, EARNDED

Fields: 249

Field  Index  Type  Title  Attributes  Presentation

EARNDED  String*6  Earning/Deduction  E A K R  Mask: %-6N
LONGDESC  String*60  Earning/Deduction Description  E A   
SHORTDESC  String*15  Earning/Deduction Short Description  E A   
INACTIVE  Boolean  Inactive  E A   
ASOF  Date  Inactive As Of  A C X   
LASTMAINT  Date  Last Maintained  E A C   
CATEGORY  Integer  Category  E A  List: 6 entries
1=Accrual
2=Earning
3=Advance
4=Deduction
5=Expense Reimbursement
6=Benefit
EARDEDTYPE  Integer  Type  E A P X  List: 3 entries
1=Salary & Wages
2=Reported Tips
3=Allocated Tips
FREQUENCY  Integer  Frequency  E A P X  List: 9 entries
1=Float
2=Daily
3=Weekly
4=Biweekly
5=Semimonthly
10=Twenty-two per Year
9=Thirteen per Year
6=Monthly
8=Ten per Year
STARTS  10  Integer  Starts  E A  List: 4 entries
1=Specific Month/Day
2=Date of Hire
3=Months after Hire
4=Days after Hire
STARTMONTH  11  Integer  Start Month  X   
STARTDAY  12  Integer  Start Day  X   
ENDS  13  Date  Ends  E A   
PRNTONCHK  14  Boolean  Print On Cheque  E A   
PRNTIF0  15  Boolean  RESERVED Print If Current Zero.  C   
PRNTYTDIF0  16  Boolean  RESERVED Print YTD If Current Zero  C   
ECALCMETH  17  Integer  Employee Calculation Method  E A P X  List: 7 entries
2=Flat
3=Fixed
4=Hourly Rate
5=Amount per Hour
6=Piece Rate Table
7=Percentage of Base
8=Sales Commission Table
EW2BOX  18  Integer  RESERVED - US Only  P X   
ERATE  19  BCD*9.5  Employee Rate  X   
EANNUALMAX  20  BCD*10.3  Employee Annual Maximum  X   
EDAILYMIN  21  BCD*10.3  Employee Daily Minimum  X   
EDAILYMAX  22  BCD*10.3  Employee Daily Maximum  X   
EWEEKLYMIN  23  BCD*10.3  Employee Weekly Minimum  X   
EWEEKLYMAX  24  BCD*10.3  Employee Weekly Maximum  X   
EBIWKLYMIN  25  BCD*10.3  Employee Biweekly Minimum  X   
EBIWKLYMAX  26  BCD*10.3  Employee Biweekly Maximum  X   
ESEMIMNMIN  27  BCD*10.3  Employee Semimonthly Minimum  X   
ESEMIMNMAX  28  BCD*10.3  Employee Semimonthly Maximum  X   
EMNTHLYMIN  29  BCD*10.3  Employee Monthly Minimum  X   
EMNTHLYMAX  30  BCD*10.3  Employee Monthly Maximum  X   
EQRTRLYMIN  31  BCD*10.3  Employee Quarterly Minimum  X   
EQRTRLYMAX  32  BCD*10.3  Employee Quarterly Maximum  X   
E10PPPYMIN  33  BCD*10.3  Employee Ten Period/Year Minimum  X   
E10PPPYMAX  34  BCD*10.3  Employee Ten Period/Year Maximum  X   
E13PPPYMIN  35  BCD*10.3  Employee Thirteen Period/Year Minimum  X   
E13PPPYMAX  36  BCD*10.3  Employee Thirteen Period/Year Maximum  X   
E22PPPYMIN  37  BCD*10.3  Employee Twentytwo Period/Year Minimum  X   
E22PPPYMAX  38  BCD*10.3  Employee Twentytwo Period/Year Maximum  X   
ELIMITBASE  39  Integer  Employee Base Limit  E A P X D  List: 1 entries
1=No Limit
WGBRACK1  40  BCD*10.3  Wage Bracket 1  X   
WGADDAMT1  41  BCD*10.3  Add Amount 1  X   
WGPCTOVR1  42  BCD*5.5  Percnt. of Excess 1  X   
WGBRACK2  43  BCD*10.3  Wage Bracket 2  X   
WGADDAMT2  44  BCD*10.3  Add Amount 2  X   
WGPCTOVR2  45  BCD*5.5  Percnt. of Excess 2  X   
WGBRACK3  46  BCD*10.3  Wage Bracket 3  X   
WGADDAMT3  47  BCD*10.3  Add Amount 3  X   
WGPCTOVR3  48  BCD*5.5  Percnt. of Excess 3  X   
WGBRACK4  49  BCD*10.3  Wage Bracket 4  X   
WGADDAMT4  50  BCD*10.3  Add Amount 4  X   
WGPCTOVR4  51  BCD*5.5  Percnt. of Excess 4  X   
WGBRACK5  52  BCD*10.3  Wage Bracket 5  X   
WGADDAMT5  53  BCD*10.3  Add Amount 5  X   
WGPCTOVR5  54  BCD*5.5  Percnt. of Excess 5  X   
WGBRACK6  55  BCD*10.3  Wage Bracket 6  X   
WGADDAMT6  56  BCD*10.3  Add Amount 6  X   
WGPCTOVR6  57  BCD*5.5  Percnt. of Excess 6  X   
WGBRACK7  58  BCD*10.3  Wage Bracket 7  X   
WGADDAMT7  59  BCD*10.3  Add Amount 7  X   
WGPCTOVR7  60  BCD*5.5  Percnt. of Excess 7  X   
WGBRACK8  61  BCD*10.3  Wage Bracket 8  X   
WGADDAMT8  62  BCD*10.3  Add Amount 8  X   
WGPCTOVR8  63  BCD*5.5  Percnt. of Excess 8  X   
WGBRACK9  64  BCD*10.3  Wage Bracket 9  X   
WGADDAMT9  65  BCD*10.3  Add Amount 9  X   
WGPCTOVR9  66  BCD*5.5  Percnt. of Excess 9  X   
WGBRACK10  67  BCD*10.3  Wage Bracket 10  X   
WGADDAMT10  68  BCD*10.3  Add Amount 10  X   
WGPCTOVR10  69  BCD*5.5  Percnt. of Excess 10  X   
WGBRACK11  70  BCD*10.3  Wage Bracket 11  X   
WGADDAMT11  71  BCD*10.3  Add Amount 11  X   
WGPCTOVR11  72  BCD*5.5  Percnt. of Excess 11  X   
WGBRACK12  73  BCD*10.3  Wage Bracket 12  X   
WGADDAMT12  74  BCD*10.3  Add Amount 12  X   
WGPCTOVR12  75  BCD*5.5  Percnt. of Excess 12  X   
WGBRACK13  76  BCD*10.3  Wage Bracket 13  X   
WGADDAMT13  77  BCD*10.3  Add Amount 13  X   
WGPCTOVR13  78  BCD*5.5  Percnt. of Excess 13  X   
WGBRACK14  79  BCD*10.3  Wage Bracket 14  X   
WGADDAMT14  80  BCD*10.3  Add Amount 14  X   
WGPCTOVR14  81  BCD*5.5  Percnt. of Excess 14  X   
WGBRACK15  82  BCD*10.3  Wage Bracket 15  X   
WGADDAMT15  83  BCD*10.3  Add Amount 15  X   
WGPCTOVR15  84  BCD*5.5  Percnt. of Excess 15  X   
WGBRACK16  85  BCD*10.3  Wage Bracket 16  X   
WGADDAMT16  86  BCD*10.3  Add Amount 16  X   
WGPCTOVR16  87  BCD*5.5  Percnt. of Excess 16  X   
WGBRACK17  88  BCD*10.3  Wage Bracket 17  X   
WGADDAMT17  89  BCD*10.3  Add Amount 17  X   
WGPCTOVR17  90  BCD*5.5  Percnt. of Excess 17  X   
WGBRACK18  91  BCD*10.3  Wage Bracket 18  X   
WGADDAMT18  92  BCD*10.3  Add Amount 18  X   
WGPCTOVR18  93  BCD*5.5  Percnt. of Excess 18  X   
WGBRACK19  94  BCD*10.3  Wage Bracket 19  X   
WGADDAMT19  95  BCD*10.3  Add Amount 19  X   
WGPCTOVR19  96  BCD*5.5  Percnt. of Excess 19  X   
WGBRACK20  97  BCD*10.3  Wage Bracket 20  X   
WGADDAMT20  98  BCD*10.3  Add Amount 20  X   
WGPCTOVR20  99  BCD*5.5  Percnt. of Excess 20  X   
RCALCMETH  100  Integer  Employer Calcuation Method  E A P X D  List: 6 entries
2=Flat
5=Amount per Hour
6=Piece Rate Table
7=Percentage of Base
8=Sales Commission Table
9=Wage Bracket Table
RW2BOX  101  Integer  RESERVED - US Only  P X   
RRATE  102  BCD*9.5  Employer Rate  X   
RANNUALMAX  103  BCD*10.3  Employer Annual Maximum  X   
RDAILYMIN  104  BCD*10.3  Employer Daily Minimum  X   
RDAILYMAX  105  BCD*10.3  Employer Daily Maximum  X   
RWEEKLYMIN  106  BCD*10.3  Employer Weekly Minimum  X   
RWEEKLYMAX  107  BCD*10.3  Employer Weekly Maximum  X   
RBIWKLYMIN  108  BCD*10.3  Employer Biweekly Minimum  X   
RBIWKLYMAX  109  BCD*10.3  Employer Biweekly Maximum  X   
RSEMIMNMIN  110  BCD*10.3  Employer Semimonthly Minimum  X   
RSEMIMNMAX  111  BCD*10.3  Employer Semimonthly Maximum  X   
RMNTHLYMIN  112  BCD*10.3  Employer Monthly Minimum  X   
RMNTHLYMAX  113  BCD*10.3  Employer Monthly Maximum  X   
RQRTRLYMIN  114  BCD*10.3  Employer Quarterly Minimum  X   
RQRTRLYMAX  115  BCD*10.3  Employer Quarterly Maximum  X   
R10PPPYMIN  116  BCD*10.3  Employer Ten Per/Year Minimum  X   
R10PPPYMAX  117  BCD*10.3  Employer Ten Per/Year Maximum  X   
R13PPPYMIN  118  BCD*10.3  Employer Thirteen Per/Year Minimum  X   
R13PPPYMAX  119  BCD*10.3  Employer Thirteen Per/Year Maximum  X   
R22PPPYMIN  120  BCD*10.3  Employer TwentyTwo Per/Year Minimum  X   
R22PPPYMAX  121  BCD*10.3  Employer TwentyTwo Per/Year Maximum  X   
RLIMITBASE  122  Integer  Employer Base Limit  E A P X D  List: 1 entries
1=No Limit
ALLOWWCC  123  Boolean  Subject to Workers' Compensation  E A X   
COMMAMT1  124  BCD*10.3  Commission Amt. 1  X   
COMMPCT1  125  BCD*5.5  Commission Pct. 1  X   
COMMAMT2  126  BCD*10.3  Commission Amt. 2  X   
COMMPCT2  127  BCD*5.5  Commission Pct. 2  X   
COMMAMT3  128  BCD*10.3  Commission Amt. 3  X   
COMMPCT3  129  BCD*5.5  Commission Pct. 3  X   
COMMAMT4  130  BCD*10.3  Commission Amt. 4  X   
COMMPCT4  131  BCD*5.5  Commission Pct. 4  X   
COMMAMT5  132  BCD*10.3  Commission Amt. 5  X   
COMMPCT5  133  BCD*5.5  Commission Pct. 5  X   
COMMPCTX  134  BCD*5.5  Commission Amt. excess  X   
PIECNUM1  135  BCD*10.3  Piece count 1  X   
PIECAMT1  136  BCD*9.5  Piece amount 1  X   
PIECNUM2  137  BCD*10.3  Piece count 2  X   
PIECAMT2  138  BCD*9.5  Piece amount 2  X   
PIECNUM3  139  BCD*10.3  Piece count 3  X   
PIECAMT3  140  BCD*9.5  Piece amount 3  X   
PIECNUM4  141  BCD*10.3  Piece count 4  X   
PIECAMT4  142  BCD*9.5  Piece amount 4  X   
PIECNUM5  143  BCD*10.3  Piece count 5  X   
PIECAMT5  144  BCD*9.5  Piece amount 5  X   
PIECAMTX  145  BCD*9.5  Max Piece Rate Amt.  X   
TIPDISB  146  Boolean  Tip Disbursement  X   
PAYDOWNDED  147  Boolean  Repayment Deduction  X   
REPAYID  148  String*6  Advance to Be Repaid  X   
CARRYOVER  149  Integer  Carry-over  E A X D  List: 4 entries
1=Specific Month/Day
2=Date of Hire
3=Months after Hire
4=Days after Hire
COVERDAY  150  Integer  Carry-over Day  X   
COVERMONTH  151  Integer  Carry-over Month  X   
POSTLIAB  152  Boolean  Post Liab.  X   
SVCYEAR1  153  Integer  Service Year 1  X   
BEGHRS1  154  BCD*10.3  Beginning Hours 1  X   
INCRHRS1  155  BCD*9.5  Increment Hours 1  X   
MAXACCR1  156  BCD*10.3  Max. Annual Accrual 1  X   
MAXCARRY1  157  BCD*10.3  Max. Carry-over Hours 1  X   
SVCYEAR2  158  Integer  Service Year 2  X   
BEGHRS2  159  BCD*10.3  Beginning Hours 2  X   
INCRHRS2  160  BCD*9.5  Increment Hours 2  X   
MAXACCR2  161  BCD*10.3  Max. Annual Accrual 2  X   
MAXCARRY2  162  BCD*10.3  Max. Carry-over Hours 2  X   
SVCYEAR3  163  Integer  Service Year 3  X   
BEGHRS3  164  BCD*10.3  Beginning Hours 3  X   
INCRHRS3  165  BCD*9.5  Increment Hours 3  X   
MAXACCR3  166  BCD*10.3  Max. Annual Accrual 3  X   
MAXCARRY3  167  BCD*10.3  Max. Carry-over Hours 3  X   
SVCYEAR4  168  Integer  Service Year 4  X   
BEGHRS4  169  BCD*10.3  Beginning Hours 4  X   
INCRHRS4  170  BCD*9.5  Increment Hours 4  X   
MAXACCR4  171  BCD*10.3  Max. Annual Accrual 4  X   
MAXCARRY4  172  BCD*10.3  Max. Carry-over Hours 4  X   
LEVEL  173  Integer  Level  E A X   
LISTUSEBHI  174  Integer  Base Hours List Use  X   
REGULARBHI  175  Integer  Base Hours Regular  X   
OVRTIMEBHI  176  Integer  Base Hours Overtime  X   
LISTUSEBEI  177  Integer  Base Earnings List Use  X   
REGULARBEI  178  Integer  Base Earnings Regular  X   
OVRTIMEBEI  179  Integer  Base Earnings Overtime  X   
SHIFTBEI  180  Integer  Base Earnings Shift  X   
LISTUSEBDI  181  Integer  Base Deductions List Use  X   
LISTUSEBTI  182  Integer  Base Tax List Use  X   
LISTUSETTW  183  Integer  List Use of Type of Taxable Wages  E A X   
WHMETHTTW  184  Integer  RESERVED - US Only   
LISTUSETDB  185  Integer  Take Deduction Before List Use  X   
ET4BOX  186  Integer  Employee T4 Box Type  E A P X D  List: 11 entries
1=Not Applicable
10=Box 42-Employment Commissions
20=Box 71-Status Indian
22=Box 77-WCB Repaid
26=Fishers-Prescribed & Amt.Paid to Others
27=Box 79-Fishers-Net Partnership Amount
28=Box 80-Fishers-Share-person Amount
30=Box 81-Taxable-Employ. Agency
31=Box 81-Non Taxable-Employ. Agency
32=Box 82-Taxi Driver
33=Box 83-Barbers and Hairdressers
RT4BOX  187  Integer  Employer T4 Box Type  E A P X D  List: 11 entries
1=Not Applicable
10=Box 42-Employment Commissions
20=Box 71-Status Indian
22=Box 77-WCB Repaid
26=Fishers-Prescribed & Amt.Paid to Others
27=Box 79-Fishers-Net Partnership Amount
28=Box 80-Fishers-Share-person Amount
30=Box 81-Taxable-Employ. Agency
31=Box 81-Non Taxable-Employ. Agency
32=Box 82-Taxi Driver
33=Box 83-Barbers and Hairdressers
ER1BOX  188  Integer  Employee R1 Box Type  E A P X D  List: 26 entries
1=Not Applicable
9=Box M-Commissions Incl. in Box A
11=Box O-Other Taxable Income
15=Box R-Income paid to an Indian
16=RA-Suppl Unemploymt Benefit
17=RB-Schol'p, Bursary, Fellow'p, Prize
18=RC-Research Grant
19=RD-Fee for Service Rendered
22=RG-Labour Adjustment Benefit
23=RH-Labour Adj: Older & Comp Inc
24=RI-Benft of Dept. Fisheries and Oceans
25=RJ-Retiring Allowance
26=RK-Death Benefit
27=RL-Patronage Dividends
28=RM-Commiss'n Self-Empl Worker
29=RN-Benft PD (Wage Loss Ins Plan)
30=RO-Benft Rec'd by Shareholder
31=RP-Benft Rec'd by Partner
32=RQ-Alloc'd: Retire Comp Arrange't
33=RR-Serv Rend in QC:Non-res od Can
34=RS-Financial support
35=RT-Other Indemn Pd by Emplr
36=RU-Beneficiary under RESP
37=RV-Subscriber under RESP
38=RZ-Other Income
40=RX-Incentive Subsidy to the Apprentices
RR1BOX  189  Integer  Employer R1 Box Type  E A P X D  List: 26 entries
1=Not Applicable
9=Box M-Commissions Incl. in Box A
11=Box O-Other Taxable Income
15=Box R-Income paid to an Indian
16=RA-Suppl Unemploymt Benefit
17=RB-Schol'p, Bursary, Fellow'p, Prize
18=RC-Research Grant
19=RD-Fee for Service Rendered
22=RG-Labour Adjustment Benefit
23=RH-Labour Adj: Older & Comp Inc
24=RI-Benft of Dept. Fisheries and Oceans
25=RJ-Retiring Allowance
26=RK-Death Benefit
27=RL-Patronage Dividends
28=RM-Commiss'n Self-Empl Worker
29=RN-Benft PD (Wage Loss Ins Plan)
30=RO-Benft Rec'd by Shareholder
31=RP-Benft Rec'd by Partner
32=RQ-Alloc'd: Retire Comp Arrange't
33=RR-Serv Rend in QC:Non-res od Can
34=RS-Financial support
35=RT-Other Indemn Pd by Emplr
36=RU-Beneficiary under RESP
37=RV-Subscriber under RESP
38=RZ-Other Income
40=RX-Incentive Subsidy to the Apprentices
EASSOCW2SW  190  Boolean  RESERVED - US Only  X   
EASSOCTAX  191  String*6  RESERVED - US Only  X   
RASSOCW2SW  192  Boolean  RESERVED - US Only  X   
RASSOCTAX  193  String*6  RESERVED - US Only  X   
POSTBENE  194  Boolean  Post Benefit  X   
PAYACCRUAL  195  Boolean  Pay Accrual  X   
NONPERPYMT  196  Boolean  Nonperiodic Payment  E A X   
LINKEARN  197  String*6  Linked Earning  X   
VALUES  198  Long  Number of Optional Fields  E A C   
SWFLSA  199  Boolean  Include in Regular Rate OT Calc  X   
COMMINCREM  200  Boolean  Progressive Calc - Commissions  X   
WGANNUALIZ  201  Boolean  Annualized Wage Brackets  X   
WGBRINCREM  202  Boolean  Progressive Calc - Wage Brackets  X   
PIECINCREM  203  Boolean  Progressive Calc - Piece Rate  X   
ELIFETMMAX  204  BCD*10.3  Employee Lifetime Maximum  X   
RLIFETMMAX  205  BCD*10.3  Employer Lifetime Maximum  X   
E2NDRATEIN  206  Integer  Employee Secondary Rate Effective  E A P X D  List: 2 entries
0=Never
1=After Annual Maximum Reached
R2NDRATEIN  207  Integer  Employer Secondary Rate Effective  E A P X D  List: 2 entries
0=Never
1=After Annual Maximum Reached
E2NDRATE  208  BCD*9.5  Employee Secondary Rate  X   
R2NDRATE  209  BCD*9.5  Employer Secondary Rate  X   
SVCYEAR5  230  Integer  Service Year 5  X   
BEGHRS5  231  BCD*10.3  Beginning Hours 5  X   
INCRHRS5  232  BCD*9.5  Increment Hours 5  X   
MAXACCR5  233  BCD*10.3  Max. Annual Accrual 5  X   
MAXCARRY5  234  BCD*10.3  Max. Carry-over Hours 5  X   
SVCYEAR6  235  Integer  Service Year 6  X   
BEGHRS6  236  BCD*10.3  Beginning Hours 6  X   
INCRHRS6  237  BCD*9.5  Increment Hours 6  X   
MAXACCR6  238  BCD*10.3  Max. Annual Accrual 6  X   
MAXCARRY6  239  BCD*10.3  Max. Carry-over Hours 6  X   
SVCYEAR7  240  Integer  Service Year 7  X   
BEGHRS7  241  BCD*10.3  Beginning Hours 7  X   
INCRHRS7  242  BCD*9.5  Increment Hours 7  X   
MAXACCR7  243  BCD*10.3  Max. Annual Accrual 7  X   
MAXCARRY7  244  BCD*10.3  Max. Carry-over Hours 7  X   
SVCYEAR8  245  Integer  Service Year 8  X   
BEGHRS8  246  BCD*10.3  Beginning Hours 8  X   
INCRHRS8  247  BCD*9.5  Increment Hours 8  X   
MAXACCR8  248  BCD*10.3  Max. Annual Accrual 8  X   
MAXCARRY8  249  BCD*10.3  Max. Carry-over Hours 8  X   
SVCYEAR9  250  Integer  Service Year 9  X   
BEGHRS9  251  BCD*10.3  Beginning Hours 9  X   
INCRHRS9  252  BCD*9.5  Increment Hours 9  X   
MAXACCR9  253  BCD*10.3  Max. Annual Accrual 9  X   
MAXCARRY9  254  BCD*10.3  Max. Carry-over Hours 9  X   
SVCYEAR10  255  Integer  Service Year 10  X   
BEGHRS10  256  BCD*10.3  Beginning Hours 10  X   
INCRHRS10  257  BCD*9.5  Increment Hours 10  X   
MAXACCR10  258  BCD*10.3  Max. Annual Accrual 10  X   
MAXCARRY10  259  BCD*10.3  Max. Carry-over Hours 10  X   
CCOVERRIDE  260  Boolean  Cost Center Override Based on Calc Base  X   
BILLINGS  261  Long  Billing Rates  E A C   
BILLPCT1  262  BCD*5.5  Billing Percentage 1  X   
BILLPCT2  263  BCD*5.5  Billing Percentage 2  X   
BILLPCT3  264  BCD*5.5  Billing Percentage 3  X   
BILLPCT4  265  BCD*5.5  Billing Percentage 4  X   
BILLPCT5  266  BCD*5.5  Billing Percentage 5  X   
BILLPCT6  267  BCD*5.5  Billing Percentage 6  X   
MAXONREM  268  Boolean  Calc. Max. Carry-over based on Remaining Balance  X   
PROCESSCMD  210  Integer  Process Command Code  E A C  List: 3 entries
0=Initialize New Record
1=Insert Optional Fields
2=Check for Timecard and Manual Cheques

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.