dm_missionbill_b - 任务单子表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | cmissionbill_bid | 任务单表体 | CHAR | Y | 20 | 0 | | | | |
cbdeptid | 用车部门 | CHAR | | 20 | 0 | | | | |
cdelivorgid | 运输组织主键 | CHAR | | 20 | 0 | | | | |
cloadaddrid | 装车地点 | CHAR | | 20 | 0 | | | | |
cmissionbill_hid | 任务单表头 | CHAR | | 20 | 0 | | | | |
crowno | 行号 | VARCHAR | | 20 | 0 | | | | |
cunloadaddrid | 卸车地点 | CHAR | | 20 | 0 | | | | |
dbindate | 到车日期 | CHAR | | 10 | 0 | | | | |
dboutdate | 出车日期 | CHAR | | 10 | 0 | | | | |
dbouttime | 出车时间 | CHAR | | 8 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
iloadsequence | 装车顺序号 | SMALLINT | | 2 | 0 | | | | |
nroutemile | 路线公里 | DECIMAL | | 20 | 8 | | | | |
pk_bdefdoc1 | 自定义项主键1 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc10 | 自定义项主键10 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc11 | 自定义项主键11 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc12 | 自定义项主键12 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc13 | 自定义项主键13 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc14 | 自定义项主键14 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc15 | 自定义项主键15 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc16 | 自定义项主键16 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc17 | 自定义项主键17 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc18 | 自定义项主键18 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc19 | 自定义项主键19 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc2 | 自定义项主键2 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc20 | 自定义项主键20 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc3 | 自定义项主键3 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc4 | 自定义项主键4 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc5 | 自定义项主键5 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc6 | 自定义项主键6 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc7 | 自定义项主键7 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc8 | 自定义项主键8 | CHAR | | 20 | 0 | | | | |
pk_bdefdoc9 | 自定义项主键9 | CHAR | | 20 | 0 | | | | |
pk_corp | 公司主键 | CHAR | | 4 | 0 | | | | |
tbintime | 到车时间 | CHAR | | 8 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
vbdef1 | 自定义项1 | VARCHAR | | 100 | 0 | | | | |
vbdef10 | 自定义项10 | VARCHAR | | 100 | 0 | | | | |
vbdef11 | 自定义项11 | VARCHAR | | 100 | 0 | | | | |
vbdef12 | 自定义项12 | VARCHAR | | 100 | 0 | | | | |
vbdef13 | 自定义项13 | VARCHAR | | 100 | 0 | | | | |
vbdef14 | 自定义项14 | VARCHAR | | 100 | 0 | | | | |
vbdef15 | 自定义项15 | VARCHAR | | 100 | 0 | | | | |
vbdef16 | 自定义项16 | VARCHAR | | 100 | 0 | | | | |
vbdef17 | 自定义项17 | VARCHAR | | 100 | 0 | | | | |
vbdef18 | 自定义项18 | VARCHAR | | 100 | 0 | | | | |
vbdef19 | 自定义项19 | VARCHAR | | 100 | 0 | | | | |
vbdef2 | 自定义项2 | VARCHAR | | 100 | 0 | | | | |
vbdef20 | 自定义项20 | VARCHAR | | 100 | 0 | | | | |
vbdef3 | 自定义项3 | VARCHAR | | 100 | 0 | | | | |
vbdef4 | 自定义项4 | VARCHAR | | 100 | 0 | | | | |
vbdef5 | 自定义项5 | VARCHAR | | 100 | 0 | | | | |
vbdef6 | 自定义项6 | VARCHAR | | 100 | 0 | | | | |
vbdef7 | 自定义项7 | VARCHAR | | 100 | 0 | | | | |
vbdef8 | 自定义项8 | VARCHAR | | 100 | 0 | | | | |
vbdef9 | 自定义项9 | VARCHAR | | 100 | 0 | | | | |
vbnote | 备注 | VARCHAR | | 181 | 0 | | | | |
外键列表
索引列表