| entity_id | varchar(40) |
|
|
|
| profile_name | varchar(40) |
|
|
|
| segment | varchar(40) |
|
|
|
| exch_seg | varchar(40) |
|
|
|
| product | varchar(40) |
|
|
|
| family_risk | int(10) |
|
|
|
| cash | double(40,4) |
|
|
|
| turnover_limit | double(40,4) |
|
|
|
| pending_order_limit | double(40,4) |
|
|
|
| noren_time_stamp | bigint(20) |
|
|
|
| noren_nsecs | bigint(20) |
|
|
|
| src_user_id | varchar(40) |
|
|
|
| src_broker_id | varchar(40) |
|
|
|
| payin | double(20,4) |
|
|
|
| payout | double(20,4) |
|
|
|
| daylong_cash | double(20,4) |
|
|
|
| uncleared_cash | double(20,4) |
|
|
|
| broker_collateral | double(20,4) |
|
|
|
| brokerage_perc_eq_margin | double(20,4) |
|
|
|
| brokerage_perc_eq_intraday | double(20,4) |
|
|
|
| brokerage_perc_eq_cac | double(20,4) |
|
|
|
| brokerage_perc_eq_hl | double(20,4) |
|
|
|
| brokerage_perc_eq_bo | double(20,4) |
|
|
|
| brokerage_perc_der_margin | double(20,4) |
|
|
|
| brokerage_perc_der_intraday | double(20,4) |
|
|
|
| brokerage_perc_der_hl | double(20,4) |
|
|
|
| brokerage_perc_der_bo | double(20,4) |
|
|
|
| brokerage_perc_fx_margin | double(20,4) |
|
|
|
| brokerage_perc_fx_intraday | double(20,4) |
|
|
|
| brokerage_perc_fx_hl | double(20,4) |
|
|
|
| brokerage_perc_fx_bo | double(20,4) |
|
|
|
| brokerage_perc_com_margin | double(20,4) |
|
|
|
| brokerage_perc_com_intraday | double(20,4) |
|
|
|
| brokerage_perc_com_hl | double(20,4) |
|
|
|
| brokerage_perc_com_bo | double(20,4) |
|
|
|
| brokerage_flat_perc | double(20,4) |
|
|
|
| from_segment | varchar(40) |
|
|
|
| from_exch_seg | varchar(40) |
|
|
|
| from_product | varchar(40) |
|
|
|
| aux_daylong_cash | double(20,4) |
|
|
|
| aux_uncleared_cash | double(20,4) |
|
|
|
| aux_broker_collateral | double(20,4) |
|
|
|
