wa_dataz - 工资数据表（主币）
字段列表
| 编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | | pk_wa_dataz | 工资数据表（主币）主键 | CHAR | Y | 20 | 0 | | | | |
| classid | 工资类别id | CHAR | | 20 | 0 | | | | |
| cperiod | 期间 | CHAR | | 2 | 0 | | | | |
| cyear | 年度 | CHAR | | 4 | 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_11 | 补发金额 | DECIMAL | | 20 | 8 | 0 | | | |
| f_12 | 预留12 | DECIMAL | | 20 | 8 | 0 | | | |
| f_13 | 预留13 | DECIMAL | | 20 | 8 | 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 | | | |
| pk_psnbasdoc | 人员基本主键 | CHAR | | 20 | 0 | | | | |
| psnid | 人员id | CHAR | | 20 | 0 | | | | |
| redtotal | 补发总额 | DECIMAL | | 20 | 8 | 0 | | | |
| ts | 时间戳 | CHAR | | 19 | 0 | | | | |
外键列表
索引列表