| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
主键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. |
| attendance_full_days |
满勤天数 |
decimal number |
None. |
| attendance_days |
出勤天数 |
decimal number |
None. |
| absence_days |
缺勤天数 |
decimal number |
None. |
| month_pay |
月薪(基本工资) |
decimal number |
None. |
| lev_pay |
职级工资 |
decimal number |
None. |
| base_pos_pay |
岗位工资 |
decimal number |
None. |
| moreattendance_reward |
多勤工资 |
decimal number |
None. |
| absence_cut |
缺勤扣款 |
decimal number |
None. |
| late_cut |
迟到扣款 |
decimal number |
None. |
| appeal_cut |
申诉扣款 |
decimal number |
None. |
| real_month_pay |
实发基本工资 |
decimal number |
None. |
| performance_reward |
绩效奖励 |
decimal number |
None. |
| reward |
奖金 |
decimal number |
None. |
| employeed_year_reward |
工龄工资 |
decimal number |
None. |
| communication_reward |
通讯补助 |
decimal number |
None. |
| fuel_reward |
油补 |
decimal number |
None. |
| other_reward |
其他补款 |
decimal number |
None. |
| real_pay |
应发合计 |
decimal number |
None. |
| performance_cut |
绩效扣款 |
decimal number |
None. |
| meal_fee_cut |
餐费 |
decimal number |
None. |
| insurance_cut |
社保扣款 |
decimal number |
None. |
| integral_cut |
积分扣款 |
decimal number |
None. |
| other_cut |
其他扣款 |
decimal number |
None. |
| real_cut |
扣款合计 |
decimal number |
None. |
| real_salary |
实发工资 |
decimal number |
None. |