fct_bnk_npp_transactions

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 trace_id character varying 256
2 transaction_id integer 32
3 npp_transaction_id character varying 256
4 end_to_end_id character varying 256
5 case_id character varying 256
6 transaction_date timestamp without time zone
7 last_updated_timestamp timestamp without time zone
8 effective_date timestamp without time zone
9 after_posting_balance numeric 16
10 transaction_code character varying 256
11 reference_transaction character varying 256
12 transaction_type character varying 256
13 amount numeric 16
14 currency character varying 256
15 payid character varying 256
16 payid_type character varying 256
17 payid_name character varying 256
18 from_account_title character varying 256
19 from_account_number character varying 256
20 from_bsb character varying 256
21 to_account_title character varying 256
22 to_account_number character varying 256
23 to_bsb character varying 256
24 payment_domain character varying 256
25 payment_address character varying 256
26 payment_direction_fin character varying 256
27 channel_code character varying 256
28 channel_desc character varying 256
29 account_type character varying 256
30 payment_status character varying 256
31 payment_status_flag character varying 256
32 payment_service character varying 256
33 rdm_payment_type character varying 256
34 rdm_payment_type_status character varying 256
35 rdm_return_status character varying 256
36 rejection_flag character 1
37 calendar_month_name character varying 256
38 calendar_qtr character varying 256
39 calendar_qtr_name character varying 256
40 calendar_year integer 32
41 calendar_yyyymm integer 32
42 calendar_qtr_no integer 32