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