DIM_GL_COST_CENTRE_HIERARCHY_HISTORY_BDW

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_DIM_GL_COST_CENTRE_HIERARCHY_HISTORY_BDW

Columns
# Name Data Type Length
1 COST_CENTRE_HIERARCHY_HISTORY_SID BIGINT 8
2 COST_CENTRE_HIERARCHY_DIM_ID CHARACTER VARYING(301) 301
4 COST_CENTRE_NAME_CF CHARACTER VARYING(1) 1
6 COST_CENTRE_LEVEL_01_NAME_CF CHARACTER VARYING(1) 1
8 COST_CENTRE_LEVEL_02_CODE_CF CHARACTER VARYING(1) 1
10 COST_CENTRE_LEVEL_02_NAME_CF CHARACTER VARYING(1) 1
12 COST_CENTRE_LEVEL_03_CODE_CF CHARACTER VARYING(1) 1
14 COST_CENTRE_LEVEL_03_NAME_CF CHARACTER VARYING(1) 1
16 COST_CENTRE_LEVEL_04_CODE_CF CHARACTER VARYING(1) 1
18 COST_CENTRE_LEVEL_04_NAME_CF CHARACTER VARYING(1) 1
20 COST_CENTRE_LEVEL_05_CODE_CF CHARACTER VARYING(1) 1
22 COST_CENTRE_LEVEL_05_NAME_CF CHARACTER VARYING(1) 1
24 COST_CENTRE_LEVEL_06_CODE_CF CHARACTER VARYING(1) 1
26 COST_CENTRE_LEVEL_06_NAME_CF CHARACTER VARYING(1) 1
28 COST_CENTRE_LEVEL_07_CODE_CF CHARACTER VARYING(1) 1
30 COST_CENTRE_LEVEL_07_NAME_CF CHARACTER VARYING(1) 1
32 COST_CENTRE_LEVEL_08_CODE_CF CHARACTER VARYING(1) 1
34 COST_CENTRE_LEVEL_08_NAME_CF CHARACTER VARYING(1) 1
36 COST_CENTRE_LEVEL_09_CODE_CF CHARACTER VARYING(1) 1
38 COST_CENTRE_LEVEL_09_NAME_CF CHARACTER VARYING(1) 1
40 COST_CENTRE_LEVEL_10_CODE_CF CHARACTER VARYING(1) 1
42 COST_CENTRE_LEVEL_10_NAME_CF CHARACTER VARYING(1) 1
44 COST_CENTRE_LEVEL_11_CODE_CF CHARACTER VARYING(1) 1
46 COST_CENTRE_LEVEL_11_NAME_CF CHARACTER VARYING(1) 1
48 COST_CENTRE_LEVEL_12_CODE_CF CHARACTER VARYING(1) 1
50 COST_CENTRE_LEVEL_12_NAME_CF CHARACTER VARYING(1) 1
52 COST_CENTRE_LEVEL_13_CODE_CF CHARACTER VARYING(1) 1
54 COST_CENTRE_LEVEL_13_NAME_CF CHARACTER VARYING(1) 1
56 COST_CENTRE_LEVEL_14_CODE_CF CHARACTER VARYING(1) 1
58 COST_CENTRE_LEVEL_14_NAME_CF CHARACTER VARYING(1) 1
60 COST_CENTRE_LEVEL_15_CODE_CF CHARACTER VARYING(1) 1
62 COST_CENTRE_LEVEL_15_NAME_CF CHARACTER VARYING(1) 1