| |
|
|
Valid Indexes in
Commex :-
|
S.No |
Index Name |
Index Column |
Table Name |
|
|
|
|
|
|
1 |
BILLFILE_IDX |
CLIENTCD |
BILLFILE |
|
|
|
SCRIPCD |
|
|
|
|
SETTNO |
|
|
|
|
|
|
|
2 |
BILLFILE_IDX1 |
CONTROLNO |
BILLFILE |
|
3 |
BILLFILE_IDX2 |
BILLNO |
BILLFILE |
|
4 |
BILLFILE_IDX3 |
CLIENTCD |
BILLFILE |
|
|
|
SETTNO |
|
|
5 |
BILLFILE_IDX4 |
SETTNO |
BILLFILE |
|
|
|
|
|
|
6 |
BILLNOFILE_IDX |
BILLDATE |
BILLNOFILE |
|
|
|
BILLTYPE |
|
|
|
|
|
|
|
7 |
BRANCHFILE_IDX |
USERID |
BRANCHFILE |
|
|
|
|
|
|
8 |
CLGRATE_IDX |
CLG_SETTNO |
CLGRATE |
|
|
|
CLG_SCRIPCD |
|
|
|
|
|
|
|
9 |
COBROKSLAB_IDX |
SLB_CLIENTCD |
COBROKSLAB |
|
|
|
SLB_BROKTYPE |
|
|
|
|
SLB_INSTRUMENT |
|
|
|
|
SLB_SYMBOL |
|
|
|
|
SLBFROM |
|
|
|
|
SLBTO |
|
|
|
|
|
|
|
10 |
CODAILYPRICE_IDX |
WDATE |
CODAILYPRICE |
|
|
|
CONTNAME |
|
|
|
|
EXPIRYDATE |
|
|
|
|
|
|
|
11 |
COTRNMAST_IDX |
CLIENTCODE |
COTRNMAST |
|
|
|
EXPIRYDATE |
|
|
|
|
|
|
|
12 |
COTRNMAST_IDX1 |
CLIENTCODE |
COTRNMAST |
|
|
|
TRADE_DATE |
|
|
|
|
SECURITYNAME |
|
|
|
|
EXPIRYDATE |
|
|
|
|
|
|
|
13 |
COTRNMAST_IDX2 |
CLIENTCODE |
COTRNMAST |
|
|
|
SECURITYNAME |
|
|
|
|
OPTIONTYPE |
|
|
|
|
|
|
|
14 |
COTRNMAST_IDX3 |
ORDERNO |
COTRNMAST |
|
|
|
TRADENO |
|
|
|
|
|
|
|
15 |
DEMATLGR_IDX |
DPCODE |
DEMATLGR |
|
|
|
|
|
|
16 |
DEMATLGR_IDX1 |
CLIENTCD |
DEMATLGR |
|
|
|
|
|
|
17 |
DEMATLGR_IDX2 |
DDATE |
DEMATLGR |
|
|
|
SETTNO |
|
|
|
|
|
|
|
18 |
DEMATLGR_IDX3 |
SETTNO |
DEMATLGR |
|
|
|
|
|
|
19 |
DEMATLGR_IDX4 |
SCRIPCD |
DEMATLGR |
|
|
|
|
|
|
20 |
DEMATLGR_IDX5 |
CONTROLNO |
DEMATLGR |
|
|
|
|
|
|
21 |
LCOTRNMAST_IDX |
TRADENO |
LCOTRNMAST |
|
|
|
TRADESTATUS |
|
|
|
|
|
|
|
22 |
LCOTRNMAST_IDX1 |
CLIENTCODE |
LCOTRNMAST |
|
|
|
|
|
|
23 |
LCOTRNMAST_IDX2 |
ORGCLIENTID |
LCOTRNMAST |
|
|
|
|
|
|
24 |
LCOTRNMAST_IDX3 |
TRADESTATUS |
|
