Russian Trading System (стр. 9 )

When setting orders or making a transaction in the GTS a member selects a PSA which indicates from which account assets are debited and to which account they are credited.

The table is available for users who have the ViewSettlPair sign only in the PSA part of their company.

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).
firm_name	t_nickname	Short name of the member from the Firm table.
settl_pair	t_nickname	Code of the accounts pair (customer code) – PSA.
depo_code	t_nickname	Depositary short name.
depo_num	t_account	Account number in the depositary.
bank_code	t_nickname	Bank short name.
bank_num	t_account	Account number in the bank.
curr_code	t_currency	Currency code of the bank account.
depo_accounts	t_code	Depositary accounts group code
bank_accounts	t_code	Bank accounts group code.
depo_out	t_char	Sign to indicate the possibility to withdrawal securities. 'Y' means possible.
bank_out	t_char	Sign to indicate the possibility to withdraw money. 'Y' means possible.
inn	t_inn	TIN of the broker member (reference field)
buy_sell_enable	t_char	Allowed direction of assets flow ' ' – normal customer B (Buy allowed) If security has ALLOW property then such customer cannot sell this security, other except Q cannot trade this security at all S (Sell allowed) If security has ALLOW property then such customer cannot buy this security, other except Q cannot trade this security at all Q (Qual Investor) If security has ALLOW property then such customer can both buy and sell this security, other except B/S cannot trade this security at all P (Purchase prohibited) If security has PROH property then such customer cannot buy this security, other except N can do anything D (Dispose prohibited) If security has PROH property then such customer cannot sell this security, other except N can do anything N (Neither allowed) If security has PROH property then such customer cannot both buy and sell this security, other except P\D can do anything Z - customer intended for free term delivery for UX state bond market
issue_type_enabled	t_char	Allowed types of securities with ITYPCHK property for which operations from this pair may be performed: 'A' is shares (issue_type =12 or 5) 'O' is bonds (issue_type=1) ' ' is any
auction_allowed	t_char	Permission to make auction transactions (place orders in the GTS and on the anonymous classic market): 'A' is auction trades are prohibited ' ' is auction trades are allowed
night_allowed	t_char	Permission to make transactions using this settle pair : ' ' – allowed (the default value); 'N' – Prohibited
settl_type	t_char	Settle type, allowed for this Settle pair: 'G' – GTS (T+0 with full prefund) settle allowed; ' ' – classical market settle allowed
client_inn	t_inn	VAT identification number of participant’s client.

4.18.  Trade – Transactions

The Trade table contains information about transactions in the RTS classified according to the relevant listing (<list>) of the RTS. The <list> transactions table is available for users with the ViewTrade, ViewTrade-<list> properties. For example, in order to get trades by the list-A, list-INF the user should have the ViewTrade, ViewTrade-A, ViewTrade-INF. The general part of the table for the<list> listing is available for all users with the ViewTrade, ViewTrade-<list> properties. Fields of the initiator and the confirmer for trades of the own company are available for users with the additional ViewTradeReport-<list> sign.

The trade initiator has access to all the fields except: conf_memo, conf_ext_id, conf_pair, conf_type_wks.

The trade confirmer has access to all the fields except: init_memo, init_ext_id, init_pair, init_type_wks.

The general part of the table visible for other users contains all fields except: init_quoteID, init_ID, init_name, init_wks, init_memo, init_ext_id, init_pair, init_type_wks, conf_quoteID, conf_ID, conf_name, conf_wks, conf_memo, conf_ext_id, conf_pair, conf_type_wks.

