int_bnk_npp_transactions_v

Database

prod_bank_wealth

Schema

sdsrsp01_bank

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 trace_id character varying 120
2 transaction_id character varying 105
3 end_to_end_id character varying 105
4 case_id character varying 105
5 initiated_timestamp timestamp without time zone
6 last_updated_timestamp timestamp without time zone
7 transaction_type character varying 72
8 amount character varying 60
9 currency character varying 30
10 payid character varying 768
11 payid_type character varying 105
12 payid_name character varying 420
13 from_account_title character varying 420
14 from_account_number character varying 60
15 from_bsb character varying 21
16 to_account_title character varying 420
17 to_account_number character varying 60
18 to_bsb character varying 21
19 from_account_type character varying 30
20 to_account_type character varying 30
21 channel_code character varying 72
22 channel character varying 150
23 payment_address text
24 payment_direction character varying 72
25 payment_domain text
26 payment_service text
27 payment_status character varying 72