fct_bnk_crai_account_eod_td_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 account_closure_date character varying 600
2 account_creation_date character varying 600
3 account_efs_dim_id bigint 64
4 account_gl_closure_date character varying 600
5 account_gl_opening_date character varying 600
6 account_number character varying 120
7 account_id_number character varying 111
8 account_opening_date character varying 600
9 account_status_code character varying 120
10 account_title character varying 900
11 deposit_number character varying 60
12 deposit_date character varying 600
13 deposit_closing_date character varying 600
14 renew_count double precision 53
15 parent_deposit_number character varying 60
16 arrangement_id character varying 120
17 bank_code character varying 30
18 branch_code character varying 30
19 company_code character varying 15
20 cost_centre_code character varying 450
21 created_by character varying 762
22 currency_code character varying 9
23 effective_end_date character varying 600
24 effective_start_date character varying 600
25 is_current character varying 3
26 maturity_date character varying 600
27 offer_id character varying 90
28 offset_flag character varying 3
29 offset_assoc_acct character varying 60
30 original_maturity_date character varying 600
31 product_class character varying 6
32 product_group_code character varying 90
33 product_sub_code character varying 90
34 product_id character varying 90
35 service_branch_code character varying 30
36 source_product_code character varying 183
37 source_system_code character varying 36
38 term_months double precision 53
39 source_system_group character varying 9
40 of_cost_centre_code character varying 720
41 of_entity_code character varying 720
42 of_product_code character varying 720
43 of_int_accrued_account_code character varying 720
44 of_int_accrued_category_code character varying 720
45 of_int_expense_account_code character varying 720
46 of_int_expense_accrued_account_code character varying 720
47 of_int_expense_accrued_category_code character varying 720
48 of_int_expense_category_code character varying 720
49 of_principal_account_code character varying 720
50 of_principal_category_code character varying 720
51 source_product_dim_id bigint 64
52 of_cost_centre_dim_id character varying 720
53 of_entity_dim_id character varying 720
54 of_int_accrued_category_dim_id character varying 720
55 of_int_accrued_account_dim_id character varying 720
56 of_int_expense_account_dim_id character varying 720
57 of_int_expense_accrued_account_dim_id character varying 720
58 of_int_expense_accrued_category_dim_id character varying 720
59 of_int_expense_category_dim_id character varying 720
60 of_principal_account_dim_id character varying 720
61 of_principal_category_dim_id character varying 720
62 of_product_dim_id character varying 720