|
SlNo
|
bigint(20)
|
|
|
|
|
AccountId
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
BSEScripcode
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
NSESymbol
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
NSESeries
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
MCX_SX_EQ_Symbol
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
MCX_SX_EQ_Series
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
ISINCode
|
varchar(20)
|
utf8mb4_general_ci
|
|
|
|
Holdings_Qty
|
double(10,0)
|
|
|
|
|
ISCollateral
|
double(10,0)
|
|
|
|
|
EvaluationMethod
|
double(10,0)
|
|
|
|
|
CollateralQty
|
double(10,0)
|
|
|
|
|
Haircut
|
double(10,2)
|
|
|
|
|
CollateralUpdateQty
|
double(10,0)
|
|
|
|
|
HoldingUpdateQty
|
double(10,0)
|
|
|
|
|
CLosingPrice
|
double(10,0)
|
|
|
|
|
WithheldHoldQty
|
double(10,0)
|
|
|
|
|
WithheldCollQty
|
double(10,0)
|
|
|
|
|
Product
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
TargetProduct
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
AddOrIncr
|
varchar(10)
|
utf8mb4_general_ci
|
|
|
|
Validated
|
varchar(50)
|
utf8mb4_general_ci
|
|
|
|
ValidationText
|
varchar(500)
|
utf8mb4_general_ci
|
|
|
|
DtTime
|
datetime
|
|
|
|
|
BORefStr
|
varchar(100)
|
utf8mb4_general_ci
|
|
|
