Table: Earnings/Deductions

Table: CPDTLM
View: CP0007
Record Length: 1826

Flags: A R 

Keys: 2

Title Flags Fields
Earning/Deduction EARNDED
Category CATEGORY, EARDEDTYPE, EARNDED

Fields: 255

Field Type Title Presentation
EARNDED String*6 Earning/Deduction Mask: %-6N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
LONGDESC String*60 Earning/Deduction Description
SHORTDESC String*15 Earning/Deduction Short Description
INACTIVE Boolean Inactive
ASOF Date Inactive As Of
LASTMAINT Date Last Maintained
CATEGORY Integer Category List:6 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
EARDEDTYPE Integer Type List:3 entries
1 = Salary & Wages
2 = Reported Tips
3 = Allocated Tips
FREQUENCY Integer Frequency 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 Integer Starts List:4 entries
1 = Specific Month/Day
2 = Date of Hire
3 = Months after Hire
4 = Days after Hire
STARTMONTH Integer Start Month
STARTDAY Integer Start Day
ENDS Date Ends
PRNTONCHK Boolean Print On Cheque
PRNTIF0 Boolean RESERVED Print If Current Zero.
PRNTYTDIF0 Boolean RESERVED Print YTD If Current Zero
ECALCMETH Integer Employee Calculation Method 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 Integer RESERVED - US Only
ERATE BCD*9.5 Employee Rate
EANNUALMAX BCD*10.3 Employee Annual Maximum
EDAILYMIN BCD*10.3 Employee Daily Minimum
EDAILYMAX BCD*10.3 Employee Daily Maximum
EWEEKLYMIN BCD*10.3 Employee Weekly Minimum
EWEEKLYMAX BCD*10.3 Employee Weekly Maximum
EBIWKLYMIN BCD*10.3 Employee Biweekly Minimum
EBIWKLYMAX BCD*10.3 Employee Biweekly Maximum
ESEMIMNMIN BCD*10.3 Employee Semimonthly Minimum
ESEMIMNMAX BCD*10.3 Employee Semimonthly Maximum
EMNTHLYMIN BCD*10.3 Employee Monthly Minimum
EMNTHLYMAX BCD*10.3 Employee Monthly Maximum
EQRTRLYMIN BCD*10.3 Employee Quarterly Minimum
EQRTRLYMAX BCD*10.3 Employee Quarterly Maximum
E10PPPYMIN BCD*10.3 Employee Ten Period/Year Minimum
E10PPPYMAX BCD*10.3 Employee Ten Period/Year Maximum
E13PPPYMIN BCD*10.3 Employee Thirteen Period/Year Minimum
E13PPPYMAX BCD*10.3 Employee Thirteen Period/Year Maximum
E22PPPYMIN BCD*10.3 Employee Twentytwo Period/Year Minimum
E22PPPYMAX BCD*10.3 Employee Twentytwo Period/Year Maximum
ELIMITBASE Integer Employee Base Limit List:1 entries
1 = No Limit
WGBRACK1 BCD*10.3 Wage Bracket 1
WGADDAMT1 BCD*10.3 Add Amount 1
WGPCTOVR1 BCD*5.5 Percnt. of Excess 1
WGBRACK2 BCD*10.3 Wage Bracket 2
WGADDAMT2 BCD*10.3 Add Amount 2
WGPCTOVR2 BCD*5.5 Percnt. of Excess 2
WGBRACK3 BCD*10.3 Wage Bracket 3
WGADDAMT3 BCD*10.3 Add Amount 3
WGPCTOVR3 BCD*5.5 Percnt. of Excess 3
WGBRACK4 BCD*10.3 Wage Bracket 4
WGADDAMT4 BCD*10.3 Add Amount 4
WGPCTOVR4 BCD*5.5 Percnt. of Excess 4
WGBRACK5 BCD*10.3 Wage Bracket 5
WGADDAMT5 BCD*10.3 Add Amount 5
WGPCTOVR5 BCD*5.5 Percnt. of Excess 5
WGBRACK6 BCD*10.3 Wage Bracket 6
WGADDAMT6 BCD*10.3 Add Amount 6
WGPCTOVR6 BCD*5.5 Percnt. of Excess 6
WGBRACK7 BCD*10.3 Wage Bracket 7
WGADDAMT7 BCD*10.3 Add Amount 7
WGPCTOVR7 BCD*5.5 Percnt. of Excess 7
WGBRACK8 BCD*10.3 Wage Bracket 8
WGADDAMT8 BCD*10.3 Add Amount 8
WGPCTOVR8 BCD*5.5 Percnt. of Excess 8
WGBRACK9 BCD*10.3 Wage Bracket 9
WGADDAMT9 BCD*10.3 Add Amount 9
WGPCTOVR9 BCD*5.5 Percnt. of Excess 9
WGBRACK10 BCD*10.3 Wage Bracket 10
WGADDAMT10 BCD*10.3 Add Amount 10
WGPCTOVR10 BCD*5.5 Percnt. of Excess 10
WGBRACK11 BCD*10.3 Wage Bracket 11
WGADDAMT11 BCD*10.3 Add Amount 11
WGPCTOVR11 BCD*5.5 Percnt. of Excess 11
WGBRACK12 BCD*10.3 Wage Bracket 12
WGADDAMT12 BCD*10.3 Add Amount 12
WGPCTOVR12 BCD*5.5 Percnt. of Excess 12
WGBRACK13 BCD*10.3 Wage Bracket 13
WGADDAMT13 BCD*10.3 Add Amount 13
WGPCTOVR13 BCD*5.5 Percnt. of Excess 13
WGBRACK14 BCD*10.3 Wage Bracket 14
WGADDAMT14 BCD*10.3 Add Amount 14
WGPCTOVR14 BCD*5.5 Percnt. of Excess 14
WGBRACK15 BCD*10.3 Wage Bracket 15
WGADDAMT15 BCD*10.3 Add Amount 15
WGPCTOVR15 BCD*5.5 Percnt. of Excess 15
WGBRACK16 BCD*10.3 Wage Bracket 16
WGADDAMT16 BCD*10.3 Add Amount 16
WGPCTOVR16 BCD*5.5 Percnt. of Excess 16
WGBRACK17 BCD*10.3 Wage Bracket 17
WGADDAMT17 BCD*10.3 Add Amount 17
WGPCTOVR17 BCD*5.5 Percnt. of Excess 17
WGBRACK18 BCD*10.3 Wage Bracket 18
WGADDAMT18 BCD*10.3 Add Amount 18
WGPCTOVR18 BCD*5.5 Percnt. of Excess 18
WGBRACK19 BCD*10.3 Wage Bracket 19
WGADDAMT19 BCD*10.3 Add Amount 19
WGPCTOVR19 BCD*5.5 Percnt. of Excess 19
WGBRACK20 BCD*10.3 Wage Bracket 20
WGADDAMT20 BCD*10.3 Add Amount 20
WGPCTOVR20 BCD*5.5 Percnt. of Excess 20
RCALCMETH Integer Employer Calculation Method 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 Integer RESERVED - US Only
RRATE BCD*9.5 Employer Rate
RANNUALMAX BCD*10.3 Employer Annual Maximum
RDAILYMIN BCD*10.3 Employer Daily Minimum
RDAILYMAX BCD*10.3 Employer Daily Maximum
RWEEKLYMIN BCD*10.3 Employer Weekly Minimum
RWEEKLYMAX BCD*10.3 Employer Weekly Maximum
RBIWKLYMIN BCD*10.3 Employer Biweekly Minimum
RBIWKLYMAX BCD*10.3 Employer Biweekly Maximum
RSEMIMNMIN BCD*10.3 Employer Semimonthly Minimum
RSEMIMNMAX BCD*10.3 Employer Semimonthly Maximum
RMNTHLYMIN BCD*10.3 Employer Monthly Minimum
RMNTHLYMAX BCD*10.3 Employer Monthly Maximum
RQRTRLYMIN BCD*10.3 Employer Quarterly Minimum
RQRTRLYMAX BCD*10.3 Employer Quarterly Maximum
R10PPPYMIN BCD*10.3 Employer Ten Per/Year Minimum
R10PPPYMAX BCD*10.3 Employer Ten Per/Year Maximum
R13PPPYMIN BCD*10.3 Employer Thirteen Per/Year Minimum
R13PPPYMAX BCD*10.3 Employer Thirteen Per/Year Maximum
R22PPPYMIN BCD*10.3 Employer TwentyTwo Per/Year Minimum
R22PPPYMAX BCD*10.3 Employer TwentyTwo Per/Year Maximum
RLIMITBASE Integer Employer Base Limit List:1 entries
1 = No Limit
ALLOWWCC Boolean Subject to Workers' Compensation
COMMAMT1 BCD*10.3 Commission Amt. 1
COMMPCT1 BCD*5.5 Commission Pct. 1
COMMAMT2 BCD*10.3 Commission Amt. 2
COMMPCT2 BCD*5.5 Commission Pct. 2
COMMAMT3 BCD*10.3 Commission Amt. 3
COMMPCT3 BCD*5.5 Commission Pct. 3
COMMAMT4 BCD*10.3 Commission Amt. 4
COMMPCT4 BCD*5.5 Commission Pct. 4
COMMAMT5 BCD*10.3 Commission Amt. 5
COMMPCT5 BCD*5.5 Commission Pct. 5
COMMPCTX BCD*5.5 Commission Amt. excess
PIECNUM1 BCD*10.3 Piece count 1
PIECAMT1 BCD*9.5 Piece amount 1
PIECNUM2 BCD*10.3 Piece count 2
PIECAMT2 BCD*9.5 Piece amount 2
PIECNUM3 BCD*10.3 Piece count 3
PIECAMT3 BCD*9.5 Piece amount 3
PIECNUM4 BCD*10.3 Piece count 4
PIECAMT4 BCD*9.5 Piece amount 4
PIECNUM5 BCD*10.3 Piece count 5
PIECAMT5 BCD*9.5 Piece amount 5
PIECAMTX BCD*9.5 Max Piece Rate Amt.
TIPDISB Boolean Tip Disbursement
PAYDOWNDED Boolean Repayment Deduction
REPAYID String*6 Advance to Be Repaid
CARRYOVER Integer Carry-over List:4 entries
1 = Specific Month/Day
2 = Date of Hire
3 = Months after Hire
4 = Days after Hire
COVERDAY Integer Carry-over Day
COVERMONTH Integer Carry-over Month
POSTLIAB Boolean Post Liab.
SVCYEAR1 Integer Service Year 1
BEGHRS1 BCD*10.3 Beginning Hours 1
INCRHRS1 BCD*9.5 Increment Hours 1
MAXACCR1 BCD*10.3 Max. Annual Accrual 1
MAXCARRY1 BCD*10.3 Max. Carry-over Hours 1
SVCYEAR2 Integer Service Year 2
BEGHRS2 BCD*10.3 Beginning Hours 2
INCRHRS2 BCD*9.5 Increment Hours 2
MAXACCR2 BCD*10.3 Max. Annual Accrual 2
MAXCARRY2 BCD*10.3 Max. Carry-over Hours 2
SVCYEAR3 Integer Service Year 3
BEGHRS3 BCD*10.3 Beginning Hours 3
INCRHRS3 BCD*9.5 Increment Hours 3
MAXACCR3 BCD*10.3 Max. Annual Accrual 3
MAXCARRY3 BCD*10.3 Max. Carry-over Hours 3
SVCYEAR4 Integer Service Year 4
BEGHRS4 BCD*10.3 Beginning Hours 4
INCRHRS4 BCD*9.5 Increment Hours 4
MAXACCR4 BCD*10.3 Max. Annual Accrual 4
MAXCARRY4 BCD*10.3 Max. Carry-over Hours 4
LEVEL Integer Level
LISTUSEBHI Integer Base Hours List Use
REGULARBHI Integer Base Hours Regular
OVRTIMEBHI Integer Base Hours Overtime
LISTUSEBEI Integer Base Earnings List Use
REGULARBEI Integer Base Earnings Regular
OVRTIMEBEI Integer Base Earnings Overtime
SHIFTBEI Integer Base Earnings Shift
LISTUSEBDI Integer Base Deductions List Use
LISTUSEBTI Integer Base Tax List Use
LISTUSETTW Integer List Use of Type of Taxable Wages
WHMETHTTW Integer RESERVED - US Only
LISTUSETDB Integer Take Deduction Before List Use
ET4BOX Integer Employee T4 Box Type List:23 entries
1 = Not Applicable
10 = T4 - Box 42-Employment Commissions
20 = T4 - Box 71-Indian (exempt income)-Employment
22 = T4 - Box 77-WCB Repaid
26 = T4 - Fishers-Prescribed & Amt.Paid to Others
27 = T4 - Box 79-Fishers-Net Partnership Amount
28 = T4 - Box 80-Fishers-Shareperson Amount
30 = T4 - Box 81-Taxable-Employ. Agency Workers
31 = T4 - Box 81-Non Taxable-Employ. Agency Workers
32 = T4 - Box 82-Taxi Drivers
33 = T4 - Box 83-Barbers or Hairdressers
66 = T4 - Box 66-Eligible Retiring Allowances
67 = T4 - Box 67-Non-eligible Retiring Allowances
68 = T4 - Box 68-No longer used
69 = T4 - Box 69-Indian (Exempt Income)-Non-eligible Retiring Allowances
87 = T4 - Box 87-Emergency services volunteer exempt amount
99 = T4 - Seasonal Agricultural Workers Program
48 = T4A - Box 016-Pension or superannuation
49 = T4A - Box 018-Lump sum payments
50 = T4A - Box 020-Self-employed commissions
51 = T4A - Box 024-Annuities
52 = T4A - Box 048-Fees for services
53 = T4A - Other Information
RT4BOX Integer Employer T4 Box Type List:23 entries
1 = Not Applicable
10 = T4 - Box 42-Employment Commissions
20 = T4 - Box 71-Indian (exempt income)-Employment
22 = T4 - Box 77-WCB Repaid
26 = T4 - Fishers-Prescribed & Amt.Paid to Others
27 = T4 - Box 79-Fishers-Net Partnership Amount
28 = T4 - Box 80-Fishers-Shareperson Amount
30 = T4 - Box 81-Taxable-Employ. Agency Workers
31 = T4 - Box 81-Non Taxable-Employ. Agency Workers
32 = T4 - Box 82-Taxi Drivers
33 = T4 - Box 83-Barbers or Hairdressers
66 = T4 - Box 66-Eligible Retiring Allowances
67 = T4 - Box 67-Non-eligible Retiring Allowances
68 = T4 - Box 68-No longer used
69 = T4 - Box 69-Indian (Exempt Income)-Non-eligible Retiring Allowances
87 = T4 - Box 87-Emergency services volunteer exempt amount
99 = T4 - Seasonal Agricultural Workers Program
48 = T4A - Box 016-Pension or superannuation
49 = T4A - Box 018-Lump sum payments
50 = T4A - Box 020-Self-employed commissions
51 = T4A - Box 024-Annuities
52 = T4A - Box 048-Fees for services
53 = T4A - Other Information
ER1BOX Integer Employee R1 Box Type List:34 entries
1 = Not Applicable
9 = R1 - Box M-Commissions Incl. in Box A or Box R
11 = R1 - Box O-Other Taxable Income
15 = R1 - Box R-Income paid to an Indian
16 = R1 - RA-Suppl Unemploymt Benefit
17 = R1 - RB-Schol'p, Bursary, Fellow'p, Prize
18 = R1 - RC-Research Grant
19 = R1 - RD-Fee for Service Rendered
22 = R1 - RG-Labour Adjustment Benefit
23 = R1 - RH-Labour Adj: Older & Income Assistance
24 = R1 - RI-Benft of Dept. Fisheries and Oceans
25 = R1 - RJ-Retiring Allowance
26 = R1 - RK-Death Benefit
27 = R1 - RL-Patronage Dividends
28 = R1 - RM-Commiss'n Self-Empl Worker
29 = R1 - RN-Benft PD (Wage Loss Replacement Plan)
30 = R1 - RO-Benft Rec'd by Shareholder
31 = R1 - RP-Benft Rec'd by Partner
32 = R1 - RQ-Alloc'd: Retire Comp Arrange't
33 = R1 - RR-Serv Rend in QC:Non-res od Can
34 = R1 - RS-Financial Assistance
35 = R1 - RT-Other Indemn Pd by Emplr
36 = R1 - RU-Educational assistance from RESP
37 = R1 - RV-Accumulated income from RESP
38 = R1 - RZ-Other Income
40 = R1 - RX-Incentive Subsidy to the Apprentices
43 = R1 - CA-Wage Earner Protection Program
44 = R1 - CB-Tax-free Savings Account
45 = R1 - CC-Beneficiary of an RDSP
46 = R2 - Box A-Payments from a registered pension plan
47 = R2 - Box B-Payments under an RRSP, a RRIF or a DPSP, or annuities
48 = R2 - Box C-Other payments
49 = R2 - Box H-Other income (RRSP or RRIF)
50 = R2 - Other information
RR1BOX Integer Employer R1 Box Type List:34 entries
1 = Not Applicable
9 = R1 - Box M-Commissions Incl. in Box A or Box R
11 = R1 - Box O-Other Taxable Income
15 = R1 - Box R-Income paid to an Indian
16 = R1 - RA-Suppl Unemploymt Benefit
17 = R1 - RB-Schol'p, Bursary, Fellow'p, Prize
18 = R1 - RC-Research Grant
19 = R1 - RD-Fee for Service Rendered
22 = R1 - RG-Labour Adjustment Benefit
23 = R1 - RH-Labour Adj: Older & Income Assistance
24 = R1 - RI-Benft of Dept. Fisheries and Oceans
25 = R1 - RJ-Retiring Allowance
26 = R1 - RK-Death Benefit
27 = R1 - RL-Patronage Dividends
28 = R1 - RM-Commiss'n Self-Empl Worker
29 = R1 - RN-Benft PD (Wage Loss Replacement Plan)
30 = R1 - RO-Benft Rec'd by Shareholder
31 = R1 - RP-Benft Rec'd by Partner
32 = R1 - RQ-Alloc'd: Retire Comp Arrange't
33 = R1 - RR-Serv Rend in QC:Non-res od Can
34 = R1 - RS-Financial Assistance
35 = R1 - RT-Other Indemn Pd by Emplr
36 = R1 - RU-Educational assistance from RESP
37 = R1 - RV-Accumulated income from RESP
38 = R1 - RZ-Other Income
40 = R1 - RX-Incentive Subsidy to the Apprentices
43 = R1 - CA-Wage Earner Protection Program
44 = R1 - CB-Tax-free Savings Account
45 = R1 - CC-Beneficiary of an RDSP
46 = R2 - Box A-Payments from a registered pension plan
47 = R2 - Box B-Payments under an RRSP, a RRIF or a DPSP, or annuities
48 = R2 - Box C-Other payments
49 = R2 - Box H-Other income (RRSP or RRIF)
50 = R2 - Other information
EASSOCW2SW Boolean RESERVED - US Only
EASSOCTAX String*6 RESERVED - US Only
RASSOCW2SW Boolean RESERVED - US Only
RASSOCTAX String*6 RESERVED - US Only
POSTBENE Boolean Post Benefit
PAYACCRUAL Boolean Pay Accrual
NONPERPYMT Boolean Nonperiodic Payment/Deduction
LINKEARN String*6 Linked Earning
VALUES Long Number of Optional Fields
SWFLSA Boolean Include in Regular Rate OT Calc
COMMINCREM Boolean Progressive Calc - Commissions
WGANNUALIZ Boolean Annualized Wage Brackets
WGBRINCREM Boolean Progressive Calc - Wage Brackets
PIECINCREM Boolean Progressive Calc - Piece Rate
ELIFETMMAX BCD*10.3 Employee Lifetime Maximum
RLIFETMMAX BCD*10.3 Employer Lifetime Maximum
E2NDRATEIN Integer Employee Sec. Rate Effective List:2 entries
0 = Never
1 = After Annual Maximum Reached
R2NDRATEIN Integer Employer Sec. Rate Effective List:2 entries
0 = Never
1 = After Annual Maximum Reached
E2NDRATE BCD*9.5 Employee Secondary Rate
R2NDRATE BCD*9.5 Employer Secondary Rate
SVCYEAR5 Integer Service Year 5
BEGHRS5 BCD*10.3 Beginning Hours 5
INCRHRS5 BCD*9.5 Increment Hours 5
MAXACCR5 BCD*10.3 Max. Annual Accrual 5
MAXCARRY5 BCD*10.3 Max. Carry-over Hours 5
SVCYEAR6 Integer Service Year 6
BEGHRS6 BCD*10.3 Beginning Hours 6
INCRHRS6 BCD*9.5 Increment Hours 6
MAXACCR6 BCD*10.3 Max. Annual Accrual 6
MAXCARRY6 BCD*10.3 Max. Carry-over Hours 6
SVCYEAR7 Integer Service Year 7
BEGHRS7 BCD*10.3 Beginning Hours 7
INCRHRS7 BCD*9.5 Increment Hours 7
MAXACCR7 BCD*10.3 Max. Annual Accrual 7
MAXCARRY7 BCD*10.3 Max. Carry-over Hours 7
SVCYEAR8 Integer Service Year 8
BEGHRS8 BCD*10.3 Beginning Hours 8
INCRHRS8 BCD*9.5 Increment Hours 8
MAXACCR8 BCD*10.3 Max. Annual Accrual 8
MAXCARRY8 BCD*10.3 Max. Carry-over Hours 8
SVCYEAR9 Integer Service Year 9
BEGHRS9 BCD*10.3 Beginning Hours 9
INCRHRS9 BCD*9.5 Increment Hours 9
MAXACCR9 BCD*10.3 Max. Annual Accrual 9
MAXCARRY9 BCD*10.3 Max. Carry-over Hours 9
SVCYEAR10 Integer Service Year 10
BEGHRS10 BCD*10.3 Beginning Hours 10
INCRHRS10 BCD*9.5 Increment Hours 10
MAXACCR10 BCD*10.3 Max. Annual Accrual 10
MAXCARRY10 BCD*10.3 Max. Carry-over Hours 10
CCOVERRIDE Boolean Cost Center Override Based on Calc Base
BILLINGS Long Billing Rates
BILLPCT1 BCD*5.5 Billing Percentage 1
BILLPCT2 BCD*5.5 Billing Percentage 2
BILLPCT3 BCD*5.5 Billing Percentage 3
BILLPCT4 BCD*5.5 Billing Percentage 4
BILLPCT5 BCD*5.5 Billing Percentage 5
BILLPCT6 BCD*5.5 Billing Percentage 6
MAXONREM Boolean Calc. Max. Carry-over based on Remaining Balance
MAXONACCR Boolean Cap Accrual at Max. Accrual
COVID Integer RESERVED - US Only
OTHERBOX Integer Box List:4 entries
1 = 028 - Other income
2 = 104 - Research grants
3 = 105 - Scholarships, bursaries, fellowships...
4 = 130 - Apprenticeship, incentive grant or...

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