| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
主键id |
integer |
None. |
| salary_date |
工资时间 格式:201701 |
string |
None. |
| salary_year |
所属年 |
integer |
None. |
| salary_month |
所属月 |
integer |
None. |
| salary_status |
状态：0-默认 |
integer |
None. |
| d_id |
部门id |
integer |
None. |
| d_name |
部门名称 |
string |
None. |
| emp_id |
员工Id |
integer |
None. |
| emp_code |
员工工号 |
string |
None. |
| emp_name |
姓名 |
string |
None. |
| post_name |
岗位名称 |
string |
None. |
| consult_bonus |
咨询量奖金（咨询量最多者得100） |
decimal number |
None. |
| sales_bonus |
销售额奖金（销售额最多者得100） |
decimal number |
None. |
| transform_rate_bonus |
转化率奖金（转化率最高得100） |
decimal number |
None. |
| average_response_bonus |
满意度奖金（满意度最高者得100） |
decimal number |
None. |
| satisfaction_bonus | decimal number |
None. |
|
| sale_money |
销售金额 |
decimal number |
None. |
| return_money |
退货金额 |
decimal number |
None. |
| sale_total |
销售总额 |
decimal number |
None. |
| sales_commission |
销售提成 |
decimal number |
None. |
| total_commission |
提成合计 |
decimal number |
None. |
| create_name |
创建人 |
string |
None. |
| create_time |
创建时间 |
date |
None. |
| update_name |
更新人 |
string |
None. |
| update_time |
更新时间 |
date |
None. |
| is_delete |
是否删除：0-未删除 1-删除 |
integer |
None. |
| sum_rows_num | integer |
None. |
|
| sum_consult_bonus |
咨询量奖金合计 |
decimal number |
None. |
| sum_sales_bonus |
销售额奖金合计 |
decimal number |
None. |
| sum_transform_rate_bonus |
转化率奖金合计 |
decimal number |
None. |
| sum_satisfaction_bonus |
满意度奖金合计 |
decimal number |
None. |
| sum_average_response_bonus |
平均响应奖金合计 |
decimal number |
None. |
| sum_sales_commission |
销售提成合计 |
decimal number |
None. |
| sum_total_commission |
提成合计 |
decimal number |
None. |