hdda_transaction_daily

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 id bigint 64
2 action_code character varying 3
3 key_coid character varying 15
4 key_prod character varying 9
5 key_acct bigint 64
6 effective_date timestamp without time zone
7 envmt character varying 15
8 source_type character varying 15
9 appl_id character varying 15
10 transaction_code character varying 15
11 after_posting_balance numeric 16
12 amount numeric 16
13 nbr_of_deposited_chqs integer 32
14 operator character varying 60
15 paid_into_overdraft character varying 3
16 posting_date timestamp without time zone
17 posting_time character varying 24
18 reference character varying 141
19 source_branch character varying 15
20 trace_number character varying 60
21 tran_creation_date timestamp without time zone
22 xfer_from_acct_nbr character varying 60
23 xfer_from_appl_id character varying 15
24 xfer_from_trancode character varying 15
25 xfer_to_acct_nbr character varying 60
26 xfer_to_appl_id character varying 15
27 xfer_to_trancode character varying 15
28 chq_no bigint 64
29 tran_no character varying 27
30 data_date timestamp without time zone
31 load_id integer 32