fct_obp_crai_transactions_td_insight

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 posting_period_dim_id bigint 64
2 src_effective_period_dim_id bigint 64
3 business_period_dim_id bigint 64
4 transaction_dim_id bigint 64
5 account_dim_id bigint 64
6 classification_period_dim_id bigint 64
7 service_branch_code character varying 30
8 account_status_code character varying 120
9 transaction_typ2_dim_id bigint 64
10 txn_classification_dim_id bigint 64
11 source_product_code character varying 183
12 product_code character varying 90
13 product_group_code character varying 90
14 balance_sheet_indicator character varying 27
15 classification_date date
16 deposit_number double precision 53
17 txn_branch character varying 30
18 txn_ref_no character varying 150
19 sub_seq_no double precision 53
20 txn_channel character varying 150
21 transaction_date date
22 transaction_timestamp timestamp without time zone
23 posting_date date
24 transaction_user_id character varying 150
25 event_id character varying 150
26 authorizer_code character varying 150
27 txn_amount_tcy double precision 53
28 tcy_code character varying 9
29 txn_amount_acy double precision 53
30 acy_code character varying 9
31 account_running_amt double precision 53
32 deposit_running_amt double precision 53
33 settlement_ref_id character varying 300
34 cheque_no character varying 150
35 cheque_deposit_date character varying 150
36 cheque_value_date character varying 150
37 fx_rate character varying 3
38 txn_type character varying 150
39 narration character varying 1500
40 txn_desc character varying 300
41 card_ref_no character varying 150
42 user_ref_no character varying 150
43 cdc_source_system_code character varying 12
44 cdc_record_type character varying 48
45 cdc_commit_timestamp timestamp without time zone
46 cdc_extract_timestamp timestamp without time zone