TB_ADJUSTBILL_B 预算调整单子表返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | ADJUSTDATA | NUMBER | 31 | 8 | | | √ | | 调整数据 |
2 | ADJUSTDATA2 | VARCHAR2 | 128 | | | | √ | | 调整值 |
3 | ADJUSTNOTE | VARCHAR2 | 500 | | | | √ | | 调整意见 |
4 | AREAID | VARCHAR2 | 50 | | | | √ | | 区域信息 |
5 | CELLPOSITION | VARCHAR2 | 50 | | | | √ | | 单元格位置 |
6 | DATA_AFTER | NUMBER | 31 | 8 | | | √ | | 调整后数据 |
7 | DATA_AFTER2 | VARCHAR2 | 128 | | | | √ | | 调整后值 |
8 | DATA_BEFORE | NUMBER | 31 | 8 | | | √ | | 调整前数据 |
9 | DATA_BEFORE2 | VARCHAR2 | 128 | | | | √ | | 调整前值 |
10 | DEF1 | VARCHAR2 | 101 | | | | √ | | 自定义项1 |
11 | DEF10 | VARCHAR2 | 101 | | | | √ | | 自定义项10 |
12 | DEF2 | VARCHAR2 | 101 | | | | √ | | 自定义项2 |
13 | DEF3 | VARCHAR2 | 101 | | | | √ | | 自定义项3 |
14 | DEF4 | VARCHAR2 | 101 | | | | √ | | 自定义项4 |
15 | DEF5 | VARCHAR2 | 101 | | | | √ | | 自定义项5 |
16 | DEF6 | VARCHAR2 | 101 | | | | √ | | 自定义项6 |
17 | DEF7 | VARCHAR2 | 101 | | | | √ | | 自定义项7 |
18 | DEF8 | VARCHAR2 | 101 | | | | √ | | 自定义项8 |
19 | DEF9 | VARCHAR2 | 101 | | | | √ | | 自定义项9 |
20 | DIM1 | VARCHAR2 | 20 | | | | √ | | 动态维度1 |
21 | DIM10 | VARCHAR2 | 20 | | | | √ | | 动态维度10 |
22 | DIM11 | VARCHAR2 | 20 | | | | √ | | 动态维度11 |
23 | DIM12 | VARCHAR2 | 20 | | | | √ | | 动态维度12 |
24 | DIM13 | VARCHAR2 | 20 | | | | √ | | 动态维度13 |
25 | DIM14 | VARCHAR2 | 20 | | | | √ | | 动态维度14 |
26 | DIM15 | VARCHAR2 | 20 | | | | √ | | 动态维度15 |
27 | DIM16 | VARCHAR2 | 20 | | | | √ | | 动态维度16 |
28 | DIM17 | VARCHAR2 | 20 | | | | √ | | 动态维度17 |
29 | DIM18 | VARCHAR2 | 20 | | | | √ | | 动态维度18 |
30 | DIM19 | VARCHAR2 | 20 | | | | √ | | 动态维度19 |
31 | DIM2 | VARCHAR2 | 20 | | | | √ | | 动态维度2 |
32 | DIM20 | VARCHAR2 | 20 | | | | √ | | 动态维度20 |
33 | DIM3 | VARCHAR2 | 20 | | | | √ | | 动态维度3 |
34 | DIM4 | VARCHAR2 | 20 | | | | √ | | 动态维度4 |
35 | DIM5 | VARCHAR2 | 20 | | | | √ | | 动态维度5 |
36 | DIM6 | VARCHAR2 | 20 | | | | √ | | 动态维度6 |
37 | DIM7 | VARCHAR2 | 20 | | | | √ | | 动态维度7 |
38 | DIM8 | VARCHAR2 | 20 | | | | √ | | 动态维度8 |
39 | DIM9 | VARCHAR2 | 20 | | | | √ | | 动态维度9 |
40 | DIMOTHERS | BLOB | 4000 | | | | √ | | 动态其他维度 |
41 | DIMOTHERS_STR | VARCHAR2 | 1024 | | | | √ | | 动态其他维度字符 |
42 | DIMVECTOR | BLOB | 4000 | | | | √ | | 维度向量 |
43 | DIMVECTOR_STR | VARCHAR2 | 1024 | | | | √ | | 维度向量字符 |
44 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
45 | FREEVALUE1 | VARCHAR2 | 200 | | | | √ | | 预留项1 |
46 | OTHERS | BLOB | 4000 | | | | √ | | 其他维度 |
47 | OTHERS_STR | VARCHAR2 | 4000 | | | | √ | | 其他维度字符 |
48 | PARAMAP | BLOB | 4000 | | | | √ | | 参数 |
49 | PK_ADJUSTBILL | CHAR | 20 | | | | | | 预算调整单主表_主键 |
50 | PK_ADJUSTBILL_B | CHAR | 20 | | √ | | | | 调整单子表主键 |
51 | PK_CUBE | VARCHAR2 | 20 | | | | | | 应用模型 |
52 | PK_DATAENT | VARCHAR2 | 20 | | | | √ | | 责任主体 |
53 | PK_MEASURE | VARCHAR2 | 20 | | | | √ | | 指标参照 |
54 | PK_METRICS | VARCHAR2 | 500 | | | | √ | | 指标 |
55 | PK_SHEET | VARCHAR2 | 20 | | | | √ | | 表单 |
56 | PK_TASK | VARCHAR2 | 20 | | | | √ | | 任务 |
57 | PK_TASKDEF | VARCHAR2 | 20 | | | | √ | | 预算任务 |
58 | PK_TIME | VARCHAR2 | 200 | | | | √ | | 计划期间 |
59 | PK_WORKBOOK | VARCHAR2 | 20 | | | | √ | | 套表 |
60 | SHEETPARADIM | VARCHAR2 | 300 | | | | √ | | 页面维 |
61 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
62 | UNIQKEY | VARCHAR2 | 99 | | | | √ | | 单元格标识 |
|