WFM_PROINS 流程实例返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | BILLITEM | VARCHAR2 | 50 | | | | √ | | 附件billitem |
2 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
3 | ENDDATE | CHAR | 19 | | | | √ | | 结束时间 |
4 | EXT0 | VARCHAR2 | 50 | | | | √ | | 扩展属性0 |
5 | EXT1 | VARCHAR2 | 50 | | | | √ | | 扩展属性1 |
6 | EXT2 | VARCHAR2 | 50 | | | | √ | | 扩展属性2 |
7 | EXT3 | VARCHAR2 | 50 | | | | √ | | 扩展属性3 |
8 | EXT4 | VARCHAR2 | 50 | | | | √ | | 扩展属性4 |
9 | EXT5 | VARCHAR2 | 50 | | | | √ | | 扩展属性5 |
10 | EXT6 | VARCHAR2 | 50 | | | | √ | | 扩展属性6 |
11 | EXT7 | VARCHAR2 | 50 | | | | √ | | 扩展属性7 |
12 | EXT8 | VARCHAR2 | 50 | | | | √ | | 扩展属性8 |
13 | EXT9 | VARCHAR2 | 50 | | | | √ | | 扩展属性9 |
14 | FINISHDATE | CHAR | 19 | | | | √ | | 完成时间 |
15 | PK_GROUP | VARCHAR2 | 20 | | | | √ | | 发起集团 |
16 | PK_ORG | VARCHAR2 | 20 | | | | √ | | 发起组织 |
17 | PK_PARENT | VARCHAR2 | 20 | | | | √ | | 父流程实例主键(内部) |
18 | PK_PPROINS | VARCHAR2 | 20 | | | | √ | | 父流程实例主键(外部) |
19 | PK_PRODEF | VARCHAR2 | 20 | | | | √ | | 流程定义主键 |
20 | PK_PROINS | CHAR | 20 | | √ | | | | 实例主键 |
21 | PK_ROOTPROINS | VARCHAR2 | 20 | | | | √ | | 根流程实例 |
22 | PK_STARTER | VARCHAR2 | 20 | | | | √ | '~' | 流程启动者 |
23 | PK_STARTFRMINS | VARCHAR2 | 20 | | | | √ | | 启动单据主键 |
24 | PK_STARTTASK | VARCHAR2 | 20 | | | | √ | | 发起子流程的任务主键 |
25 | PRODEF_ID | VARCHAR2 | 50 | | | | √ | | 流程定义编码 |
26 | STARTDATE | CHAR | 19 | | | | √ | | 启动时间 |
27 | STATE | VARCHAR2 | 50 | | | | √ | | 流程状态 |
28 | SYSEXT0 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性0 |
29 | SYSEXT1 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性1 |
30 | SYSEXT2 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性2 |
31 | SYSEXT3 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性3 |
32 | SYSEXT4 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性4 |
33 | SYSEXT5 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性5 |
34 | SYSEXT6 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性6 |
35 | SYSEXT7 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性7 |
36 | SYSEXT8 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性8 |
37 | SYSEXT9 | VARCHAR2 | 50 | | | | √ | | 系统扩展属性9 |
38 | TITLE | VARCHAR2 | 200 | | | | √ | | 流程标题 |
39 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
|