|
CLIENTCODE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
CLIENTNAME
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
|
SCRIPCODE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
SCRIPNAME
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
BUYDATE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
BUYDATEFORDAYS
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
ISINCODE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
BUYQUANTITY
|
bigint(20)
|
|
|
|
|
BUYNETRATE
|
double(16,2)
|
|
|
|
|
CUTOFFRATE
|
double(16,2)
|
|
|
|
|
BOUGHTAMT
|
double(16,2)
|
|
|
|
|
SELLDATE
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
SELLDATEFORDAYS
|
varchar(45)
|
utf8mb4_general_ci
|
|
|
|
SELLQUANTITY
|
bigint(20)
|
|
|
|
|
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)
|
|
|
|
|
SPECPRLO
|
double(16,2)
|
|
|
|
|
ERRORFLAG
|
bigint(20)
|
|
|
|
|
STOCKQUANTITY
|
bigint(20)
|
|
|
|
|
BOUGHTQTY
|
bigint(20)
|
|
|
|
|
SOLDQTY
|
bigint(20)
|
|
|
|
|
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)
|
|
|
|
