| 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) |
|
|
|
| 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) |
|
|
|
| cust_firm | varchar(40) |
|
|
|
| partic_id | varchar(40) |
|
|
|
| pan_num | varchar(40) |
|
|
|
| qty_to_fill | bigint(20) |
|
|
|
| price_to_fill | bigint(20) |
|
|
|
| rej_reason | varchar(256) |
|
|
|
| cancelled_qty | bigint(20) |
|
|
|
| fill_qty | bigint(20) |
|
|
|
| total_fill_qty | bigint(20) |
|
|
|
| exch_time_stamp | bigint(20) |
|
|
|
| exch_nsecs | bigint(20) |
|
|
|
| fill_price | bigint(20) |
|
|
|
| fill_avg_price | bigint(20) |
|
|
|
| trigger_price | bigint(20) |
|
|
|
| disc_qty | bigint(20) |
|
|
|
| exch_ord_num | varchar(40) |
|
|
|
| fill_id | varchar(40) |
|
|
|
| ord_remarks | varchar(256) |
|
|
|
| fill_time | varchar(40) |
|
|
|
| trading_symbol_leg_2 | varchar(40) |
|
|
|
| trans_type_leg_2 | varchar(40) |
|
|
|
| trading_symbol_leg_3 | varchar(40) |
|
|
|
| trans_type_leg_3 | varchar(40) |
|
|
|
| trading_symbol_leg_4 | varchar(40) |
|
|
|
| trans_type_leg_4 | varchar(40) |
|
|
|
| token_leg_2 | varchar(40) |
|
|
|
| token_leg_3 | varchar(40) |
|
|
|
| token_leg_4 | varchar(40) |
|
|
|
| qty_to_fill_leg_2 | bigint(20) |
|
|
|
| price_to_fill_leg_2 | bigint(20) |
|
|
|
| qty_to_fill_leg_3 | bigint(20) |
|
|
|
| price_to_fill_leg_3 | bigint(20) |
|
|
|
| qty_to_fill_leg_4 | bigint(20) |
|
|
|
| price_to_fill_leg_4 | bigint(20) |
|
|
|
| fill_leg | int(10) |
|
|
|
| total_fill_qty_leg_2 | bigint(20) |
|
|
|
| total_fill_qty_leg_3 | bigint(20) |
|
|
|
| total_fill_qty_leg_4 | bigint(20) |
|
|
|
| fill_avg_price_leg_2 | bigint(20) |
|
|
|
| fill_avg_price_leg_3 | bigint(20) |
|
|
|
| fill_avg_price_leg_4 | bigint(20) |
|
|
|
| lot_size | int(10) |
|
|
|
| price_precision | int(10) |
|
|
|
| qty_precision | int(10) |
|
|
|
| multiplier | int(10) |
|
|
|
| symbol_name | varchar(40) |
|
|
|
| company_name | varchar(40) |
|
|
|
| exchange | varchar(40) |
|
|
|
| segment | varchar(40) |
|
|
|
| expiry_date | varchar(40) |
|
|
|
| instrument_name | varchar(40) |
|
|
|
| option_type | varchar(40) |
|
|
|
| isin | varchar(40) |
|
|
|
| strike_price | bigint(20) |
|
|
|
| tick_size | int(10) |
|
|
|
| price_numerator | int(10) |
|
|
|
| price_denominator | int(10) |
|
|
|
| gen_numerator | int(10) |
|
|
|
| gen_denominator | int(10) |
|
|
|
| ui_dev_code | varchar(40) |
|
|
|
| broker_id | varchar(40) |
|
|
|
| region | varchar(40) |
|
|
|
| family_id | varchar(40) |
|
|
|
| ord_src | varchar(40) |
|
|
|
| ip_address | varchar(16) |
|
|
|
