Russian Trading System (стр. 10 )

Users allowed to view only several fields of this table described below.

Field	Type	Description
Id	u4	Unique identifier of the entry.
Rev	u4	Unique number of the entry change in the table (the rev value increases by 1 in case of any change of the entry).
firmID	t_reference	Unique identifier of the entry (id) from the Firm table.
firm_name	t_nickname	Short name (code) of the company – RTS member this worlstation is belongs to.
Name	t_name	User name
properties	t_text	Unavailable for users
Password	t_text	Unavailable for users
extra_pwd	t_text	Unavailable for users
Versions	t_table_name	Unavailable for users
Language_id	u1	Unavailable for users

[1] When the company break the member status or change its code, its entry will not be deleted from the database and field deleted of the entry would be filled with '*' symbol.

[2] Additional properties of the security: MUL is multiple quotes from one member are allowed. N_VIS is anonymous quotes. N_VISQ is anonymous quotes are placed on such security. Action trades on such security are not anonymous. TEST is data on such security trading are not included in the statistics. NONE - such security is excluded from trading (the sign can be changed during a trading session without the Refresh command, when it is set up – all orders for such security are withdrawn). The type of auction for initial offer: AUC_O is quick offer (open), AUC_A is a closed auction with the single price (American), AUC_E is a standard closed auction (European), AUC_M is a mixed closed auction, AUC_Y is a yield auction, AUC_PO is an auction with a single cutoff price with taking into account offers prices, AUC_P an auction with a single cutoff price without taking into account offers prices. N_NKD is for bonds with no Acquired Interest. REPO is a security sign for GTS crediting (credit in securities and money). N_TRADE is used to prohibit usual trades with such security +REPO -REPO. NOFEED –means that no information for this security translated to information agencies. S_PRICE (for auctions) means that any auction will be executed for the terms of an order placed to the system second in terms of time. HALT is a predetermined security sign, Federal Committee for Securities Market requirement to suspend trading of one security without unblocking the balance (this sign can be changed during a trading session without the Refresh command). N_PRICE is the security sign which makes it possible not to show the price in trades to members which are not trade counterparties (the sign is introduced for IPO auction), AFFIRM is a security sign for IPO – trades can be only confirmed. FD (Forts Delivery) is a security sign, which is attributed to an underlying asset for the time of delivery and which allows placement of orders to put this order in a delivery registry, UQD – UX quote-driven market, ALLOW – there is “white list” of clients for this issue, PROH – – there is “black list” of clients for this issue, KZIPO –special tender auction mode for issue, TNDRUP, TNDRDOWN – entry/editing of orders, quotes and deals with the price strictly higher or lower of nominal price in the instrument, MANCLPX – at closing session (closing_session) orders are listed with a price equal to Issue. official_close

[3] fiels is a bitmask, each bit defines allowed settlement types and other features of issue

REESTR 0xU /*........ */

DCC 0xU /*........ */

GTS 0xU /*........ */

PVD 0xU /*........ */

ALL_NON 0xU /*........ */

MARKET 0xU /*........ */

STOP_TRADE 0xU /*........ */

IPO 0xU /*........ */

I_CODE 0xU /*........ */

T_N 0xU /*........ */

CCP 0xU /*........ */

ECL 0xU /*........ */

BVT 0xU /*........ */

VEB 0xU /*........ */

MCX 0xU /*........ */

RTS 0xU /*........ */

JMP 0xU /*........ */

NBU 0xU /*........ */

AUCTION 0xU /* */

[4] BON 1 Bonds

CER 2 Representative Certificates

CPN 3 Coupons

FMT 4 Face or principal or nominal amount

MSC 5 Miscellaneous

OPC 6 Option contracts

OPS 7 Option shares

PRC 8 Premium contracts

PRS 9 Premium shares

RTE 10 Rentes

RTS 11 Rights

SHS 12 Shares Акции

UNT 13 Units, eg, consisting of a bond and a warrant

WTS 14 Warrants

REP 15

ADR 16

GDR 17

EDR 18

RDR 19 Russian depositary receipt

[5] When the security is deleted, the entry about it is not deleted from the RTS database and the entry about the security is changed. The '*' symbol is in the deleted field of this entry '

[6] Attributes of security belonging to an RTS listing (A, BOARD, BOND, BONDE, BONDG, GAZ, GTS, IPO) are mutually exclusive.

[7] The last trade on this security is the trade with the COM or ONE status for common trades, COB for trades in the GTS system and the trade_moment maximum time from the Trade table.

[8] Table “Price type enumerator”

Value	Price Type	Comments	Currency
0	-	No price check
1	best_price	Price of the day best order, which has the same direction	Issue. price_currency
2	inside_price	Price of the current best order, which has the same direction	Issue. price_currency
3	trade_price	Price of last trade of day	Issue. price_currency
4	open_price	Price of first trade of day	Issue. price_currency
5	average_price	Median price of trades of day	Issue. price_currency
6	previous_close	Close price of previous day	Issue. price_currency
7	market_price	Market price	Issue. price_currency
8	official_open	Official open price	Issue. price_currency
9	official_close	Official close price	Issue. price_currency
10	official_current	Official current price	Issue. price_currency

[9] List of existing listings defined in paragraph 4.1. This list is the subject to changes without prior notification.

[10] ‘0’ is a stop order,
‘1’ is an order in the TS, no trades for it
’3’ is in the queue with trades for it
’4’ is deleted by the system without trades (for IOC-orders – not executed)
’6’ is deleted by the system with trades (for IOC - orders – partially executed)
’8’ is deleted by the user without trades
’10’ is deleted by the user with trades
’22’ is fully executed

[11]Classical instruments means any securities (both shares and bonds) listed in “auction classic” market, “classical classic” market and indicative RTS Board market.