hods_transaction

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 system_date timestamp without time zone
4 company_no bigint 64
5 product_code character varying 9
6 account_no bigint 64
7 envmt integer 32
8 source_type integer 32
9 appl_id integer 32
10 posting_date timestamp without time zone
11 posting_time character varying 24
12 posting_tran_code integer 32
13 ods_ext_tran_code character varying 12
14 ods_int_tran_code integer 32
15 effective_date date
16 csh_amt numeric 13
17 chq_amt numeric 13
18 tfr_amt numeric 13
19 oth_amt numeric 13
20 tot_amt numeric 13
21 netw_device_id character varying 24
22 cics_term_id character varying 12
23 device_type character varying 3
24 acq_inst_cd character varying 18
25 seq_no integer 32
26 input_card_no character varying 60
27 biller_code bigint 64
28 branch_no integer 32
29 chq_no bigint 64
30 auth_code character varying 27
31 xfr_prod_code character varying 9
32 xfr_account_no character varying 60
33 xfr_appl_id integer 32
34 data_date timestamp without time zone
35 load_id integer 32