| CLIENTCODE | varchar(45) |
|
|
|
| CLIENTNAME | varchar(100) |
|
|
|
| SCRIPCODE | varchar(45) |
|
|
|
| SCRIPNAME | varchar(45) |
|
|
|
| BUYDATE | varchar(45) |
|
|
|
| BUYDATEFORDAYS | varchar(45) |
|
|
|
| ISINCODE | varchar(45) |
|
|
|
| BUYQUANTITY | bigint(20) unsigned |
|
|
|
| BUYNETRATE | double(16,2) |
|
|
|
| CUTOFFRATE | double(16,2) |
|
|
|
| BOUGHTAMT | double(16,2) |
|
|
|
| SELLDATE | varchar(45) |
|
|
|
| SELLDATEFORDAYS | varchar(45) |
|
|
|
| SELLQUANTITY | bigint(20) unsigned |
|
|
|
| SELLNETRATE | double(16,2) |
|
|
|
| SALESAMT | double(16,2) |
|
|
|
| CHARGES | double(16,2) |
|
|
|
| SHORTPRLO | double(16,2) |
|
|
|
| LONGPRLO | double(16,2) |
|
|
|
| CUTOFFLONGPRLO | double(16,2) |
|
|
|
| NOOFDAYS | bigint(20) unsigned |
|
|
|
| SPECPRLO | double(16,2) |
|
|
|
| ERRORFLAG | bigint(20) unsigned |
|
|
|
| STOCKQUANTITY | bigint(20) unsigned |
|
|
|
| BOUGHTQTY | bigint(20) unsigned |
|
|
|
| SOLDQTY | bigint(20) unsigned |
|
|
|
| BOUGHTAMOUNT | double(16,2) |
|
|
|
| SOLDAMOUNT | double(16,2) |
|
|
|
| SHORTPRLOTOTAL | double(16,2) |
|
|
|
| LONGPRLOTOTAL | double(16,2) |
|
|
|
| CUTOFFLONGPRLOTOTAL | double(16,2) |
|
|
|
| SPECPRLOTOTAL | double(16,2) |
|
|
|
| GLOBALSHRTBOUGHTAMOUNT | double(16,2) |
|
|
|
| GLOBALSHRTSOLDAMOUNT | double(16,2) |
|
|
|
| GLOBALLONGBOUGHTAMOUNT | double(16,2) |
|
|
|
| GLOBALLONGSOLDAMOUNT | double(16,2) |
|
|
|
| GLOBALSPECBOUGHTAMOUNT | double(16,2) |
|
|
|
| GLOBALSPECSOLDAMOUNT | double(16,2) |
|
|
|
| GLOBALSHORTPRLOTOTAL | double(16,2) |
|
|
|
| GLOBALLONGPRLOTOTAL | double(16,2) |
|
|
|
| GLOBALCUTOFFLONGPRLOTOTAL | double(16,2) |
|
|
|
| GLOBALSPECPRLOTOTAL | double(16,2) |
|
|
|
| OSPURCHQTY | double(16,2) |
|
|
|
| OSSALESQTY | double(16,2) |
|
|
|
| OSPURCHVALUE | double(16,2) |
|
|
|
| OSSALESVALUE | double(16,2) |
|
|
|
