| 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. |
| store_id |
店铺Id，shop_tpm_store表主键 |
integer |
None. |
| store_name |
店铺名称 |
string |
None. |
| store_fee |
店铺管理金（全部高于同行均值得300） |
decimal number |
None. |
| store_sales |
店铺销售额 |
decimal number |
None. |
| sales_commission_ratio |
店铺销售提成比例 |
string |
None. |
| sales_commission |
店铺销售提成金额 |
decimal number |
None. |
| sales_commission_total |
提成金额 |
decimal number |
None. |
| policy_products_num |
政策产品数量 |
integer |
None. |
| policy_products_bonus |
政策产品金额 |
decimal number |
None. |
| delivery_order_num |
发货订单数量即出库单数量 |
integer |
None. |
| delivery_order_bonus |
发货订单奖励（出库单数量*0.05） |
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_store_fee |
店铺管理金合计 |
decimal number |
None. |
| sum_store_sales |
店铺销售额合计 |
decimal number |
None. |
| sum_sales_commission_total |
提成金额合计 |
decimal number |
None. |
| sum_policy_products_num |
政策产品数量合计 |
decimal number |
None. |
| sum_policy_products_bonus |
政策产品金额合计 |
decimal number |
None. |
| sum_delivery_order_bonus |
发货订单奖励合计 |
decimal number |
None. |
| sum_total_commission |
提成合计 |
decimal number |
None. |