| acct_id | varchar(40) |
|
|
|
| creation_date | bigint(20) |
|
|
|
| noren_time_stamp | bigint(20) |
|
|
|
| mob_num | varchar(40) |
|
|
|
| display_precision | int(10) |
|
|
|
| dp_type | varchar(40) |
|
|
|
| dp_id | varchar(40) |
|
|
|
| broker_id | varchar(40) |
|
|
|
| region | varchar(128) |
|
|
|
| acct_name | varchar(256) |
|
|
|
| src_user_id | varchar(40) |
|
|
|
| email_id | varchar(256) |
|
|
|
| pan_num | varchar(40) |
|
|
|
| addr | varchar(512) |
|
|
|
| acct_type | varchar(40) |
|
|
|
| status | varchar(40) |
|
|
|
| office_addr | varchar(40) |
|
|
|
| addr_city | varchar(40) |
|
|
|
| addr_state | varchar(40) |
|
|
|
| gender | varchar(40) |
|
|
|
| occupation | varchar(40) |
|
|
|
| exch_acct_id | varchar(40) |
|
|
|
| family_id | varchar(40) |
|
|
|
| context | varchar(40) |
|
|
|
| product | varchar(40) |
|
|
|
| dp_actnum1 | varchar(40) |
|
|
|
| dp_actnum2 | varchar(40) |
|
|
|
| dp_actnum3 | varchar(40) |
|
|
|
| mail | tinyint(1) |
|
|
|
| sms | tinyint(1) |
|
|
|
| trade_notification | varchar(40) |
|
|
|
| cust_firm | varchar(40) |
|
|
|
| bank_addr1 | varchar(256) |
|
|
|
| bank_brnch_name1 | varchar(40) |
|
|
|
| bank_name1 | varchar(40) |
|
|
|
| bank_acct_type1 | varchar(40) |
|
|
|
| bank_acct_num1 | varchar(256) |
|
|
|
| bank_ifsc_code1 | varchar(256) |
|
|
|
| bank_addr2 | varchar(256) |
|
|
|
| bank_brnch_name2 | varchar(40) |
|
|
|
| bank_name2 | varchar(40) |
|
|
|
| bank_acct_type2 | varchar(40) |
|
|
|
| bank_acct_num2 | varchar(256) |
|
|
|
| bank_ifsc_code2 | varchar(256) |
|
|
|
| bank_addr3 | varchar(256) |
|
|
|
| bank_brnch_name3 | varchar(40) |
|
|
|
| bank_name3 | varchar(40) |
|
|
|
| bank_acct_type3 | varchar(40) |
|
|
|
| bank_acct_num3 | varchar(256) |
|
|
|
| bank_ifsc_code3 | varchar(256) |
|
|
|
| bank_addr4 | varchar(256) |
|
|
|
| bank_brnch_name4 | varchar(40) |
|
|
|
| bank_name4 | varchar(40) |
|
|
|
| bank_acct_type4 | varchar(40) |
|
|
|
| bank_acct_num4 | varchar(256) |
|
|
|
| bank_ifsc_code4 | varchar(256) |
|
|
|
| bank_addr5 | varchar(256) |
|
|
|
| bank_brnch_name5 | varchar(40) |
|
|
|
| bank_name5 | varchar(40) |
|
|
|
| bank_acct_type5 | varchar(40) |
|
|
|
| bank_acct_num5 | varchar(256) |
|
|
|
| bank_ifsc_code5 | varchar(256) |
|
|
|
| bank_addr6 | varchar(256) |
|
|
|
| bank_brnch_name6 | varchar(40) |
|
|
|
| bank_name6 | varchar(40) |
|
|
|
| bank_acct_type6 | varchar(40) |
|
|
|
| bank_acct_num6 | varchar(256) |
|
|
|
| bank_ifsc_code6 | varchar(256) |
|
|
|
| sor_flag | tinyint(1) |
|
|
|
