# Table: Earnings/Deductions

Table: CPDTLM
View: CP0007
Record length: 1484
Flags: A R

## Keys: 2

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

## Fields: 202

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 Descript |
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 Ze |
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 Mi |
E13PPPYMAX | BCD*10.3 | Employee Thirteen Period/Year Ma |
E22PPPYMIN | BCD*10.3 | Employee Twentytwo Period/Year M |
E22PPPYMAX | BCD*10.3 | Employee Twentytwo Period/Year M |
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 Calcuation 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 Minim |
R13PPPYMAX | BCD*10.3 | Employer Thirteen Per/Year Maxim |
R22PPPYMIN | BCD*10.3 | Employer TwentyTwo Per/Year Mini |
R22PPPYMAX | BCD*10.3 | Employer TwentyTwo Per/Year Maxi |
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 | Increament 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 | Increament 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 | Increament 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 | Increament 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 Wage |
WHMETHTTW | Integer | RESERVED - US Only |
LISTUSETDB | Integer | Take Deduction Before List Use |
ET4BOX | Integer | Employee T4 Box Type | List: 4 entries
1 | = | Not Applicable
10 | = | Box 42-Employment Commissions
20 | = | Box 71-Status Indian
22 | = | Box 77-WCB Repaid
RT4BOX | Integer | Employer T4 Box Type | List: 4 entries
1 | = | Not Applicable
10 | = | Box 42-Employment Commissions
20 | = | Box 71-Status Indian
22 | = | Box 77-WCB Repaid
ER1BOX | Integer | Employee R1 Box Type | List: 28 entries
1 | = | Not Applicable
9 | = | Box M-Commissions Incl. in Box A
11 | = | Box O-Other Taxable Income
15 | = | Box R-Tax-exempt 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
20 | = | RE-Training Allowance
21 | = | RF-Maternity Allowance
22 | = | RG-Labour Adjustment Benefit
23 | = | RH-Labour Adj: Older & Comp Inc
24 | = | RI-Plant Wkr Adj/North Cod Comp Adj
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-Indem PD: Precaut Cess Wrk
35 | = | RT-Other Indemn Pd by Emplr
36 | = | RU-Beneficiary under RESP
37 | = | RV-Subscriber under RESP
39 | = | RW-Action Emploi Program
38 | = | RZ-Other Income
RR1BOX | Integer | Employer R1 Box Type | List: 28 entries
1 | = | Not Applicable
9 | = | Box M-Commissions Incl. in Box A
11 | = | Box O-Other Taxable Income
15 | = | Box R-Tax-exempt 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
20 | = | RE-Training Allowance
21 | = | RF-Maternity Allowance
22 | = | RG-Labour Adjustment Benefit
23 | = | RH-Labour Adj: Older & Comp Inc
24 | = | RI-Plant Wkr Adj/North Cod Comp Adj
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-Indem PD: Precaut Cess Wrk
35 | = | RT-Other Indemn Pd by Emplr
36 | = | RU-Beneficiary under RESP
37 | = | RV-Subscriber under RESP
39 | = | RW-Action Emploi Program
38 | = | RZ-Other Income
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 |
LINKEARN | String*6 | Linked Earning |
VALUES | Long | Number of Optional Fields |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.