LFW_ZDYDJ_B 自定义单据表体返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | AMOUNT | NUMBER | 28 | 8 | | | √ | | null |
2 | CODE | VARCHAR2 | 50 | | | | √ | | null |
3 | CREATIONTIME | VARCHAR2 | 19 | | | | √ | | null |
4 | CREATOR | VARCHAR2 | 20 | | | | √ | | null |
5 | DEF0 | VARCHAR2 | 500 | | | | √ | | null |
6 | DEF1 | VARCHAR2 | 500 | | | | √ | | null |
7 | DEF10 | VARCHAR2 | 500 | | | | √ | | null |
8 | DEF11 | VARCHAR2 | 500 | | | | √ | | null |
9 | DEF12 | VARCHAR2 | 500 | | | | √ | | null |
10 | DEF13 | VARCHAR2 | 500 | | | | √ | | null |
11 | DEF14 | VARCHAR2 | 500 | | | | √ | | null |
12 | DEF15 | VARCHAR2 | 500 | | | | √ | | null |
13 | DEF16 | VARCHAR2 | 500 | | | | √ | | null |
14 | DEF17 | VARCHAR2 | 500 | | | | √ | | null |
15 | DEF18 | VARCHAR2 | 500 | | | | √ | | null |
16 | DEF19 | VARCHAR2 | 500 | | | | √ | | null |
17 | DEF2 | VARCHAR2 | 500 | | | | √ | | null |
18 | DEF20 | VARCHAR2 | 500 | | | | √ | | null |
19 | DEF21 | VARCHAR2 | 500 | | | | √ | | null |
20 | DEF22 | VARCHAR2 | 500 | | | | √ | | null |
21 | DEF23 | VARCHAR2 | 500 | | | | √ | | null |
22 | DEF24 | VARCHAR2 | 500 | | | | √ | | null |
23 | DEF25 | VARCHAR2 | 500 | | | | √ | | null |
24 | DEF26 | VARCHAR2 | 500 | | | | √ | | null |
25 | DEF27 | VARCHAR2 | 500 | | | | √ | | null |
26 | DEF28 | VARCHAR2 | 500 | | | | √ | | null |
27 | DEF29 | VARCHAR2 | 500 | | | | √ | | null |
28 | DEF3 | VARCHAR2 | 500 | | | | √ | | null |
29 | DEF30 | VARCHAR2 | 500 | | | | √ | | null |
30 | DEF31 | VARCHAR2 | 500 | | | | √ | | null |
31 | DEF32 | VARCHAR2 | 500 | | | | √ | | null |
32 | DEF33 | VARCHAR2 | 500 | | | | √ | | null |
33 | DEF34 | VARCHAR2 | 500 | | | | √ | | null |
34 | DEF35 | VARCHAR2 | 500 | | | | √ | | null |
35 | DEF36 | VARCHAR2 | 500 | | | | √ | | null |
36 | DEF37 | VARCHAR2 | 500 | | | | √ | | null |
37 | DEF38 | VARCHAR2 | 500 | | | | √ | | null |
38 | DEF39 | VARCHAR2 | 500 | | | | √ | | null |
39 | DEF4 | VARCHAR2 | 500 | | | | √ | | null |
40 | DEF40 | VARCHAR2 | 500 | | | | √ | | null |
41 | DEF41 | VARCHAR2 | 500 | | | | √ | | null |
42 | DEF42 | VARCHAR2 | 500 | | | | √ | | null |
43 | DEF43 | VARCHAR2 | 500 | | | | √ | | null |
44 | DEF44 | VARCHAR2 | 500 | | | | √ | | null |
45 | DEF45 | VARCHAR2 | 500 | | | | √ | | null |
46 | DEF46 | VARCHAR2 | 500 | | | | √ | | null |
47 | DEF47 | VARCHAR2 | 500 | | | | √ | | null |
48 | DEF48 | VARCHAR2 | 500 | | | | √ | | null |
49 | DEF49 | VARCHAR2 | 500 | | | | √ | | null |
50 | DEF5 | VARCHAR2 | 500 | | | | √ | | null |
51 | DEF50 | VARCHAR2 | 500 | | | | √ | | null |
52 | DEF51 | VARCHAR2 | 500 | | | | √ | | null |
53 | DEF52 | VARCHAR2 | 500 | | | | √ | | null |
54 | DEF53 | VARCHAR2 | 500 | | | | √ | | null |
55 | DEF54 | VARCHAR2 | 500 | | | | √ | | null |
56 | DEF55 | VARCHAR2 | 500 | | | | √ | | null |
57 | DEF56 | VARCHAR2 | 500 | | | | √ | | null |
58 | DEF57 | VARCHAR2 | 500 | | | | √ | | null |
59 | DEF58 | VARCHAR2 | 500 | | | | √ | | null |
60 | DEF59 | VARCHAR2 | 500 | | | | √ | | null |
61 | DEF6 | VARCHAR2 | 500 | | | | √ | | null |
62 | DEF60 | VARCHAR2 | 500 | | | | √ | | null |
63 | DEF61 | VARCHAR2 | 500 | | | | √ | | null |
64 | DEF62 | VARCHAR2 | 500 | | | | √ | | null |
65 | DEF63 | VARCHAR2 | 500 | | | | √ | | null |
66 | DEF64 | VARCHAR2 | 500 | | | | √ | | null |
67 | DEF65 | VARCHAR2 | 500 | | | | √ | | null |
68 | DEF66 | VARCHAR2 | 500 | | | | √ | | null |
69 | DEF67 | VARCHAR2 | 500 | | | | √ | | null |
70 | DEF68 | VARCHAR2 | 500 | | | | √ | | null |
71 | DEF69 | VARCHAR2 | 500 | | | | √ | | null |
72 | DEF7 | VARCHAR2 | 500 | | | | √ | | null |
73 | DEF70 | VARCHAR2 | 500 | | | | √ | | null |
74 | DEF71 | VARCHAR2 | 500 | | | | √ | | null |
75 | DEF72 | VARCHAR2 | 500 | | | | √ | | null |
76 | DEF73 | VARCHAR2 | 500 | | | | √ | | null |
77 | DEF74 | VARCHAR2 | 500 | | | | √ | | null |
78 | DEF75 | VARCHAR2 | 500 | | | | √ | | null |
79 | DEF76 | VARCHAR2 | 500 | | | | √ | | null |
80 | DEF77 | VARCHAR2 | 500 | | | | √ | | null |
81 | DEF78 | VARCHAR2 | 500 | | | | √ | | null |
82 | DEF79 | VARCHAR2 | 500 | | | | √ | | null |
83 | DEF8 | VARCHAR2 | 500 | | | | √ | | null |
84 | DEF9 | VARCHAR2 | 500 | | | | √ | | null |
85 | DEPT | VARCHAR2 | 20 | | | | √ | | null |
86 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
87 | MODIFIEDTIME | VARCHAR2 | 19 | | | | √ | | null |
88 | MODIFIER | VARCHAR2 | 20 | | | | √ | | null |
89 | NAME | VARCHAR2 | 50 | | | | √ | | null |
90 | NAME2 | VARCHAR2 | 50 | | | | √ | | |
91 | NAME3 | VARCHAR2 | 50 | | | | √ | | |
92 | NAME4 | VARCHAR2 | 50 | | | | √ | | |
93 | NAME5 | VARCHAR2 | 50 | | | | √ | | |
94 | NAME6 | VARCHAR2 | 50 | | | | √ | | |
95 | PK_DOC | VARCHAR2 | 20 | | | | √ | | null |
96 | PK_GROUP | VARCHAR2 | 20 | | | | √ | | null |
97 | PK_ORG | VARCHAR2 | 20 | | | | √ | | null |
98 | PK_SUBTABLE | CHAR | 20 | | √ | | | | null |
99 | PSNDOC | VARCHAR2 | 20 | | | | √ | | null |
100 | RELATIONID | VARCHAR2 | 50 | | | | √ | | null |
101 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
|