ADW_INTERCOMPANY_HIERARC_HISTORY

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 INTERCOMPANY_HIE_HISTORY_SID BIGINT 8
2 INTERCOMPANY_HIERARCH_DIM_ID CHARACTER VARYING(150) 150
3 INTERCOMPANY_NAME CHARACTER VARYING(240) 240
4 INTERCOMPANY_NAME_CF CHARACTER(1) 1
5 INTERCOMPANY_LEVEL_01_NAME CHARACTER VARYING(240) 240
6 INTERCOMPANY_LEVEL_01_NAM_CF CHARACTER(1) 1
7 INTERCOMPANY_LEVEL_02_CODE CHARACTER VARYING(150) 150
8 INTERCOMPANY_LEVEL_02_COD_CF CHARACTER(1) 1
9 INTERCOMPANY_LEVEL_02_NAME CHARACTER VARYING(240) 240
10 INTERCOMPANY_LEVEL_02_NAM_CF CHARACTER(1) 1
11 INTERCOMPANY_LEVEL_03_CODE CHARACTER VARYING(150) 150
12 INTERCOMPANY_LEVEL_03_COD_CF CHARACTER(1) 1
13 INTERCOMPANY_LEVEL_03_NAME CHARACTER VARYING(240) 240
14 INTERCOMPANY_LEVEL_03_NAM_CF CHARACTER(1) 1
15 INTERCOMPANY_LEVEL_04_CODE CHARACTER VARYING(150) 150
16 INTERCOMPANY_LEVEL_04_COD_CF CHARACTER(1) 1
17 INTERCOMPANY_LEVEL_04_NAME CHARACTER VARYING(240) 240
18 INTERCOMPANY_LEVEL_04_NAM_CF CHARACTER(1) 1
19 INTERCOMPANY_LEVEL_05_CODE CHARACTER VARYING(150) 150
20 INTERCOMPANY_LEVEL_05_COD_CF CHARACTER(1) 1
21 INTERCOMPANY_LEVEL_05_NAME CHARACTER VARYING(240) 240
22 INTERCOMPANY_LEVEL_05_NAM_CF CHARACTER(1) 1
23 INTERCOMPANY_LEVEL_06_CODE CHARACTER VARYING(150) 150
24 INTERCOMPANY_LEVEL_06_COD_CF CHARACTER(1) 1
25 INTERCOMPANY_LEVEL_06_NAME CHARACTER VARYING(240) 240
26 INTERCOMPANY_LEVEL_06_NAM_CF CHARACTER(1) 1
27 INTERCOMPANY_LEVEL_07_CODE CHARACTER VARYING(150) 150
28 INTERCOMPANY_LEVEL_07_COD_CF CHARACTER(1) 1
29 INTERCOMPANY_LEVEL_07_NAME CHARACTER VARYING(240) 240
30 INTERCOMPANY_LEVEL_07_NAM_CF CHARACTER(1) 1
31 INTERCOMPANY_LEVEL_08_CODE CHARACTER VARYING(150) 150
32 INTERCOMPANY_LEVEL_08_COD_CF CHARACTER(1) 1
33 INTERCOMPANY_LEVEL_08_NAME CHARACTER VARYING(240) 240
34 INTERCOMPANY_LEVEL_08_NAM_CF CHARACTER(1) 1
35 INTERCOMPANY_LEVEL_09_CODE CHARACTER VARYING(150) 150
36 INTERCOMPANY_LEVEL_09_COD_CF CHARACTER(1) 1
37 INTERCOMPANY_LEVEL_09_NAME CHARACTER VARYING(240) 240
38 INTERCOMPANY_LEVEL_09_NAM_CF CHARACTER(1) 1
39 INTERCOMPANY_LEVEL_10_CODE CHARACTER VARYING(150) 150
40 INTERCOMPANY_LEVEL_10_COD_CF CHARACTER(1) 1
41 INTERCOMPANY_LEVEL_10_NAME CHARACTER VARYING(240) 240
42 INTERCOMPANY_LEVEL_10_NAM_CF CHARACTER(1) 1
43 INTERCOMPANY_LEVEL_11_CODE CHARACTER VARYING(150) 150
44 INTERCOMPANY_LEVEL_11_COD_CF CHARACTER(1) 1
45 INTERCOMPANY_LEVEL_11_NAME CHARACTER VARYING(240) 240
46 INTERCOMPANY_LEVEL_11_NAM_CF CHARACTER(1) 1
47 INTERCOMPANY_LEVEL_12_CODE CHARACTER VARYING(150) 150
48 INTERCOMPANY_LEVEL_12_COD_CF CHARACTER(1) 1
49 INTERCOMPANY_LEVEL_12_NAME CHARACTER VARYING(240) 240
50 INTERCOMPANY_LEVEL_12_NAM_CF CHARACTER(1) 1
51 INTERCOMPANY_LEVEL_13_CODE CHARACTER VARYING(150) 150
52 INTERCOMPANY_LEVEL_13_COD_CF CHARACTER(1) 1
53 INTERCOMPANY_LEVEL_13_NAME CHARACTER VARYING(240) 240
54 INTERCOMPANY_LEVEL_13_NAM_CF CHARACTER(1) 1
55 INTERCOMPANY_LEVEL_14_CODE CHARACTER VARYING(150) 150
56 INTERCOMPANY_LEVEL_14_COD_CF CHARACTER(1) 1
57 INTERCOMPANY_LEVEL_14_NAME CHARACTER VARYING(240) 240
58 INTERCOMPANY_LEVEL_14_NAM_CF CHARACTER(1) 1
59 INTERCOMPANY_LEVEL_15_CODE CHARACTER VARYING(150) 150
60 INTERCOMPANY_LEVEL_15_COD_CF CHARACTER(1) 1
61 INTERCOMPANY_LEVEL_15_NAME CHARACTER VARYING(240) 240
62 INTERCOMPANY_LEVEL_15_NAM_CF CHARACTER(1) 1
63 EFFECTIVE_DATE TIMESTAMP 8
64 VALID_TO_DATE TIMESTAMP 8
65 CREATED_DATE TIMESTAMP 8
66 CHANGED_DATE TIMESTAMP 8
67 INTERCOMPANY_HIERARCHY_SID BIGINT 8