wa_redata - 补发工资数据表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_wa_redata | 补发表主键 | CHAR | Y | 20 | 0 | | | | |
classid | 工资类别id | CHAR | | 20 | 0 | | | | |
cperiod | 期间 | CHAR | | 2 | 0 | | | | |
creperiod | 补发期间 | VARCHAR | | 2 | 0 | | | | |
creyear | 补发年度 | VARCHAR | | 4 | 0 | | | | |
cyear | 年度 | CHAR | | 4 | 0 | | | | |
deptid | 部门id | CHAR | | 20 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
f_1 | 应发合计 | DECIMAL | | 20 | 8 | 0 | | | |
f_10 | 补发扣税 | DECIMAL | | 20 | 8 | 0 | | | |
f_100 | 预留100 | DECIMAL | | 20 | 8 | 0 | | | |
f_101 | 预留101 | VARCHAR | | 128 | 0 | | | | |
f_102 | 预留102 | VARCHAR | | 128 | 0 | | | | |
f_103 | 预留103 | VARCHAR | | 128 | 0 | | | | |
f_104 | 预留104 | VARCHAR | | 128 | 0 | | | | |
f_105 | 预留105 | VARCHAR | | 128 | 0 | | | | |
f_106 | 预留106 | VARCHAR | | 128 | 0 | | | | |
f_107 | 预留107 | VARCHAR | | 128 | 0 | | | | |
f_108 | 预留108 | VARCHAR | | 128 | 0 | | | | |
f_109 | 预留109 | VARCHAR | | 128 | 0 | | | | |
f_11 | 补发金额 | DECIMAL | | 20 | 8 | 0 | | | |
f_110 | 预留110 | VARCHAR | | 128 | 0 | | | | |
f_111 | 预留111 | VARCHAR | | 128 | 0 | | | | |
f_112 | 预留112 | VARCHAR | | 128 | 0 | | | | |
f_113 | 预留113 | VARCHAR | | 128 | 0 | | | | |
f_114 | 预留114 | VARCHAR | | 128 | 0 | | | | |
f_115 | 预留115 | VARCHAR | | 128 | 0 | | | | |
f_116 | 预留116 | VARCHAR | | 128 | 0 | | | | |
f_117 | 预留117 | VARCHAR | | 128 | 0 | | | | |
f_118 | 预留118 | VARCHAR | | 128 | 0 | | | | |
f_119 | 预留119 | VARCHAR | | 128 | 0 | | | | |
f_12 | 预留12 | DECIMAL | | 20 | 8 | 0 | | | |
f_120 | 预留120 | VARCHAR | | 128 | 0 | | | | |
f_121 | 预留121 | CHAR | | 10 | 0 | | | | |
f_122 | 预留122 | CHAR | | 10 | 0 | | | | |
f_123 | 预留123 | CHAR | | 10 | 0 | | | | |
f_124 | 预留124 | CHAR | | 10 | 0 | | | | |
f_125 | 预留125 | CHAR | | 10 | 0 | | | | |
f_126 | 预留126 | CHAR | | 10 | 0 | | | | |
f_127 | 预留127 | CHAR | | 10 | 0 | | | | |
f_128 | 预留128 | CHAR | | 10 | 0 | | | | |
f_129 | 预留129 | CHAR | | 10 | 0 | | | | |
f_13 | 预留13 | DECIMAL | | 20 | 8 | 0 | | | |
f_130 | 预留130 | CHAR | | 10 | 0 | | | | |
f_14 | 预留14 | DECIMAL | | 20 | 8 | 0 | | | |
f_15 | 预留15 | DECIMAL | | 20 | 8 | 0 | | | |
f_16 | 预留16 | DECIMAL | | 20 | 8 | 0 | | | |
f_17 | 预留17 | DECIMAL | | 20 | 8 | 0 | | | |
f_18 | 预留18 | DECIMAL | | 20 | 8 | 0 | | | |
f_19 | 预留19 | DECIMAL | | 20 | 8 | 0 | | | |
f_2 | 扣款合计 | DECIMAL | | 20 | 8 | 0 | | | |
f_20 | 预留20 | DECIMAL | | 20 | 8 | 0 | | | |
f_21 | 预留21 | DECIMAL | | 20 | 8 | 0 | | | |
f_22 | 预留22 | DECIMAL | | 20 | 8 | 0 | | | |
f_23 | 预留23 | DECIMAL | | 20 | 8 | 0 | | | |
f_24 | 预留24 | DECIMAL | | 20 | 8 | 0 | | | |
f_25 | 预留25 | DECIMAL | | 20 | 8 | 0 | | | |
f_26 | 预留26 | DECIMAL | | 20 | 8 | 0 | | | |
f_27 | 预留27 | DECIMAL | | 20 | 8 | 0 | | | |
f_28 | 预留28 | DECIMAL | | 20 | 8 | 0 | | | |
f_29 | 预留29 | DECIMAL | | 20 | 8 | 0 | | | |
f_3 | 实发合计 | DECIMAL | | 20 | 8 | 0 | | | |
f_30 | 预留30 | DECIMAL | | 20 | 8 | 0 | | | |
f_31 | 预留31 | DECIMAL | | 20 | 8 | 0 | | | |
f_32 | 预留32 | DECIMAL | | 20 | 8 | 0 | | | |
f_33 | 预留33 | DECIMAL | | 20 | 8 | 0 | | | |
f_34 | 预留34 | DECIMAL | | 20 | 8 | 0 | | | |
f_35 | 预留35 | DECIMAL | | 20 | 8 | 0 | | | |
f_36 | 预留36 | DECIMAL | | 20 | 8 | 0 | | | |
f_37 | 预留37 | DECIMAL | | 20 | 8 | 0 | | | |
f_38 | 预留38 | DECIMAL | | 20 | 8 | 0 | | | |
f_39 | 预留39 | DECIMAL | | 20 | 8 | 0 | | | |
f_4 | 本次扣税 | DECIMAL | | 20 | 8 | 0 | | | |
f_40 | 预留40 | DECIMAL | | 20 | 8 | 0 | | | |
f_41 | 预留41 | DECIMAL | | 20 | 8 | 0 | | | |
f_42 | 预留42 | DECIMAL | | 20 | 8 | 0 | | | |
f_43 | 预留43 | DECIMAL | | 20 | 8 | 0 | | | |
f_44 | 预留44 | DECIMAL | | 20 | 8 | 0 | | | |
f_45 | 预留45 | DECIMAL | | 20 | 8 | 0 | | | |
f_46 | 预留46 | DECIMAL | | 20 | 8 | 0 | | | |
f_47 | 预留47 | DECIMAL | | 20 | 8 | 0 | | | |
f_48 | 预留48 | DECIMAL | | 20 | 8 | 0 | | | |
f_49 | 预留49 | DECIMAL | | 20 | 8 | 0 | | | |
f_5 | 本次计税基数 | DECIMAL | | 20 | 8 | 0 | | | |
f_50 | 预留50 | DECIMAL | | 20 | 8 | 0 | | | |
f_51 | 预留51 | DECIMAL | | 20 | 8 | 0 | | | |
f_52 | 预留52 | DECIMAL | | 20 | 8 | 0 | | | |
f_53 | 预留53 | DECIMAL | | 20 | 8 | 0 | | | |
f_54 | 预留54 | DECIMAL | | 20 | 8 | 0 | | | |
f_55 | 预留55 | DECIMAL | | 20 | 8 | 0 | | | |
f_56 | 预留56 | DECIMAL | | 20 | 8 | 0 | | | |
f_57 | 预留57 | DECIMAL | | 20 | 8 | 0 | | | |
f_58 | 预留58 | DECIMAL | | 20 | 8 | 0 | | | |
f_59 | 预留59 | DECIMAL | | 20 | 8 | 0 | | | |
f_6 | 本月扣零 | DECIMAL | | 20 | 8 | 0 | | | |
f_60 | 预留60 | DECIMAL | | 20 | 8 | 0 | | | |
f_61 | 预留61 | DECIMAL | | 20 | 8 | 0 | | | |
f_62 | 预留62 | DECIMAL | | 20 | 8 | 0 | | | |
f_63 | 预留63 | DECIMAL | | 20 | 8 | 0 | | | |
f_64 | 预留64 | DECIMAL | | 20 | 8 | 0 | | | |
f_65 | 预留65 | DECIMAL | | 20 | 8 | 0 | | | |
f_66 | 预留66 | DECIMAL | | 20 | 8 | 0 | | | |
f_67 | 预留67 | DECIMAL | | 20 | 8 | 0 | | | |
f_68 | 预留68 | DECIMAL | | 20 | 8 | 0 | | | |
f_69 | 预留69 | DECIMAL | | 20 | 8 | 0 | | | |
f_7 | 上月扣零 | DECIMAL | | 20 | 8 | 0 | | | |
f_70 | 预留70 | DECIMAL | | 20 | 8 | 0 | | | |
f_71 | 预留71 | DECIMAL | | 20 | 8 | 0 | | | |
f_72 | 预留72 | DECIMAL | | 20 | 8 | 0 | | | |
f_73 | 预留73 | DECIMAL | | 20 | 8 | 0 | | | |
f_74 | 预留74 | DECIMAL | | 20 | 8 | 0 | | | |
f_75 | 预留75 | DECIMAL | | 20 | 8 | 0 | | | |
f_76 | 预留76 | DECIMAL | | 20 | 8 | 0 | | | |
f_77 | 预留77 | DECIMAL | | 20 | 8 | 0 | | | |
f_78 | 预留78 | DECIMAL | | 20 | 8 | 0 | | | |
f_79 | 预留79 | DECIMAL | | 20 | 8 | 0 | | | |
f_8 | 已扣税 | DECIMAL | | 20 | 8 | 0 | | | |
f_80 | 预留80 | DECIMAL | | 20 | 8 | 0 | | | |
f_81 | 预留81 | DECIMAL | | 20 | 8 | 0 | | | |
f_82 | 预留82 | DECIMAL | | 20 | 8 | 0 | | | |
f_83 | 预留83 | DECIMAL | | 20 | 8 | 0 | | | |
f_84 | 预留84 | DECIMAL | | 20 | 8 | 0 | | | |
f_85 | 预留85 | DECIMAL | | 20 | 8 | 0 | | | |
f_86 | 预留86 | DECIMAL | | 20 | 8 | 0 | | | |
f_87 | 预留87 | DECIMAL | | 20 | 8 | 0 | | | |
f_88 | 预留88 | DECIMAL | | 20 | 8 | 0 | | | |
f_89 | 预留89 | DECIMAL | | 20 | 8 | 0 | | | |
f_9 | 已扣税基数 | DECIMAL | | 20 | 8 | 0 | | | |
f_90 | 预留90 | DECIMAL | | 20 | 8 | 0 | | | |
iflag | 补发标志 | SMALLINT | | 2 | 0 | 0 | | | |
irecaculateflag | 重计算标志 | SMALLINT | | 2 | 0 | 0 | | | |
istopflag | 停发标志 | SMALLINT | | 2 | 0 | 0 | | | |
pk_psnbasdoc | 人员基本主键 | CHAR | | 20 | 0 | | | | |
psnclid | 人员类别id | CHAR | | 20 | 0 | | | | |
psnid | 人员id | CHAR | | 20 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
外键列表
索引列表