wa_psnappaprove_b - 员工个人定调资申请单子表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_wa_chglvsht_bill | 员工定调资信息分录主键 | CHAR | Y | 20 | 0 | | | | |
actpsncount | 实际调整金额 | DECIMAL | | 20 | 8 | 0 | | | |
applyreason | 申请理由 | VARCHAR | | 100 | 0 | | | | |
approved | 批准通过 | CHAR | | 1 | 0 | | | | |
confirmstate | 审批状态 | SMALLINT | | 2 | 0 | | | | |
displayindex | 排列序号 | SMALLINT | | 2 | 0 | 0 | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
fix_adjust_flag | 定调资标志 | SMALLINT | | 2 | 0 | | | | |
negotiation | 谈判工资 | CHAR | | 1 | 0 | | | | |
negotiation_wage | 是否是谈判工资 | SMALLINT | | 2 | 0 | 0 | | | |
pk_psndoc | 人员主键 | CHAR | | 20 | 0 | | | | |
pk_wa_crt_apply | 申请级别主键 | VARCHAR | | 20 | 0 | | | | |
pk_wa_crt_cofm | 批准级别主键 | CHAR | | 20 | 0 | | | | |
pk_wa_crt_old | 原有级别主键 | CHAR | | 20 | 0 | | | | |
pk_wa_grd | 薪资等级类别主键 | CHAR | | 20 | 0 | | | | |
pk_wa_item | 薪资项目主键 | CHAR | | 20 | 0 | | | | |
pk_wachglvsht | 员工定调资申请单主键 | CHAR | | 20 | 0 | | | | |
planpsncount | 计划调整金额 | DECIMAL | | 20 | 8 | 0 | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
vnote | 备注 | VARCHAR | | 100 | 0 | | | | |
wa_apply_money | 申请金额 | DECIMAL | | 20 | 8 | | | | |
wa_cofm_money | 批准金额 | DECIMAL | | 20 | 8 | | | | |
wa_old_money | 原始金额 | DECIMAL | | 20 | 8 | | | | |
外键列表
索引列表