DIM_OEB_PSTREE_HIERARCHY_EXCEPTION_CFDM_INSIGHT

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 OF_CODE CHARACTER VARYING(150) 150
2 LEAF_NAME CHARACTER VARYING(240) 240
3 SM_LEAF_DESCR CHARACTER VARYING(240) 240
4 SM_LEAF_STATUS CHARACTER VARYING(1) 1
5 SM_TREE_SETID CHARACTER VARYING(2) 2
6 TREE_NAME CHARACTER VARYING(16) 16
7 TREE_EFFDT TIMESTAMP 8
8 LEVEL1_NAME CHARACTER VARYING(150) 150
9 SM_NODE_DECR1 CHARACTER VARYING(240) 240
10 SM_TREE_NODE_NUM1 INTEGER 4
11 LEVEL2_NAME CHARACTER VARYING(150) 150
12 SM_NODE_DECR2 CHARACTER VARYING(240) 240
13 SM_TREE_NODE_NUM2 INTEGER 4
14 LEVEL3_NAME CHARACTER VARYING(150) 150
15 SM_NODE_DECR3 CHARACTER VARYING(240) 240
16 SM_TREE_NODE_NUM3 INTEGER 4
17 LEVEL4_NAME CHARACTER VARYING(150) 150
18 SM_NODE_DECR4 CHARACTER VARYING(240) 240
19 SM_TREE_NODE_NUM4 INTEGER 4
20 LEVEL5_NAME CHARACTER VARYING(150) 150
21 SM_NODE_DECR5 CHARACTER VARYING(240) 240
22 SM_TREE_NODE_NUM5 INTEGER 4
23 LEVEL6_NAME CHARACTER VARYING(150) 150
24 SM_NODE_DECR6 CHARACTER VARYING(240) 240
25 SM_TREE_NODE_NUM6 INTEGER 4
26 LEVEL7_NAME CHARACTER VARYING(150) 150
27 SM_NODE_DECR7 CHARACTER VARYING(240) 240
28 SM_TREE_NODE_NUM7 INTEGER 4
29 LEVEL8_NAME CHARACTER VARYING(150) 150
30 SM_NODE_DECR8 CHARACTER VARYING(240) 240
31 SM_TREE_NODE_NUM8 INTEGER 4
32 LEVEL9_NAME CHARACTER VARYING(150) 150
33 SM_NODE_DECR9 CHARACTER VARYING(240) 240
34 SM_TREE_NODE_NUM9 INTEGER 4
35 LEVEL10_NAME CHARACTER VARYING(150) 150
36 SM_NODE_DECR10 CHARACTER VARYING(240) 240
37 SM_TREE_NODE_NUM10 INTEGER 4
38 LEVEL11_NAME CHARACTER VARYING(150) 150
39 SM_NODE_DECR11 CHARACTER VARYING(240) 240
40 SM_TREE_NODE_NUM11 INTEGER 4
41 LEVEL12_NAME CHARACTER VARYING(150) 150
42 SM_NODE_DECR12 CHARACTER VARYING(240) 240
43 SM_TREE_NODE_NUM12 INTEGER 4
44 LEVEL13_NAME CHARACTER VARYING(150) 150
45 SM_NODE_DECR13 CHARACTER VARYING(240) 240
46 SM_TREE_NODE_NUM13 INTEGER 4
47 LEVEL14_NAME CHARACTER VARYING(150) 150
48 SM_NODE_DECR14 CHARACTER VARYING(240) 240
49 SM_TREE_NODE_NUM14 INTEGER 4
50 LEVEL15_NAME CHARACTER VARYING(150) 150
51 SM_NODE_DECR15 CHARACTER VARYING(240) 240
52 SM_TREE_NODE_NUM15 INTEGER 4
53 TREE_LEVEL_NUM INTEGER 4
54 LEVEL_COUNT INTEGER 4
55 SM_TREE_STATUS CHARACTER VARYING(1) 1
56 TREE_STRCT_ID CHARACTER VARYING(11) 11