fct_bnk_asic516_bln_transaction_summary_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_number character varying 120
2 account_open_date timestamp without time zone
3 account_close_date timestamp without time zone
4 report_include_flag character varying 21
5 business_period_dt timestamp without time zone
6 week_end_dt timestamp without time zone
7 month_end_dt timestamp without time zone
8 source_system_code character varying 36
9 balance_sheet_indicator character varying 60
10 source_product_code character varying 195
11 product_1_desc character varying 300
12 product_2_desc character varying 300
13 product_3_desc character varying 300
14 product_4_desc character varying 300
15 product_5_desc character varying 300
16 oracle_gl_cost_centre character varying 450
17 cost_centre_level_01_name character varying 720
18 cost_centre_level_02_name character varying 720
19 cost_centre_level_03_name character varying 720
20 cost_centre_level_04_name character varying 720
21 cost_centre_level_05_name character varying 720
22 cost_centre_level_06_name character varying 720
23 txn_category_level_1 character varying 150
24 txn_category_level_2 character varying 150
25 txn_category_level_3 character varying 150
26 txn_category_level_4 character varying 3
27 dly_reg_txn_category_level_1 character varying 72
28 dly_reg_txn_category_level_2 character varying 72
29 dly_reg_txn_category_level_3 character varying 72
30 wk_reg_txn_category_level_1 character varying 72
31 wk_reg_txn_category_level_2 character varying 72
32 wk_reg_txn_category_level_3 character varying 72
33 mth_reg_txn_category_level_1 character varying 72
34 mth_reg_txn_category_level_2 character varying 72
35 mth_reg_txn_category_level_3 character varying 72
36 txn_amount double precision 53
37 oracle_gl_product_code character varying 450
38 gl_product_name character varying 720
39 gl_level_1_product character varying 720
40 gl_level_2_product character varying 720
41 gl_level_3_product character varying 720
42 gl_level_4_product character varying 720
43 gl_level_5_product character varying 720
44 gl_level_6_product character varying 720
45 obp_disb_txn_amt double precision 53