FCT_OF_GL_BANK_BUDGETS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 CALENDAR_END_DATE TIMESTAMP 8
2 ENTITY_CODE CHARACTER VARYING(150) 150
3 COST_CENTRE_CODE CHARACTER VARYING(150) 150
4 ACCOUNT_CODE CHARACTER VARYING(150) 150
5 CATEGORY_CODE CHARACTER VARYING(150) 150
6 PRODUCT_CODE CHARACTER VARYING(150) 150
7 MTD_PMB NUMERIC(31,5) 19
8 YTD_PMB NUMERIC(31,5) 19
9 AVGBAL_MTD_BUD NUMERIC(31,5) 19
10 AVGBAL_YTD_BUD NUMERIC(31,5) 19
11 MTD_GTH_BUD NUMERIC(31,5) 19
12 YTD_GTH_BUD NUMERIC(31,5) 19
13 MTD_ACT NUMERIC(31,5) 19
14 YTD_ACT NUMERIC(31,5) 19
15 YEAR_OPENING_BALANCE_AMOUNT NUMERIC(31,5) 19
16 OPENING_BALANCE_AMOUNT NUMERIC(31,5) 19
17 SIGNED_NET_AMOUNT NUMERIC(31,5) 19
18 CLOSING_BALANCE_AMOUNT NUMERIC(31,5) 19
19 YTD_DEBIT_AMOUNT NUMERIC(31,5) 19
20 YTD_CREDIT_AMOUNT NUMERIC(31,5) 19
21 CREDIT_AMOUNT NUMERIC(31,5) 19
22 DEBIT_AMOUNT NUMERIC(31,5) 19
23 STATISTIC_UNITS_OPENING_BALA NUMERIC(31,5) 19
24 STATISTICAL_UNITS_DEBIT_QUAN NUMERIC(31,5) 19
25 STATISTICAL_UNITS_CREDIT_QUA NUMERIC(31,5) 19
26 STATISTICAL_UNITS_SIGNED_NET NUMERIC(31,5) 19
27 STATISTIC_UNITS_CLOSING_BALA NUMERIC(31,5) 19
28 STATISTICAL_UNITS_YTD_DEBIT NUMERIC(31,5) 19
29 STATISTICAL_UNITS_YTD_CREDIT NUMERIC(31,5) 19
30 STATISTIC_UNITS_YEAR_OPENING1 NUMERIC(31,5) 19
31 DAYS_IN_MONTH BIGINT 8
32 DAYS_IN_YEAR BIGINT 8
33 HALF_YEAR BIGINT 8
34 YEAR BIGINT 8
35 MONTH BIGINT 8
36 MTD_GROWTH NUMERIC(31,5) 19
37 YTD_GROWTH NUMERIC(31,5) 19
38 DAYS_YTD NUMERIC(31,5) 19
39 LEAP_YEAR_FIX NUMERIC(31,5) 19
40 MTD_AVG NUMERIC(31,5) 19
41 YTD_AVG NUMERIC(31,5) 19
42 ACCOUNT_CATEGORY_CODE CHARACTER VARYING(150) 150
43 BUDGET_TYPE CHARACTER VARYING(20) 20
44 ALL_TIME_SID BIGINT 8
45 CALENDAR_PERIOD_END_DATE TIMESTAMP 8
46 LOOKUP_TYPE CHARACTER VARYING(100) 100
47 BEC_COMBINED_PRODUCT CHARACTER VARYING(100) 100