ER_REIMRULE 返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | AMOUNT | NUMBER | 28 | 8 | | | √ | | |
2 | DEF1 | CHAR | 20 | | | | √ | | |
3 | DEF10 | CHAR | 20 | | | | √ | | |
4 | DEF10_NAME | VARCHAR2 | 100 | | | | √ | | |
5 | DEF1_NAME | VARCHAR2 | 100 | | | | √ | | |
6 | DEF2 | CHAR | 20 | | | | √ | | |
7 | DEF2_NAME | VARCHAR2 | 100 | | | | √ | | |
8 | DEF3 | CHAR | 20 | | | | √ | | |
9 | DEF3_NAME | VARCHAR2 | 100 | | | | √ | | |
10 | DEF4 | CHAR | 20 | | | | √ | | |
11 | DEF4_NAME | VARCHAR2 | 100 | | | | √ | | |
12 | DEF5 | CHAR | 20 | | | | √ | | |
13 | DEF5_NAME | VARCHAR2 | 100 | | | | √ | | |
14 | DEF6 | CHAR | 20 | | | | √ | | |
15 | DEF6_NAME | VARCHAR2 | 100 | | | | √ | | |
16 | DEF7 | CHAR | 20 | | | | √ | | |
17 | DEF7_NAME | VARCHAR2 | 100 | | | | √ | | |
18 | DEF8 | CHAR | 20 | | | | √ | | |
19 | DEF8_NAME | VARCHAR2 | 100 | | | | √ | | |
20 | DEF9 | CHAR | 20 | | | | √ | | |
21 | DEF9_NAME | VARCHAR2 | 100 | | | | √ | | |
22 | DEFFORMULA | VARCHAR2 | 1024 | | | | √ | | |
23 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
24 | MEMO | VARCHAR2 | 300 | | | | √ | | |
25 | PK_BILLTYPE | VARCHAR2 | 20 | | | | √ | | |
26 | PK_CORP | CHAR | 20 | | | | √ | | |
27 | PK_CURRTYPE | CHAR | 20 | | | | √ | | |
28 | PK_DEPTID | CHAR | 20 | | | | √ | | |
29 | PK_EXPENSETYPE | CHAR | 20 | | | | √ | | |
30 | PK_GROUP | CHAR | 20 | | | | √ | | |
31 | PK_ORG | CHAR | 20 | | | | √ | | |
32 | PK_PSN | CHAR | 20 | | | | √ | | |
33 | PK_REIMRULE | CHAR | 20 | | √ | | | | |
34 | PK_REIMTYPE | CHAR | 20 | | | | √ | | |
35 | PRIORITY | NUMBER | 38 | 0 | | | √ | | |
36 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
37 | VALIDATEFORMULA | VARCHAR2 | 256 | | | | √ | | |
|