FCT_OEB_EXPENSE_BALANCE_INSIGHT

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 COST_CENTRE_LEVEL_01_CODE CHARACTER VARYING(150) 150
2 COST_CENTRE_LEVEL_01_NAME CHARACTER VARYING(240) 240
3 COST_CENTRE_LEVEL_01_TYPE CHARACTER VARYING(240) 240
4 COST_CENTRE_LEVEL_02_CODE CHARACTER VARYING(150) 150
5 COST_CENTRE_LEVEL_02_NAME CHARACTER VARYING(240) 240
6 COST_CENTRE_LEVEL_02_TYPE CHARACTER VARYING(240) 240
7 COST_CENTRE_LEVEL_03_CODE CHARACTER VARYING(150) 150
8 COST_CENTRE_LEVEL_03_NAME CHARACTER VARYING(240) 240
9 COST_CENTRE_LEVEL_03_TYPE CHARACTER VARYING(240) 240
10 COST_CENTRE_LEVEL_04_CODE CHARACTER VARYING(150) 150
11 COST_CENTRE_LEVEL_04_NAME CHARACTER VARYING(240) 240
12 COST_CENTRE_LEVEL_04_TYPE CHARACTER VARYING(240) 240
13 COST_CENTRE_LEVEL_05_CODE CHARACTER VARYING(150) 150
14 COST_CENTRE_LEVEL_05_NAME CHARACTER VARYING(240) 240
15 COST_CENTRE_LEVEL_05_TYPE CHARACTER VARYING(240) 240
16 COST_CENTRE_LEVEL_06_CODE CHARACTER VARYING(150) 150
17 COST_CENTRE_LEVEL_06_NAME CHARACTER VARYING(240) 240
18 COST_CENTRE_LEVEL_06_TYPE CHARACTER VARYING(240) 240
19 COST_CENTRE_LEVEL_07_CODE CHARACTER VARYING(150) 150
20 COST_CENTRE_LEVEL_07_NAME CHARACTER VARYING(240) 240
21 COST_CENTRE_LEVEL_07_TYPE CHARACTER VARYING(240) 240
22 COST_CENTRE_LEVEL_08_CODE CHARACTER VARYING(150) 150
23 COST_CENTRE_LEVEL_08_NAME CHARACTER VARYING(240) 240
24 COST_CENTRE_LEVEL_08_TYPE CHARACTER VARYING(240) 240
25 COST_CENTRE_LEVEL_09_CODE CHARACTER VARYING(150) 150
26 COST_CENTRE_LEVEL_09_NAME CHARACTER VARYING(240) 240
27 COST_CENTRE_LEVEL_09_TYPE CHARACTER VARYING(240) 240
28 COST_CENTRE_LEVEL_10_CODE CHARACTER VARYING(150) 150
29 COST_CENTRE_LEVEL_10_NAME CHARACTER VARYING(240) 240
30 COST_CENTRE_LEVEL_10_TYPE CHARACTER VARYING(240) 240
31 ACCOUNT_LEVEL_01_CODE CHARACTER VARYING(150) 150
32 ACCOUNT_LEVEL_01_NAME CHARACTER VARYING(240) 240
33 ACCOUNT_LEVEL_02_CODE CHARACTER VARYING(150) 150
34 ACCOUNT_LEVEL_02_NAME CHARACTER VARYING(240) 240
35 ACCOUNT_LEVEL_03_CODE CHARACTER VARYING(150) 150
36 ACCOUNT_LEVEL_03_NAME CHARACTER VARYING(240) 240
37 ACCOUNT_LEVEL_04_CODE CHARACTER VARYING(150) 150
38 ACCOUNT_LEVEL_04_NAME CHARACTER VARYING(240) 240
39 ACCOUNT_LEVEL_05_CODE CHARACTER VARYING(150) 150
40 ACCOUNT_LEVEL_05_NAME CHARACTER VARYING(240) 240
41 ACCOUNT_LEVEL_06_CODE CHARACTER VARYING(150) 150
42 ACCOUNT_LEVEL_06_NAME CHARACTER VARYING(240) 240
43 ACCOUNT_LEVEL_07_CODE CHARACTER VARYING(150) 150
44 ACCOUNT_LEVEL_07_NAME CHARACTER VARYING(240) 240
45 ACCOUNT_LEVEL_08_CODE CHARACTER VARYING(150) 150
46 ACCOUNT_LEVEL_08_NAME CHARACTER VARYING(240) 240
47 ACCOUNT_LEVEL_09_CODE CHARACTER VARYING(150) 150
48 ACCOUNT_LEVEL_09_NAME CHARACTER VARYING(240) 240
49 ACCOUNT_LEVEL_10_CODE CHARACTER VARYING(150) 150
50 ACCOUNT_LEVEL_10_NAME CHARACTER VARYING(240) 240
51 PROJECT_LEVEL_01_CODE CHARACTER VARYING(150) 150
52 PROJECT_LEVEL_01_NAME CHARACTER VARYING(240) 240
53 PROJECT_LEVEL_02_CODE CHARACTER VARYING(150) 150
54 PROJECT_LEVEL_02_NAME CHARACTER VARYING(240) 240
55 PROJECT_LEVEL_03_CODE CHARACTER VARYING(150) 150
56 PROJECT_LEVEL_03_NAME CHARACTER VARYING(240) 240
57 PROJECT_LEVEL_04_CODE CHARACTER VARYING(150) 150
58 PROJECT_LEVEL_04_NAME CHARACTER VARYING(240) 240
59 PROJECT_LEVEL_05_CODE CHARACTER VARYING(150) 150
60 PROJECT_LEVEL_05_NAME CHARACTER VARYING(240) 240
61 PROJECT_LEVEL_06_CODE CHARACTER VARYING(150) 150
62 PROJECT_LEVEL_06_NAME CHARACTER VARYING(240) 240
63 PROJECT_LEVEL_07_CODE CHARACTER VARYING(150) 150
64 PROJECT_LEVEL_07_NAME CHARACTER VARYING(240) 240
65 PROJECT_LEVEL_08_CODE CHARACTER VARYING(150) 150
66 PROJECT_LEVEL_08_NAME CHARACTER VARYING(240) 240
67 PROJECT_LEVEL_09_CODE CHARACTER VARYING(150) 150
68 PROJECT_LEVEL_09_NAME CHARACTER VARYING(240) 240
69 PROJECT_LEVEL_10_CODE CHARACTER VARYING(150) 150
70 PROJECT_LEVEL_10_NAME CHARACTER VARYING(240) 240
71 CURRENCY_CODE CHARACTER VARYING(15) 15
72 PROJECT_CODE CHARACTER VARYING(25) 25
73 PERIOD_NAME CHARACTER VARYING(15) 15
74 CAL_YEAR BIGINT 8
75 CAL_YEAR_LABEL CHARACTER VARYING(4) 4
76 CAL_MONTH BIGINT 8
77 CAL_YEAR_MONTH BIGINT 8
78 FIN_YEAR BIGINT 8
79 FIN_YEAR_LABEL CHARACTER VARYING(4) 4
80 FIN_MONTH BIGINT 8
81 FIN_YEAR_MONTH BIGINT 8
82 MTD_ACTUAL NUMERIC(38,5) 19
83 MTD_PROJECTED_ACTUAL NUMERIC(38,5) 19
84 MTD_BUDGET NUMERIC(38,5) 19
85 MTD_FORECAST NUMERIC(38,5) 19
86 YTD_ACTUAL NUMERIC(38,5) 19
87 YTD_BUDGET NUMERIC(38,5) 19
88 YTD_FORECAST NUMERIC(38,5) 19
89 FY_ACTUAL NUMERIC(38,5) 19
90 FY_PROJECTED_ACTUAL NUMERIC(38,5) 19
91 FY_BUDGET NUMERIC(38,5) 19
92 FY_FORECAST NUMERIC(38,5) 19
93 PCP_MTD_ACTUAL NUMERIC(38,5) 19
94 PCP_MTD_BUDGET NUMERIC(38,5) 19
95 PCP_MTD_FORECAST NUMERIC(38,5) 19
96 MAX_CDC_COMMIT_TIMESTAMP TIMESTAMP 8
97 PCP_YTD_ACTUAL NUMERIC(38,5) 19
98 PCP_YTD_BUDGET NUMERIC(38,5) 19
99 PCP_YTD_FORECAST NUMERIC(38,5) 19
100 MTD_BUDGET_VARIANCE NUMERIC(38,5) 19
101 MTD_FORECAST_VARIANCE NUMERIC(38,5) 19
102 YTD_BUDGET_VARIANCE NUMERIC(38,5) 19
103 YTD_FORECAST_VARIANCE NUMERIC(38,5) 19
104 FY_BUDGET_VARIANCE NUMERIC(38,5) 19
105 FY_FORECAST_VARIANCE NUMERIC(38,5) 19
106 PCP_MTD_ACTUAL_VARIANCE NUMERIC(38,5) 19
107 PCP_YTD_ACTUAL_VARIANCE NUMERIC(38,5) 19