DIM_FIN_MASTER_ACTIVITY_CENTRE

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 FLEX_VALUE_SET_ID BIGINT 8
2 LOB CHARACTER VARYING(16) 16
3 LEVEL_01_CODE CHARACTER VARYING(150) 150
4 LEVEL_01_NAME CHARACTER VARYING(240) 240
5 LEVEL_01_TYPE CHARACTER VARYING(1) 1
6 LEVEL_01_CHILD_TYPE CHARACTER VARYING(240) 240
7 LEVEL_02_CODE CHARACTER VARYING(150) 150
8 LEVEL_02_NAME CHARACTER VARYING(240) 240
9 LEVEL_02_TYPE CHARACTER VARYING(1) 1
10 LEVEL_02_CHILD_TYPE CHARACTER VARYING(240) 240
11 LEVEL_03_CODE CHARACTER VARYING(150) 150
12 LEVEL_03_NAME CHARACTER VARYING(240) 240
13 LEVEL_03_TYPE CHARACTER VARYING(1) 1
14 LEVEL_03_CHILD_TYPE CHARACTER VARYING(240) 240
15 LEVEL_04_CODE CHARACTER VARYING(150) 150
16 LEVEL_04_NAME CHARACTER VARYING(240) 240
17 LEVEL_04_TYPE CHARACTER VARYING(1) 1
18 LEVEL_04_CHILD_TYPE CHARACTER VARYING(240) 240
19 LEVEL_05_CODE CHARACTER VARYING(150) 150
20 LEVEL_05_NAME CHARACTER VARYING(240) 240
21 LEVEL_05_TYPE CHARACTER VARYING(1) 1
22 LEVEL_05_CHILD_TYPE CHARACTER VARYING(240) 240
23 LEVEL_06_CODE CHARACTER VARYING(150) 150
24 LEVEL_06_NAME CHARACTER VARYING(240) 240
25 LEVEL_06_TYPE CHARACTER VARYING(1) 1
26 LEVEL_06_CHILD_TYPE CHARACTER VARYING(240) 240
27 LEVEL_07_CODE CHARACTER VARYING(150) 150
28 LEVEL_07_NAME CHARACTER VARYING(240) 240
29 LEVEL_07_TYPE CHARACTER VARYING(1) 1
30 LEVEL_07_CHILD_TYPE CHARACTER VARYING(240) 240
31 LEVEL_08_CODE CHARACTER VARYING(150) 150
32 LEVEL_08_NAME CHARACTER VARYING(240) 240
33 LEVEL_08_TYPE CHARACTER VARYING(1) 1
34 LEVEL_08_CHILD_TYPE CHARACTER VARYING(240) 240
35 LEVEL_09_CODE CHARACTER VARYING(150) 150
36 LEVEL_09_NAME CHARACTER VARYING(240) 240
37 LEVEL_09_TYPE CHARACTER VARYING(1) 1
38 LEVEL_09_CHILD_TYPE CHARACTER VARYING(240) 240
39 LEVEL_10_CODE CHARACTER VARYING(150) 150
40 LEVEL_10_NAME CHARACTER VARYING(240) 240
41 LEVEL_10_TYPE CHARACTER VARYING(1) 1
42 LEVEL_10_CHILD_TYPE CHARACTER VARYING(240) 240
43 LEVEL_11_CODE CHARACTER VARYING(150) 150
44 LEVEL_11_NAME CHARACTER VARYING(240) 240
45 LEVEL_11_TYPE CHARACTER VARYING(1) 1
46 LEVEL_11_CHILD_TYPE CHARACTER VARYING(240) 240
47 LEVEL_12_CODE CHARACTER VARYING(150) 150
48 LEVEL_12_NAME CHARACTER VARYING(240) 240
49 LEVEL_12_TYPE CHARACTER VARYING(1) 1
50 LEVEL_12_CHILD_TYPE CHARACTER VARYING(240) 240
51 LEVEL_13_CODE CHARACTER VARYING(150) 150
52 LEVEL_13_NAME CHARACTER VARYING(240) 240
53 LEVEL_13_TYPE CHARACTER VARYING(1) 1
54 LEVEL_13_CHILD_TYPE CHARACTER VARYING(240) 240
55 LEVEL_14_CODE CHARACTER VARYING(150) 150
56 LEVEL_14_NAME CHARACTER VARYING(240) 240
57 LEVEL_14_TYPE CHARACTER VARYING(1) 1
58 LEVEL_14_CHILD_TYPE CHARACTER VARYING(240) 240
59 LEVEL_15_CODE CHARACTER VARYING(150) 150
60 LEVEL_15_NAME CHARACTER VARYING(240) 240
61 LEVEL_15_TYPE CHARACTER VARYING(1) 1
62 LEVEL_15_CHILD_TYPE CHARACTER VARYING(240) 240
63 LEVEL_16_CODE CHARACTER VARYING(150) 150
64 LEVEL_16_NAME CHARACTER VARYING(240) 240
65 LEVEL_16_TYPE CHARACTER VARYING(1) 1
66 LEVEL_16_CHILD_TYPE CHARACTER VARYING(240) 240
67 LEVEL_17_CODE CHARACTER VARYING(150) 150
68 LEVEL_17_NAME CHARACTER VARYING(240) 240
69 LEVEL_17_TYPE CHARACTER VARYING(1) 1
70 LEVEL_17_CHILD_TYPE CHARACTER VARYING(240) 240
71 LEVEL_18_CODE CHARACTER VARYING(150) 150
72 LEVEL_18_NAME CHARACTER VARYING(240) 240
73 LEVEL_18_TYPE CHARACTER VARYING(1) 1
74 LEVEL_18_CHILD_TYPE CHARACTER VARYING(240) 240
75 LEVEL_19_CODE CHARACTER VARYING(150) 150
76 LEVEL_19_NAME CHARACTER VARYING(240) 240
77 LEVEL_19_TYPE CHARACTER VARYING(1) 1
78 LEVEL_19_CHILD_TYPE CHARACTER VARYING(240) 240
79 LEVEL_20_CODE CHARACTER VARYING(150) 150
80 LEVEL_20_NAME CHARACTER VARYING(240) 240
81 LEVEL_20_TYPE CHARACTER VARYING(1) 1
82 LEVEL_20_CHILD_TYPE CHARACTER VARYING(240) 240