FCT_OEB_GL_MEASURES_BALANCES_AGGREGATE

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 FIN_YEAR BIGINT 8
2 FIN_YEAR_MONTH BIGINT 8
3 CURRENCY_CODE CHARACTER VARYING(20) 20
4 LEVEL_01_CODE CHARACTER VARYING(150) 150
5 LEVEL_01_CODE0 CHARACTER VARYING(150) 150
6 LEVEL_01_CODE1 CHARACTER VARYING(150) 150
7 LEVEL_01_CODE2 CHARACTER VARYING(150) 150
8 LEVEL_01_CODE3 CHARACTER VARYING(150) 150
9 LEVEL_02_CODE CHARACTER VARYING(150) 150
10 LEVEL_01_CODE4 CHARACTER VARYING(150) 150
11 LEVEL_01_CODE5 CHARACTER VARYING(150) 150
12 LAST_UPDATE_DATE TIMESTAMP 8
13 CDC_COMMIT_TIMES TIMESTAMP 8
14 MTD_ACTUAL NUMERIC(38,2) 19
15 MTD_PROJECTED_AC NUMERIC(38,2) 19
16 MTD_PCP_ACTUAL NUMERIC(38,2) 19
17 MTD_PCP_ACTUAL_V NUMERIC(38,2) 19
18 MTD_BUDGET NUMERIC(38,2) 19
19 MTD_PCP_BUDGET NUMERIC(38,2) 19
20 MTD_BUDGET_VARIA NUMERIC(38,2) 19
21 MTD_FORECAST NUMERIC(38,2) 19
22 MTD_PCP_FORECAST NUMERIC(38,2) 19
23 MTD_FORECAST_VAR NUMERIC(38,2) 19
24 YTD_ACTUAL NUMERIC(38,2) 19
25 YTD_PCP_ACTUAL NUMERIC(38,2) 19
26 YTD_PCP_ACTUAL_V NUMERIC(38,2) 19
27 YTD_BUDGET NUMERIC(38,2) 19
28 YTD_PCP_BUDGET NUMERIC(38,2) 19
29 YTD_BUDGET_VARIA NUMERIC(38,2) 19
30 YTD_FORECAST NUMERIC(38,2) 19
31 YTD_PCP_FORECAST NUMERIC(38,2) 19
32 YTD_FORECAST_VAR NUMERIC(38,2) 19
33 FY_ACTUAL NUMERIC(38,2) 19
34 FY_PROJECTED_ACT NUMERIC(38,2) 19
35 FY_BUDGET NUMERIC(38,2) 19
36 FY_BUDGET_VARIAN NUMERIC(38,2) 19
37 FY_FORECAST NUMERIC(38,2) 19
38 FY_FORECAST_VARI NUMERIC(38,2) 19