Table: Earnings/Deductions

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

Keys: 2

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

Fields: 252

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 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 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: 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  Integer  Employer T4 Box Type  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  Integer  Employee R1 Box Type  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
21=RF-Maternity Allowance
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
RR1BOX  Integer  Employer R1 Box Type  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
21=RF-Maternity Allowance
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
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   
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 Secondary Rate Effective  List: 2 entries
0=Never
1=After Annual Maximum Reached
R2NDRATEIN  Integer  Employer Secondary 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   

This page was generated on 2008-May-02

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