| noren_ord_num | bigint(20) |
|
|
|
| noren_time_stamp | bigint(20) |
|
|
|
| noren_nsecs | bigint(20) |
|
|
|
| eref | bigint(20) |
|
|
|
| noren_kid_id | int(10) |
|
|
|
| ord_status | int(10) |
|
|
|
| report_type | int(10) |
|
|
|
| acct_id | varchar(40) |
|
|
|
| user_id | varchar(40) |
|
|
|
| ord_src | varchar(40) |
|
|
|
| trading_symbol | varchar(40) |
|
|
|
| exch_seg | varchar(40) |
|
|
|
| token | varchar(40) |
|
|
|
| trans_type | varchar(40) |
|
|
|
| price_type | varchar(40) |
|
|
|
| product | varchar(40) |
|
|
|
| ord_duration | varchar(40) |
|
|
|
| broker_id | varchar(40) |
|
|
|
| region | varchar(40) |
|
|
|
| family_id | varchar(40) |
|
|
|
| cust_firm | varchar(40) |
|
|
|
| partic_id | varchar(40) |
|
|
|
| pan_num | varchar(40) |
|
|
|
| qty_to_fill | bigint(20) |
|
|
|
| red_qty | bigint(20) |
|
|
|
| price_to_fill | bigint(20) |
|
|
|
| red_price | bigint(20) |
|
|
|
| rej_reason | varchar(256) |
|
|
|
| rej_by | varchar(40) |
|
|
|
| noren_org_time_stamp | bigint(20) |
|
|
|
| noren_org_nsecs | bigint(20) |
|
|
|
| disc_qty | bigint(20) |
|
|
|
| exch_user_id | varchar(40) |
|
|
|
| ord_remarks | varchar(256) |
|
|
|
| price_precision | int(10) |
|
|
|
| qty_precision | int(10) |
|
|
|
| mkt_ind | int(10) |
|
|
|
| symbol_name | varchar(40) |
|
|
|
| exchange | varchar(40) |
|
|
|
| segment | varchar(40) |
|
|
|
| trd_symbol | varchar(40) |
|
|
|
| instrument_name | varchar(40) |
|
|
|
| option_type | varchar(40) |
|
|
|
| tick_size | int(10) |
|
|
|
| spread_trading_symbol_leg_1 | varchar(256) |
|
|
|
| spread_trading_symbol_leg_2 | varchar(256) |
|
|
|
| hl_min_price | bigint(20) |
|
|
|
| hl_max_price | bigint(20) |
|
|
|
| bo_min_price | bigint(20) |
|
|
|
| bo_max_price | bigint(20) |
|
|
|
| con_prod_id | varchar(40) |
|
|
|
| sip_min_amt | bigint(20) |
|
|
|
| sip_max_amt | bigint(20) |
|
|
|
| sip_inc_amt | bigint(20) |
|
|
|
| sip_min_inst | bigint(20) |
|
|
|
| sip_max_inst | bigint(20) |
|
|
|
| sip_val_det | varchar(512) |
|
|
|
| gui_status | int(10) |
|
|
|
| red_check | int(10) |
|
|
|
| red_super_user | int(10) |
|
|
|
| exch_seg_acct_id | varchar(40) |
|
|
|
| rej_qty | bigint(20) |
|
|
|
| rej_ord_src | varchar(40) |
|
|
|
| rej_price_type | varchar(40) |
|
|
|
| user_privilege | int(10) |
|
|
|
| purchse_type | varchar(40) |
|
|
|
| dp_trans | varchar(40) |
|
|
|
| kyc_status | int(10) |
|
|
|