sdw_tsdmd_transactions

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 transaction_dim_id double precision 53
2 source_system_code character varying 36
3 source_company_code character varying 18
4 source_pcs_environment_code character varying 18
5 source_pcs_source_code character varying 18
6 source_pcs_application_code character varying 18
7 source_product_type_code character varying 18
8 source_calculation_type_code character varying 18
9 source_transaction_code character varying 18
10 load_status_flag character varying 3
11 insert_run_audit_id bigint 64
12 update_run_audit_id bigint 64
13 transaction_description character varying 768
14 customer_initiated_flag character varying 3
15 matched_reversal_flag character varying 3
16 monetary_indicator_flag character varying 3
17 txn_class_type character varying 72
18 txn_sub_class_type character varying 72
19 txn_honoured_type character varying 72
20 txn_inbound_fund_type character varying 72
21 txn_customer_initiated_flag character varying 72
22 txn_matched_reversal_flag character varying 72
23 txn_monetary_indicator_flag character varying 72
24 txn_financial_crime_type character varying 72
25 txn_financial_crime_scope character varying 72
26 txn_financial_crime_instrument character varying 72
27 txn_financial_crime_channel character varying 72
28 txn_financial_crime_region character varying 72
29 txn_financial_crime_use_in_src character varying 72
30 inform_classification character varying 72
31 inform_category character varying 72
32 inform_category_group character varying 72
33 cpr_category_group character varying 72
34 cdc_source_system_code character varying 12
35 cdc_record_type character varying 48
36 cdc_commit_timestamp timestamp without time zone
37 cdc_extract_timestamp timestamp without time zone