FCT_OEB_EXPENSE_BALANCE_AGG_INSIGHT

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 Level_01_Code CHARACTER VARYING(150) 150
2 Level_02_Code CHARACTER VARYING(150) 150
3 Level_03_Code CHARACTER VARYING(150) 150
4 Cal_Year BIGINT 8
5 Cal_Year_Month BIGINT 8
6 Year0 BIGINT 8
7 Fin_Year_Month BIGINT 8
8 Currency_Code CHARACTER VARYING(15) 15
9 Level_01_Code0 CHARACTER VARYING(150) 150
10 Level_02_Code0 CHARACTER VARYING(150) 150
11 Level_03_Code0 CHARACTER VARYING(150) 150
12 Level_04_Code CHARACTER VARYING(150) 150
13 Level_05_Code CHARACTER VARYING(150) 150
14 Level_06_Code CHARACTER VARYING(150) 150
15 Level_07_Code CHARACTER VARYING(150) 150
16 Level_08_Code CHARACTER VARYING(150) 150
17 Level_09_Code CHARACTER VARYING(150) 150
18 Level_10_Code CHARACTER VARYING(150) 150
19 Level_01_Code1 CHARACTER VARYING(150) 150
20 Level_02_Code1 CHARACTER VARYING(150) 150
21 Level_03_Code1 CHARACTER VARYING(150) 150
22 Level_04_Code1 CHARACTER VARYING(150) 150
23 Level_05_Code1 CHARACTER VARYING(150) 150
24 Level_06_Code1 CHARACTER VARYING(150) 150
25 Level_07_Code1 CHARACTER VARYING(150) 150
26 Level_08_Code1 CHARACTER VARYING(150) 150
27 Level_09_Code1 CHARACTER VARYING(150) 150
28 Level_10_Code1 CHARACTER VARYING(150) 150
29 Mtd_Actual NUMERIC(38,5) 19
30 Mtd_Projected_Ac NUMERIC(38,5) 19
31 Mtd_Budget NUMERIC(38,5) 19
32 Mtd_Forecast NUMERIC(38,5) 19
33 Ytd_Actual NUMERIC(38,5) 19
34 Ytd_Budget NUMERIC(38,5) 19
35 Ytd_Forecast NUMERIC(38,5) 19
36 Fy_Actual NUMERIC(38,5) 19
37 Fy_Projected_Act NUMERIC(38,5) 19
38 Fy_Budget NUMERIC(38,5) 19
39 Fy_Forecast NUMERIC(38,5) 19
40 Pcp_Mtd_Actual NUMERIC(38,5) 19
41 Pcp_Mtd_Budget NUMERIC(38,5) 19
42 Pcp_Mtd_Forecast NUMERIC(38,5) 19
43 Pcp_Ytd_Actual NUMERIC(38,5) 19
44 Pcp_Ytd_Budget NUMERIC(38,5) 19
45 Pcp_Ytd_Forecast NUMERIC(38,5) 19
46 Mtd_Budget_Varia NUMERIC(38,5) 19
47 Mtd_Forecast_Var NUMERIC(38,5) 19
48 Ytd_Budget_Varia NUMERIC(38,5) 19
49 Ytd_Forecast_Var NUMERIC(38,5) 19
50 Fy_Budget_Varian NUMERIC(38,5) 19
51 Fy_Forecast_Vari NUMERIC(38,5) 19
52 Pcp_Mtd_Actual_V NUMERIC(38,5) 19
53 Pcp_Ytd_Actual_V NUMERIC(38,5) 19
54 Mtd_Variance___B NUMERIC(38,6) 19
55 Mtd_Variance___F NUMERIC(38,6) 19
56 Level_01_Code11 CHARACTER VARYING(150) 150
57 Level_02_Code11 CHARACTER VARYING(150) 150