npp_payment_master_202105

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 hid bigint 64
2 trace_id character varying 120
3 transaction_id character varying 105
4 end_to_end_id character varying 105
5 case_id character varying 105
6 initiated_time_stamp timestamp without time zone
7 last_updated_timestamp timestamp without time zone
8 transaction_description character varying 3360
9 transaction_type character varying 72
10 transaction_status character varying 72
11 bpay_channel character varying 72
12 amount character varying 60
13 currency character varying 30
14 payid character varying 768
15 payid_type character varying 105
16 payid_name character varying 420
17 from_account_title character varying 420
18 from_account_nbr character varying 60
19 from_bsb character varying 21
20 to_account_title character varying 420
21 to_acct_nbr character varying 60
22 to_bsb character varying 21
23 from_account_type character varying 30
24 to_account_type character varying 30
25 data_date timestamp without time zone
26 load_id integer 32