Field	Type	Description
id	u4	Unique entry identifier.
rev	u4	Unique number of the entry change in the table (in case of any change the rev value is increased by 1).
type	t_char	Trade type ('Q' is a quote trade, 'B' is a bilateral address trade, 'C' is a OTC trade report, 'A' is an auction trade, 'I' is a closed auction trade (IPO)).
type_ext	t_char	'R' is REPO-trades, ' ' is common trades, 'N' is a transaction for T+N settlement on full prefund market, 'P' is pseudo-REPO trades for UX state bonds
status	t_status	Value 1 2 3 4 5 11 12 14 18 19 21 22 23 24 25 26 27 28 29 30 31 32 33	Trade status in the RTS PLAZA NEW COM VXI VXC CXL DEL ONE NEI COB BAC BAA BAX BAY NEO EOA NSI COS NEN NOM CON NEL COL	Trade status for the initiator UNC COM VXI CPC CXL DEL ONE UNI COB BAC BAA BAX BAY UNO EOM EOA USI COS UNN NOM CON UNL COL	Trade status for the confirmer ADV CAC CPI VXC CXL CLR ADI CAB BAK BAF BAZ BAH ADO EOM EOF ASI CAS AND NOM CON ADL CAL
issueID	t_reference	Unique identifier of the security entry (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
price	t_price	Price of one unit.
qty	t_size	Trading lot (number of units).
lot_volume	t_size	Spare (always 1)
volume	t_vol_asset	Trade result in the payment currency (the calculation formula is determined by the issue_type security type from the Issue table): – for shares (issue_type = SHS) volume = price * qty * payment_rate / price_rate; – for bonds (issue_type = BON) volume = (price * 0.01 * nominal + nkd_1) * qty * payment_rate / nominal_rate, the price is specified in per cent of the nominal price for bonds.
Bond
nkd_1	t_price	Accrued coupon yield 1 in the currency of the security nominal price from the Issue table.
Repo
repo_action	t_char	BS – '1' is Borrow securities. Take credit in securities. LS – '2' is Lend securities. Give credit in securities. RS – '3' is Return Secutities. Return credit in securities. AS – '4' is Accept Secutities. Accept credit in securities. BM – '5' is Borrow money. Take credit in money. LM – '6' is Lend money. Give credit in money. RM – '7' is Return Money. Return credit in money. AM – '8' is Accept Money. Accept credit in money ANY – ' ' is not set.
trade_ref	t_reference	Reference to the transaction number of a direct transaction/counter transaction.
repurchase	t_vol_asset	Amount of the offset/ New (edited) amount of the offset.
new_delivery_date	t	New (edited) date of reregistration
incl_yield	u1	For repo transactions – obligation of the securities borrower or a keeper of securities pledge to transfer the income received by them to the counteragent. It can take the following values: ’0’ means there is an obligation ’1’ means there is no obligation
rate	t_rate	In repo transactions – crediting rate expressed in annual interest in relation to the amount (price) of the first part of transaction.
new_price	t_price	In a direct repo transaction – the counter transaction price In an offset repo transaction – an edited price of the offset transaction. For shares – in RUR, for bonds – in per cent of the nominal value.
trade_moment	t	Time of the trade registration.
affirm_moment	t	Time of trade affirmation.
price_currency	t_currency	Price currency code, for example: ('RUR' is the Russian ruble, 'USD' is the US dollar, 'ERR' is the test value).
price_rate	t_rate	Price currency rate in relation to the base currency.
payment_currency	t_currency	Payment currency rate, for example: ('RUR' is the Russian ruble, 'USD' is the US dollar, 'ERR' is the test value).
payment_rate	t_rate	Payment currency rate in relation to the base currency.
Copied from the Issue at the moment of trade creation
clear	u4	Designation of the settlement type 1, 2, 3… (through the registrar, through DCC, GTS, DVP, …, T+N). See more in p.4.4 field [Issue].[type] footnote
dcc	t_code	Please refer to p.4.5
delivery_date	t	Date of the security reregistration.
Fields of the trade initiator
init_quoteID	t_reference	Unique id of the record in the Quote table for auction trades (type=’A’) only. For address and OTC trade reports (type=’B’, ‘Q’ or ‘C’) always 0. If the access to the field is prohibited then 0.
init_ID	t_reference	Trade initiator: unique identifier of the entry (id) from the Firm table. If the access to the field is prohibited then 0.
init_name	t_nickname	Name of the broker from the Firm table If the access to the field is prohibited then ' '.
init_wks	t_name	Name of the Initiator’s workstation. If the access to the field is prohibited then ' '.
init_action	t_char	Trade type ('P' is a purchase, 'S' is selling). No filtering of this field at all
init_memo	w31	Reference information (inputs by the trade Initiator). If the access to the field is prohibited then ' '.
init_ext_id	t_reference	External user reference (id).
init_pair	t_nickname	Code of the customer (SettlPair table)
init_type_wks	u1	TYPE_WKS_PLAZA_GUI - 0, TYPE_WKS_GATE – 1.
Fields of the counteragent (confirmer)
conf_quoteID	t_reference	Unique id of the record in the Quote table for auction trades (type=’A’) and trades by solid quote (type=’Q’), For address and OTC trade reports (type=’B’ or ‘C’) always 0. If the access to the field is prohibited then 0.
conf_ID	t_reference	Confirmer: unique identifier of the entry (id) from the Firm table. For OTC trade reports always 0. If the access to the field is prohibited then 0.
conf_name	t_nickname	Name of the broker from the Firm table. If the access to the field is prohibited then ' '.
conf_wks	t_name	Name of the Confirmer’s workstation (second part of login). If the access to the field is prohibited then ' '.
conf_action	t_char	Trade type ('P' is a purchase, 'S' is selling). No filtering of this field at all
conf_ memo	w31	Reference information (inputs by the trade Confirmer). If the access to the field is prohibited then ' '.
conf_ext_id	t_reference	External user reference (id).
conf_pair	t_nickname	Code of the customer (SettlPair table)
conf_type_wks	u1	TYPE_WKS_PLAZA_GUI – 0, TYPE_WKS_GATE – 1.
Code of account groups
depo_accounts	t_code	Code (name) of the depositary account
bank_accounts	t_code	Code (name) of the bank account.
Signs of Issue
visible	u1	Indicator of anonymity from the Issue table 'N_VIS' is anonymous, by default – not anonymous (the company name is visible).
vis_price	u1	Show/ not show the price in foreign trades (show – 0, Do not show – 1).
lstg	t_nickname	Listing name without the list prefix (for example: A, BOARD, BOND, BONDE, BONDG, GAZ, GTS, IPO).
market	u1	Sign of trade marketability. Can take the following values: ’0’ is the status is undefined ’1’ is a nonmarket transaction ’2’ is a market transaction

4.19.  Workstation – Data about the RTS Workstations

The Workstation table contains information about workstations (user accounts) of companies – RTS members.