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