Table: Employee Earnings/Deductions

Table: CPEMPD
View: CP0008
Record length: 356
Flags: A R 

Keys: 4

Title  Flags  Fields

Employee Earning/Deduction Code  EMPLOYEE, EARNDED
Employee, Category, Type  EMPLOYEE, CATEGORY, EARDEDTYPE, EARNDED
Earning/Deduction Code, Distribu  D M  EARNDED, DISTCODE
Earning/Deduction Code, Employee  EARNDED, EMPLOYEE

Fields: 49

Field  Type  Title  Presentation 

EMPLOYEE  String*12  Employee  Mask: %-12N
EARNDED  String*6  Employee Earning/Deduction  Mask: %-6N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
CALCULATE  Boolean  Calculate  List: 2 entries
0=No
1=Yes
STARTS  Date  Start date   
ENDS  Date  End date   
GLSEG1  String*15  Segment Name 1  Mask: %-15N
GLSEG2  String*15  Segment Name 2  Mask: %-15N
GLSEG3  String*15  Segment Name 3  Mask: %-15N
DISTCODE  String*6  Distribution code  Mask: %-6N
ERATE  BCD*9.5  Employee Rate/Amt/Pct.   
RRATE  BCD*9.5  Employer Amt/Pct.   
WCC  String*6  Workers' Compensation Code  Mask: %-6N
REPAYID  String*6  Advance To Be Repaid  Mask: %-6N
CARRYDATE  Date  Carry-over   
BALANCE  BCD*10.3  Balance   
ACCRUED  BCD*10.3  Accrued   
PAID  BCD*10.3  Paid   
DEFAULTHRS  BCD*4.3  Default hours   
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
7=Vacation
8=Sick
9=Banked Time
AMTPAID  BCD*10.3  Amount Paid   
USERTC  Boolean  Available in Employee Timecards  List: 2 entries
0=No
1=Yes
WCCGROUP  String*6  Workers Comp. Group  Mask: %-6N
VALUES  Long  Number of Optional Fields   
SWFLSA  Boolean  Include in Regular Rate OT Calc   
EPERIODMIN  BCD*10.3  Employee Period Minimum   
EPERIODMAX  BCD*10.3  Employee Period Maximum   
EANNUALMAX  BCD*10.3  Employee Annual Maximum   
ELIFETMMAX  BCD*10.3  Employee Lifetime Maximum   
ELTDAMT  BCD*10.3  Employee Lifetime Accumulation   
E2NDRATE  BCD*9.5  Employee Secondary Rate/Amt/Pct.   
RPERIODMIN  BCD*10.3  Employer Period Minimum   
RPERIODMAX  BCD*10.3  Employer Period Maximum   
RANNUALMAX  BCD*10.3  Employer Annual Maximum   
RLIFETMMAX  BCD*10.3  Employer Lifetime Maximum   
RLTDAMT  BCD*10.3  Employer Lifetime Accumulation   
R2NDRATE  BCD*9.5  Employer Secondary Amt/Pct.   
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   
SWALLOCJOB  Boolean  Jobs Alloc Based on Calc Base   

This page was generated on 2009-Nov-19

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