TB_EPM_RULE 合并规则返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ADJUST_DATATYPE | VARCHAR2 | 10 | | | | √ | | adjust_datatype |
2 | ADJUST_ENDENTITY | VARCHAR2 | 20 | | | | √ | | adjust_endentity |
3 | ADJUST_FIRSTENTITY | VARCHAR2 | 20 | | | | √ | | adjust_firstentity |
4 | ADJUST_MAXBALANCE | NUMBER | 33 | 8 | | | √ | | adjust_maxbalance |
5 | ADJUST_TYPE | VARCHAR2 | 30 | | | | √ | | adjust_type |
6 | ADJUSTTYPE | VARCHAR2 | 30 | | | | √ | | adjusttype |
7 | CREATEDBY | VARCHAR2 | 20 | | | | √ | | createdby |
8 | CREATEDDATE | CHAR | 19 | | | | √ | | createddate |
9 | DATATYPE | VARCHAR2 | 10 | | | | √ | | datatype |
10 | DEF1 | VARCHAR2 | 100 | | | | √ | | def1 |
11 | DEF2 | VARCHAR2 | 100 | | | | √ | | def2 |
12 | DEF3 | VARCHAR2 | 100 | | | | √ | | def3 |
13 | DEF4 | VARCHAR2 | 100 | | | | √ | | def4 |
14 | DEF5 | VARCHAR2 | 100 | | | | √ | | def5 |
15 | DESCRIPT | VARCHAR2 | 500 | | | | √ | | 描述 |
16 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
17 | GROUPDIM | VARCHAR2 | 400 | | | | √ | | 分组维度 |
18 | ISCTLINVEST | CHAR | 1 | | | | √ | | 控制投资 |
19 | ISEQUALSCOUNTEVAIL | CHAR | 1 | | | | √ | | isequalscountevail |
20 | ISSCRIPTEDIT | CHAR | 1 | | | | √ | | |
21 | ISSINGLEVOUCH | CHAR | 1 | | | | √ | | issinglevouch |
22 | MEET_DATATYPE | VARCHAR2 | 10 | | | | √ | | meet_datatype |
23 | MEET_ENDENTITY | VARCHAR2 | 20 | | | | √ | | meet_endentity |
24 | MEET_FIRSTENTITY | VARCHAR2 | 20 | | | | √ | | meet_firstentity |
25 | MEET_MAXBALANCE | NUMBER | 33 | 8 | | | √ | | meet_maxbalance |
26 | MEET_TYPE | VARCHAR2 | 10 | | | | √ | | meet_type |
27 | MODIFIEDBY | VARCHAR2 | 20 | | | | √ | | modifiedby |
28 | MODIFIEDDATE | CHAR | 19 | | | | √ | | modifieddate |
29 | OBJCODE | VARCHAR2 | 50 | | | | √ | | objcode |
30 | OBJNAME | VARCHAR2 | 100 | | | | | | objname |
31 | OBJNAME2 | VARCHAR2 | 100 | | | | √ | | objname2 |
32 | OBJNAME3 | VARCHAR2 | 100 | | | | √ | | objname3 |
33 | OBJNAME4 | VARCHAR2 | 100 | | | | √ | | objname4 |
34 | OBJNAME5 | VARCHAR2 | 100 | | | | √ | | objname5 |
35 | OBJNAME6 | VARCHAR2 | 100 | | | | √ | | objname6 |
36 | PK_CUBE | VARCHAR2 | 20 | | | | √ | | 应用模型 |
37 | PK_GROUP | VARCHAR2 | 20 | | | | √ | | pk_group |
38 | PK_MEETRULE | VARCHAR2 | 20 | | | | √ | | pk_meetrule |
39 | PK_OBJ | CHAR | 20 | | √ | | | | pk_obj |
40 | PK_ORG | VARCHAR2 | 20 | | | | | | pk_org |
41 | RULETYPE | VARCHAR2 | 20 | | | | | | 规则类型 |
42 | SYSCODE | VARCHAR2 | 10 | | | | √ | | 创建系统 |
43 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
|