FCT_OF_GL_BANK_BALANCES

Database

SDSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_OF_GL_BANK_BALANCES_V

Target Objects (CTAS)

INSNZP02_BANK..FCT_OF_GL_BANK_BALANCES_INSIGHT

Columns
# Name Data Type Length
1 COST_CENTRE_SID BIGINT 8
2 ACCOUNT_SID BIGINT 8
3 CATEGORY_SID BIGINT 8
4 PRODUCT_SID BIGINT 8
5 ENTITY_SID BIGINT 8
6 ALL_TIME_SID BIGINT 8
7 YEAR_OPENING_BALANCE_AMOUNT DOUBLE PRECISION 8
8 OPENING_BALANCE_AMOUNT DOUBLE PRECISION 8
9 SIGNED_NET_AMOUNT DOUBLE PRECISION 8
10 CLOSING_BALANCE_AMOUNT DOUBLE PRECISION 8
11 YTD_DEBIT_AMOUNT DOUBLE PRECISION 8
12 YTD_CREDIT_AMOUNT DOUBLE PRECISION 8
13 CREDIT_AMOUNT DOUBLE PRECISION 8
14 DEBIT_AMOUNT DOUBLE PRECISION 8
15 STATISTIC_UNITS_OPENING_BALA DOUBLE PRECISION 8
16 STATISTICAL_UNITS_DEBIT_QUAN DOUBLE PRECISION 8
17 STATISTICAL_UNITS_CREDIT_QUA DOUBLE PRECISION 8
18 STATISTICAL_UNITS_SIGNED_NET DOUBLE PRECISION 8
19 STATISTIC_UNITS_CLOSING_BALA DOUBLE PRECISION 8
20 STATISTICAL_UNITS_YTD_DEBIT_ DOUBLE PRECISION 8
21 STATISTICAL_UNITS_YTD_CREDIT DOUBLE PRECISION 8
22 STATISTIC_UNITS_YEAR_OPENING1 DOUBLE PRECISION 8
23 CALENDAR_END_DATE TIMESTAMP 8
24 ENTITY_CODE CHARACTER VARYING(150) 150
25 COST_CENTRE_CODE CHARACTER VARYING(150) 150
26 ACCOUNT_CODE CHARACTER VARYING(150) 150
27 CATEGORY_CODE CHARACTER VARYING(150) 150
28 PRODUCT_CODE CHARACTER VARYING(150) 150
29 MTD_AVERAGE NUMERIC(14,2) 19
30 YTD_AVERAGE NUMERIC(14,2) 19
31 MTD_PMB NUMERIC(14,2) 19
32 YTD_PMB NUMERIC(14,2) 19
33 BUSINESS_LOAD_DATE TIMESTAMP 8
34 REMAPPED_PROD_SID BIGINT 8
35 REMAPPED_PROD_CODE CHARACTER VARYING(150) 150
36 MTD_ACTUAL NUMERIC(14,2) 19
37 YTD_ACTUAL NUMERIC(14,2) 19
38 MTD_GROWTH NUMERIC(14,2) 19
39 YTD_GROWTH NUMERIC(14,2) 19
40 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
41 LOOKUP_TYPE CHARACTER VARYING(100) 100
42 BEC_COMBINED_PRODUCT CHARACTER VARYING(100) 100