Russian Trading System (стр. 6 )

Field	Type	Description
id	u4	Unique identifier of the entry.
rev	u4	Unique number of the entry change in the table (in case of any change the rev value is increased by 1).
moment	t	Time of placing or changing the quote (order).
type	t_char	Quote (order) direction ('А' is sell, 'В' is buy).
issueID	t_reference	Unique identifier of security (id from the Issue table).
issue_name	t_nickname	Short name of the security in the RTS.
i_code	t_isin	Code of the security issue
firmID	t_reference	Unique identifier of the entry (id) from the Firm table.
firm_name	t_nickname	Short name of the company.
wks	t_name	Workstation name.
price	t_price	Price of the current quote.
qty	t_size	Size of the trading lot.
res_qty	t_size	Reserved (hidden) size of the trading lot
init_qty	t_size	Field value is equal to the total of the qty and res_qty fields. It is filled with the core at the moment of the order placement.
paycond	t_paycond	Transaction settlement terms ('B' – RUB, 'S' – USD, 'J' – means any currency allowed in this listing)
dcc	t_code	Please refer to p.4.5
delivery_days	u1	Number of days for reregistration of securities.
change	t_char	Direction of the quote price change ('U' is up, 'D' is down, ' ' means that the new value is equal to the previous one).
memo	w31	Reference information (viewed only for quotes of the own company).
ext_id	t_reference	External user reference (id).
settl_pair	t_nickname	Code of the pair of settlement accounts (bank + depositary).
inn	t_inn	TIN of the user from the SettlPair table
depo_accounts	t_code	Code (name) of the depositary account group security belongs to.
bank_accounts	t_code	Code (name) of the bank account group.
visible	u1	Indicator of anonymity from the Issue table 'N_VIS' or ‘N_VISQ’ is anonymous, by default – not anonymous (the company name is visible).
lstg	t_nickname	Listing name (without the list prefix i. e. A, BOARD, BOND, BONDE, BONDG, GAZ, GTS, IPO) from the Issue table.
ipo	u1	Sign of initial offer: IPO > 1, other is 0. Indication of the auction type for initial offer: 1 is a quick auction (open), 2 is a closed auction with a single price (American), 3 is a standard closed auction (European), 4 is a mixed closed auction.
quote_order	u1	Sign, which specifies the order type: quote is 0, order is 1, order on the classic anonymous market is 2.
order_type	u1	Types of order 0 is market, 1 is limited, 2 – closing session (orders with the “closing_session” indication, which are traded at the weighted average price are allowed during a set time for the after trading session.
catalyst	u1	Current status of the order: 1 is active, 0 is passive.
all_non	u1	Sign for order execution. Can take the following values: 1 means all or none, 0 means partial execution is possible.
act_price	t_price	Order activation price.
max_asset	t_vol_asset	For calculation of the blocked assets for a market order.
leave	u2	Order validity. Can take the following values: 0  means the order will be processed immediately, 1 means the order will be stored for 1 day, 65000  means that the order will be stored for an unlimited period of time but until it is withdrawn from trading by the customer.
nkd_1	t_price	Acquired Interest for the bond in the currency of the nominal price of the security from the Issue table.
yield	t_sprice	Yield for the bond in percents.
type_wks	u1	For statistics: TYPE_WKS_PLAZA_GUI – 0, TYPE_WKS_GATE – 1.
mm	t_mm	Common orders (MM_0-0). Orders from the MM GUI (MM_1-1, MM_2-2, MM_3-3).
e_s	u1	The flag shows if the order will remain in the system on the evening trading session: '1' – the order remains for the evening trading; '0' – the order not remains for the evening trading
status	u1	Status of order. Please refer to p.4.5
history_id	u4	Unique identifier of the entry from the Quote table.
history_event	u4	Unique identifier of the entry from the Event table.
history_moment	t	Time of quote placement, change, deletion.
history_action	t_char	Symbol of the operation performed with the quote: ‘U’pdate, ‘D’elete, ‘A’dd.

4.13.  Registry – General References

The Registry table contains the trading system and statistic data settings.

All the table fields are available only for the administrators. Users with the ViewRegistry sign have access to the rows with the 'C' (Common) value in the area field.

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).
section	t_name	Section name (contains the name of the section to which the corresponding parameter belongs).
item_name	t_name	Parameter name.
item_value	t_wtext	Parameter value.
area	t_char	Parameter of access to the entry. It can take one of two values: ('P' is Private, 'C' is Common).

The Registry sections, which have the ‘C’ value in the area field:

bl_base_currency is the basic currency of the trading system;

bl_digits_in_row is the default number of valid digits in the price –when a new security is created; 

bl_group_accounts_B is setting of group codes of bank accounts. The group code is set in the item_name field, the value field is used to set the trading activity: 1 – trading is open, <>1 – trading is closed;
bl_group_accounts_D is setting of depositary accounts group codes. The item_name field is used to set the group code, the value field is used to set the trading activity of the group: 1 – trading is open, <>1 – trading is closed;
bl_news is setting of indications of news sources and the time of their storing in the trading system database;
bl_rate is the value of the RF Central Bank exchange rate (RUR for USD) as of the next day (introduced after the official message at 12:30);
bl_status_system is the indication of the trading sessions statuses in the trading system and the GTS subsystem;
list-<listing code> is setting of trading conditions for the relevant securities groups (aka listing). The item_name and value parameters have the following value pairs:

-  item_name=t_quote – the value parameter contains the time of beginning and end of the period of placing orders for a securities group;

-  item_name=t_ccp_quote – the value parameter contains the time of beginning and end of the period of placing orders with CCP for a securities group;

-  item_name=t_trade – the value parameter contains the time of beginning and end of the period of placing addressed orders for a securities group;

-  item_name=t_ccp_trade – the value parameter contains the time of beginning and end of the period of placing addressed CCP orders for a securities group;

-  item_name=t_auction – the value parameter contains the time of beginning and end of the period of an auction for a securities group;

-  item_name=t_rules – the value parameter contains the time of beginning and end of the period of settlement of official statistics for a securities group;

-  item_name=t_bq – the value parameter contains the time of beginning and end of the period when transactions by the quote are allowed (only for the OTC market) for a security group;

-  item_name=trade_allow – the value parameter contains codes which indicate what transactions are allowed in this group. A is for auction, B is for addressed, Q is for quoted, I is for initial offer transactions

-  item_name=day_currency – the value parameter contains the code of the currency which is used for the calculation of a total monetary trading volume for a group.

-  item_name=day_volume – the value parameter contains the total monetary trading volume for a group in the currency indicated in the “trade_currency”

-  item_name=NoSameFirm – if setting is ON (value ='on' ) there are prohibition of address and auction trades when seller and buyer are the same broker