PUB_WORKFLOWNOTE
工作项返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1ACTIONTYPEVARCHAR220      
2AGENCYUSERCHAR20     
3APPROVERESULTCHAR1    处理意见
4APPROVESTATUSNUMBER380   处理情况
5BILLIDVARCHAR220   '~' 
6BILLNOVARCHAR2256    单据编号
7BILLVERSIONPKVARCHAR220     
8CHECKMANVARCHAR220   '~'审批人
9CHECKNOTEVARCHAR21024    批语
10CIPHERTEXTVARCHAR21024     
11DEALDATECHAR19    处理时间
12DEALTIMEMILLISVARCHAR220     
13DRNUMBER100  0 
14ISCHECKCHAR1     
15ISMSGBINDCHAR1     
16MAILADDRESSVARCHAR250     
17MAINHEADVARCHAR2128     
18MESSAGENOTEVARCHAR21024    说明
19OBSERVERVARCHAR220   '~' 
20PK_BILLTYPEVARCHAR220     单据类型
21PK_CHECKFLOWCHAR20    工作项主键
22PK_GROUPVARCHAR220   '~' 
23PK_ORGVARCHAR220   '~'组织
24PK_WF_TASKCHAR20   '~' 
25PRIORITYNUMBER380    
26RECEIVEDELETEFLAGCHAR1     
27SENDDATECHAR19    发送时间
28SENDERMANVARCHAR220   '~'发送人
29TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 
30USEROBJECTVARCHAR2128     
31WORKFLOW_TYPENUMBER380