| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
主键 |
integer |
None. |
| relation_id |
关联id |
integer |
None. |
| salary_date |
工资时间 格式:201701 |
string |
None. |
| salary_type |
0:政策产品提成 1:销售额提成 |
integer |
None. |
| d_id |
部门id |
integer |
None. |
| d_name |
部门名称 |
string |
None. |
| emp_id |
员工id |
integer |
None. |
| emp_code |
工号 |
string |
None. |
| emp_name |
姓名 |
string |
None. |
| base_team_money |
团队基数 |
decimal number |
None. |
| middle_team_money |
团队中值任务 |
decimal number |
None. |
| high_team_money |
团队高值任务 |
decimal number |
None. |
| sale_team_money |
团队销售金额 |
decimal number |
None. |
| month_pay |
基本工资 |
decimal number |
None. |
| middle_growth_amount |
中值增长额 |
decimal number |
None. |
| middle_growth_ratio |
中值增长率 |
decimal number |
None. |
| middle_qualify_reward |
达标中值奖励 |
decimal number |
None. |
| high_performance |
高值以上绩效 |
decimal number |
None. |
| total_task_commission |
提成合计 |
decimal number |
None. |
| base_completion_rate |
基数完成率 |
decimal number |
None. |
| un_tasks_performance |
未完成任务倒扣业绩 |
decimal number |
None. |
| amount |
合计 |
decimal number |
None. |
| pos_pay |
岗位工资 |
decimal number |
None. |
| amount_performance |
绩效合计 |
decimal number |
None. |
| create_time |
添加时间 |
date |
None. |
| update_time |
更新时间 |
date |
None. |
| update_name |
最后更新人 |
string |
None. |
| is_delete |
是否删除:0-未删除 1-删除 |
integer |
None. |
| sum_base_team_money |
总团队基数 |
decimal number |
None. |
| sum_middle_team_money |
总团队中值任务 |
decimal number |
None. |
| sum_high_team_money |
总团队高值任务 |
decimal number |
None. |
| sum_sale_team_money |
总团队销售金额 |
decimal number |
None. |
| sum_month_pay |
总基本工资 |
decimal number |
None. |
| sum_middle_growth_amount |
总中值增长额 |
decimal number |
None. |
| sum_middle_growth_ratio |
总中值增长率 |
decimal number |
None. |
| sum_middle_qualify_reward |
总达标中值奖励 |
decimal number |
None. |
| sum_high_performance |
总高值以上绩效 |
decimal number |
None. |
| sum_total_task_commission |
总提成合计 |
decimal number |
None. |
| sum_base_completion_rate |
总基数完成率 |
decimal number |
None. |
| sum_un_tasks_performance |
总未完成任务倒扣业绩 |
decimal number |
None. |
| sum_amount |
总合计 |
decimal number |
None. |
| sum_pos_pay |
总岗位工资 |
decimal number |
None. |
| sum_amount_performance |
总绩效合计 |
decimal number |
None. |