薪资期初余额
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| CumReductionTax (T+15.0) | 累计月度减免税额 | decimal | 13 | True | |
| UpdatedBy (T+15.0) | 更新者 | varchar | 50 | True | |
| CreatTime (T+15.0) | 创建时间 | datetime | 8 | True | |
| id (T+15.0) | 主键 | int | 4 | False | |
| CumTaxPaid (T+15.0) | 累计实际已缴纳个税 | decimal | 13 | True | |
| CumIncidence (T+15.0) | 累计子女教育支出 | decimal | 13 | True | |
| Ts (T+15.0) | 分布时间戳 | timestamp | 8 | False | |
| CumOtherLegalDeduction1 (T+15.0) | 累计其他合法扣除1 | decimal | 13 | True | |
| CumHouseRentExpense (T+15.0) | 累计住房租金支出 | decimal | 13 | True | |
| code (T+15.0) | 编号 | nvarchar | 60 | True | |
| iddepartment (T+15.0) | 部门ID | int | 4 | True | |
| CumHouseLoanInterest (T+15.0) | 累计住房贷款利息支出 | decimal | 13 | True | |
| CumOtherLegalDeduction3 (T+15.0) | 累计其他合法扣除3 | decimal | 13 | True | |
| CumChildEducationExpense (T+15.0) | 累计子女教育支出 | decimal | 13 | True | |
| CumOtherLegalDeduction2 (T+15.0) | 累计其他合法扣除2 | decimal | 13 | True | |
| idperson (T+15.0) | 职员ID | int | 4 | True | |
| IdInitialWageHead (T+15.0) | 主表ID | int | 4 | True | |
| CumOtherLegalDeduction4 (T+15.0) | 累计其他合法扣除4 | decimal | 13 | True | |
| Updated (T+15.0) | 更新时间 | datetime | 8 | True | |
| CumDeduction (T+15.0) | 累计应扣合计 | decimal | 13 | True | |
| CumOtherLegalDeduction5 (T+15.0) | 累计其他合法扣除5 | decimal | 13 | True | |
| Memo (T+15.0) | 备注 | varchar | 500 | True | |
| CumIncidenceBeforeTax (T+15.0) | 累计税前应发合计 | decimal | 13 | True | |
| CumContinueEducationExpense (T+15.0) | 累计继续教育支出 | decimal | 13 | True | |
| CumTaxThreshold (T+15.0) | 累计起征点合计 | decimal | 13 | True | |
| CumElderMaintenanceExpense (T+15.0) | 累计赡养老人支出 | decimal | 13 | True |
Copyright 2016 Chanjet Inc.