| 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_money |
基数 |
decimal number |
None. |
| middle_money |
中值任务 |
decimal number |
None. |
| high_money |
高值任务 |
decimal number |
None. |
| sale_money |
实际完成销售金额 |
decimal number |
None. |
| month_pay |
基本工资 |
decimal number |
None. |
| growth_amount |
增长额 |
decimal number |
None. |
| commission_ratio |
提成比例 |
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_money |
总基数 |
decimal number |
None. |
| sum_middle_money |
总中值任务 |
decimal number |
None. |
| sum_high_money |
总高值任务 |
decimal number |
None. |
| sum_sale_money |
总实际完成销售金额 |
decimal number |
None. |
| sum_month_pay |
总基本工资 |
decimal number |
None. |
| sum_growth_amount |
总增长额 |
decimal number |
None. |
| sum_commission_ratio |
总提成比例 |
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. |