| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
主键id |
integer |
None. |
| salary_date |
工资时间 格式:201701 |
string |
None. |
| salary_year |
所属年 |
integer |
None. |
| salary_month |
所属月 |
integer |
None. |
| d_id |
部门id |
integer |
None. |
| d_name |
部门名称 |
string |
None. |
| emp_id |
员工Id |
integer |
None. |
| emp_code |
员工工号 |
string |
None. |
| emp_name |
姓名 |
string |
None. |
| emp_id_junyu |
员工Id |
integer |
None. |
| emp_code_junyu |
员工工号 |
string |
None. |
| sale_money |
销售金额 |
decimal number |
None. |
| return_money |
退货金额 |
decimal number |
None. |
| sale_total |
销售总额 |
decimal number |
None. |
| sale_node_one |
第一节点销售总额 |
decimal number |
None. |
| sale_node_two |
第二节点销售总额 |
decimal number |
None. |
| sale_node_three |
第三节点销售总额 |
decimal number |
None. |
| sale_node_four |
第四节点销售总额 |
decimal number |
None. |
| base_money |
基数 |
decimal number |
None. |
| middle_money |
中值 |
decimal number |
None. |
| high_money |
高值 |
decimal number |
None. |
| middle_average_money |
节点（中值/4） |
decimal number |
None. |
| sales_commission |
销售提成 |
decimal number |
None. |
| sale_node_bonus |
节点奖金 |
decimal number |
None. |
| sale_month_bonus |
月度奖金 |
decimal number |
None. |
| sale_team_total |
团队奖金合计 |
decimal number |
None. |
| sale_team_bonus |
团队奖金 |
decimal number |
None. |
| total_commission |
提成合计 |
decimal number |
None. |
| is_head |
是否是负责人：0-不是 1-是 |
integer |
None. |
| sum_rows_num |
总行数 |
integer |
None. |
| sum_sale_total |
销售总额合计 |
decimal number |
None. |
| sum_sale_node_one |
第一节点销售总额合计 |
decimal number |
None. |
| sum_sale_node_two |
第二节点销售总额合计 |
decimal number |
None. |
| sum_sale_node_three |
第三节点销售总额合计 |
decimal number |
None. |
| sum_sale_node_four |
第四节点销售总额合计 |
decimal number |
None. |
| sum_base_money |
基数合计 |
decimal number |
None. |
| sum_middle_money |
中值合计 |
decimal number |
None. |
| sum_high_money |
高值合计 |
decimal number |
None. |
| sum_middle_average_money |
节点（中值/4）合计 |
decimal number |
None. |
| sum_sales_commission |
销售提成合计 |
decimal number |
None. |
| sum_sale_node_bonus |
节点奖金合计 |
decimal number |
None. |
| sum_sale_month_bonus |
月度奖金合计 |
decimal number |
None. |
| sum_sale_team_total |
团队奖金合计 |
decimal number |
None. |
| sum_sale_team_bonus |
团队奖金合计 |
decimal number |
None. |
| sum_total_commission |
提成合计合计 |
decimal number |
None. |