SSC_ALLOTRULE_B
任务分配规则明细返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1ADVANCECONSQLCLOB4000    高级条件(SQL)
2ADVANCECONXMLCLOB4000    高级条件(XML)
3ADVANCEDCONCLOB4000    高级条件
4CREATIONTIMECHAR19    创建时间
5CREATORVARCHAR220   '~'创建人
6DRNUMBER100  0 
7EXCLUSIONFORMULACLOB4000    回避人员公式
8FORMULACLOB4000    公式
9ISCONTAINSLOWERCHAR1    是否包含下级
10LADEFORMULACLOB4000    提取条件
11MODIFIEDTIMECHAR19    最后修改时间
12MODIFIERVARCHAR220   '~'最后修改人
13ORGNAMEVARCHAR220   '~'单据所属组织(界面显示用)
14PK_ALLOTRULEVARCHAR250    业务分配规则主键
15PK_ALLOTRULE_BCHAR20    主键
16PK_ORGCLOB4000    单据所属组织(PK保存用)
17PK_POST1VARCHAR220   '~'岗位1
18PK_POST10VARCHAR220   '~'岗位10
19PK_POST11VARCHAR220   '~'岗位11
20PK_POST12VARCHAR220   '~'岗位12
21PK_POST13VARCHAR220   '~'岗位13
22PK_POST14VARCHAR220   '~'岗位14
23PK_POST15VARCHAR220   '~'岗位15
24PK_POST16VARCHAR220   '~'岗位16
25PK_POST17VARCHAR220   '~'岗位17
26PK_POST18VARCHAR220   '~'岗位18
27PK_POST19VARCHAR220   '~'岗位19
28PK_POST2VARCHAR220   '~'岗位2
29PK_POST20VARCHAR220   '~'岗位20
30PK_POST3VARCHAR220   '~'岗位3
31PK_POST4VARCHAR220   '~'岗位4
32PK_POST5VARCHAR220   '~'岗位5
33PK_POST6VARCHAR220   '~'岗位6
34PK_POST7VARCHAR220   '~'岗位7
35PK_POST8VARCHAR220   '~'岗位8
36PK_POST9VARCHAR220   '~'岗位9
37SERIALNUMNUMBER380   序号
38TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')