tbist_wbook

Database

prod_bank_wealth

Schema

sor_bdw

Type

BASE TABLE

Description

 

Columns
# Name Data Type Length
1 wbook_hiid integer 32
2 pk_tbist_wbook_wbookid integer 32
3 fk_tbist_wgroup_wgroupid integer 32
4 booknamedesc character varying 600
5 brokercode character varying 18
6 certificateissueddate timestamp without time zone
7 startdate timestamp without time zone
8 terminationdate timestamp without time zone
9 gstflag integer 32
10 sysrl_user character varying 150
11 sysrl_timestamp timestamp without time zone
12 sysr_deleted integer 32
13 sysr_deletedby character varying 150
14 sysr_deletedon timestamp without time zone
15 vendorno character varying 21
16 paymenttype character varying 30
17 banktype character varying 30
18 bsbtype character varying 150
19 accountno character varying 150
20 fk_tbisr_resourcetype integer 32
21 fk_tbisr_status integer 32
22 fk_tbisr_plr_districtid integer 32
23 phoneno character varying 150
24 faxno character varying 150
25 mobileno character varying 150
26 emailnam character varying 300
27 cob date
28 delta_type character varying 3
29 effective_strt_dt timestamp without time zone
30 effective_end_dt timestamp without time zone