Name | Description | Type | Additional information |
---|---|---|---|
id |
主键 |
integer |
None. |
salary_date |
工资时间 格式:201701 |
string |
None. |
d_id |
部门id |
integer |
None. |
d_name |
部门名称 |
string |
None. |
emp_id |
员工编号(主键) |
integer |
None. |
emp_name |
姓名 |
string |
None. |
add_time |
添加时间 |
date |
None. |
update_time |
更新时间 |
date |
None. |
wuliu_num |
物流单数 |
integer |
None. |
wuliu_terminal_num |
终端物流单数 |
integer |
None. |
wuliu_price |
物流单价 |
decimal number |
None. |
shipping_num |
快递单数 |
integer |
None. |
shipping_terminal_num |
终端快递单数 |
integer |
None. |
shipping_price |
快递单价 |
decimal number |
None. |
review_performance |
验货绩效(物流单数*物流单价+快递单数*快递单价) |
decimal number |
None. |
weigh_days |
称重天数 |
integer |
None. |
weigh_performance |
称重绩效((称重天数-3)*170) |
decimal number |
None. |
pallet_money |
打托 |
decimal number |
None. |
amount_performance |
绩效统计 |
decimal number |
None. |
sum_wuliu_num |
总物流单数 |
integer |
None. |
sum_wuliu_terminal_num |
总终端物流单数 |
integer |
None. |
sum_shipping_num |
总快递单数 |
integer |
None. |
sum_shipping_terminal_num |
总终端快递单数 |
integer |
None. |
sum_review_performance |
总验货绩效 |
decimal number |
None. |
sum_weigh_days |
总称重天数 |
integer |
None. |
sum_weigh_performance |
总称重绩效((称重天数-3)*170) |
decimal number |
None. |
sum_pallet_money |
总打托 |
decimal number |
None. |
sum_amount_performance |
总绩效统计 |
decimal number |
None. |