tbm_leaveb - 2.11休假申请单/登记表子表
字段列表
| 编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | | pk_leave_b | 休假单子表主键 | CHAR | Y | 20 | 0 | | | | |
| backdate | 销假日期 | CHAR | | 10 | 0 | | | | |
| backtime | 销假时间 | CHAR | | 8 | 0 | | | | |
| dr | 删除标志dr | SMALLINT | | 2 | 0 | | | | |
| ifapprove | 是否批准 | CHAR | | 1 | 0 | | | | |
| leavebeginday | 休假开始日期 | CHAR | | 10 | 0 | | | | |
| leavebegintime | 休假开始时刻 | CHAR | | 8 | 0 | | | | |
| leavecycbegindate | 假别周期开始日期 | CHAR | | 10 | 0 | | | | |
| leaveendday | 休假结束日期 | CHAR | | 10 | 0 | | | | |
| leaveendtime | 休假结束时刻 | CHAR | | 8 | 0 | | | | |
| leavenote | 休假事由 | VARCHAR | | 512 | 0 | | | | |
| leaveoffstatus | 销假状态 | SMALLINT | | 2 | 0 | 2 | | | |
| leavepsnorder | 休假人员序号 | INT | | 4 | 0 | 0 | | | |
| leavesumhour | 休假合计工时 | DECIMAL | | 16 | 2 | 0 | | | |
| pk_agentpsn | 工作交接人 | CHAR | | 20 | 0 | | | | |
| pk_leave_h | 休假单主键 | CHAR | | 20 | 0 | | | | |
| pk_tbm_psndoc | 考勤档案主键 | CHAR | | 20 | 0 | | | | |
| planbeginday | 计划开始日期 | CHAR | | 10 | 0 | | | | |
| planbegintime | 计划开始时间 | CHAR | | 8 | 0 | | | | |
| planendday | 计划结束日期 | CHAR | | 10 | 0 | | | | |
| planendtime | 计划结束时间 | CHAR | | 10 | 0 | | | | |
| psncode | 人员编码 | CHAR | | 20 | 0 | | | | |
| realdayorhour | 享有天数/小时 | DECIMAL | | 16 | 2 | 0 | | | |
| relatetel | 假期联系电话 | VARCHAR | | 50 | 0 | | | | |
| remark | 备注 | VARCHAR | | 100 | 0 | | | | |
| restdayorhour | 结余天数/小时 | DECIMAL | | 16 | 2 | 0 | | | |
| resteddayorhour | 已休时间 | DECIMAL | | 16 | 2 | | | | |
| sumhour | 实际休假时长 | DECIMAL | | 16 | 2 | 0 | | | |
| ts | 时间戳 | CHAR | | 19 | 0 | | | | |
| workprocess | 工作交接情况 | VARCHAR | | 512 | 0 | | | | |
外键列表
索引列表