NameDescriptionTypeAdditional 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_team_money

团队基数

decimal number

None.

middle_team_money

团队中值任务

decimal number

None.

high_team_money

团队高值任务

decimal number

None.

sale_team_money

团队销售金额

decimal number

None.

month_pay

基本工资

decimal number

None.

middle_growth_amount

中值增长额

decimal number

None.

middle_growth_ratio

中值增长率

decimal number

None.

middle_qualify_reward

达标中值奖励

decimal number

None.

high_performance

高值以上绩效

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_team_money

总团队基数

decimal number

None.

sum_middle_team_money

总团队中值任务

decimal number

None.

sum_high_team_money

总团队高值任务

decimal number

None.

sum_sale_team_money

总团队销售金额

decimal number

None.

sum_month_pay

总基本工资

decimal number

None.

sum_middle_growth_amount

总中值增长额

decimal number

None.

sum_middle_growth_ratio

总中值增长率

decimal number

None.

sum_middle_qualify_reward

总达标中值奖励

decimal number

None.

sum_high_performance

总高值以上绩效

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.