Russian Trading System (стр. 3 )

The table is available for users with the ViewAsset property and filtered by member code (firm_name). Plaza trading system creates virtual asset records with aggregated information for each account and for each security (for blocking the assets with unspecified issue code)

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).
code	t_nickname	Short code of the bank or the depositary.
acct_num	t_account	Account number.
name	t_nickname	RTS security code or settlement currency code.
i_code	t_isin	Security issue subcode (depositary code). String with 12 spaces for money assets
firm_name	t_nickname	Trading member code (according to Firm table).
active_type	t_char	Asset type: 'I' is securities, 'M' is money.
initial	t_vol_asset	Initial balance as for the trading session opening
free	t_vol_asset	Free balance.
blocked	t_vol_asset	Assets blocked by orders and unconfirmed trades.
accounts	t_code	Group code of depositary or bank account group.

4.3.  AssetIO – Data for Assets Withdrawal

The table contains history of assets inputs and withdrawal (for GTS trade mode). The table is available for users with the ViewAssetIO property and filtered by member code (firm_name).

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 the event occurring in the system.
firm_name	t_nickname	Trading member code (according to Firm table).
settl_pair	t_nickname	The PSA (client code) from which assets are withdrawn.
depo_accounts	t_code	Depositary account code of PSA.
name	t_nickname	Security code or currency code
i_code	t_isin	Security issue subcode (depositary code). String with 12 spaces for money assets
active_type	t_char	Asset type.
code	t_nickname	Code of the bank or the depositary
acct_num	t_account	Account number.
free	t_vol_asset	Volume of input/output assets.
opcode	t_char	Operation code: I is asset input, O is asset output, Z is asset withdrawal by the Clearing House
ext_id	t_reference	External user reference (id).
status	t_status	Output status: 0 means that assets in the trading system are updated (In GUI is viewed as ASS_TS), 1 means that assets in the clearing center are updated (ASS_CC), 2 is reserves for further use (updated both there and there) (ASS_TS_CC), 3 means to withdraw the said amount at any price (ASS_CC_WAC), 4 means to withdraw the said amount if the free balance allows (ASS_CC_WFB), 5 means to withdraw the said amount equal to the free balance (ASS_CC_NFB), 6 means to withdraw the said amount equal to the total balance (ASS_CC_NTB), 7 means to withdraw the said amount if possible (ASS_CC_WMC), 8 is entries over accounts (ASS_CC_DVP), 9 is hard withdrawal of money with the account deletion (ASS_CC_WCN), 10 is the account deletion (ASS_CC_DCN), 11 is the deletion of the securities issue (ASS_CC_DWI), 12 – Withdraw from Free Balance / Mild withdrawal of security without specifying the issue (ASS_CC_WFI), 14 – Delivery to FORTS (ASS_DF), 15 – Return from FORTS (ASS_RF), 16 – Withdraw/Nullify from Free Balance (ASS_CC_WNF) (Withdraw the said amount if the free balance allows, otherwise withdraw the amount equal to the free balance), 17 – Withdraw from Free Balance (ASS_CC_WF1) (“Soft” withdrawal of securities without specifying the exact issue subcode).

4.4.  Bond – Bonds

The table contains accrued coupon interest for bonds accepted for trading in the TS. Values for each security are calculated by an auxiliary server on the base of the issue parameters. The table is available for users with the ViewBond property.

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).
issueID	t_reference	Unique number of the security of the BOND type from the Issue table.
delivery_date	t	Date on which accrued coupon interest is calculated
nkd_1	t_price	Accrued coupon interest in the security currency from the Issue table.

4.5.  Firm – Information about Trading Members

The Firm table contains data about - companies-TS trading members.

All fields of the table are available for the administrators only. Non-administrator users with the ViewFirm property have access to all fields except fields ‘connect_addresses’ and ‘modified’.

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).
name	t_nickname	Code of trading member.
properties	t_text	String with the company properties
connect_addresses	t_text	TCP-address (or a range of addresses) allowed for connecting the company –member to the trading system. If there is no access to the field - then– ' '.
trade_on_off	u1	Spare.
inn	t_inn	Tax ID of the Trading Member.
full_name	t_otext	Full name of the company
phone	t_wtext	Official phone number of the company
city	t_otext	City of the company registration
create_moment	t	Member’s join moment.
modify_moment	t	Time of the last change of the company record or some company workstation.
delete_moment	t	Time of the member deactivation (null – if member still active).
deleted	t_char	Company status (' ' – the member is active, '*' – the member is deactivated).[1]
modified	t_char	The current status of the company (' ' no changes, '*' some changes occur). If the access to the field is prohibited then ' '.

4.6.  IsCode – Reference Table for Issue Codes

The table contains information about the securities issue codes (see p.4.5. Issue). The table is used to show in the GUI a more readable issue code corresponding to the security code in the depositary. If security has no issue then this table contains the code of the sole issue.

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).
issue_name	t_nickname	Security code – code of the security in the TS (corresponds to the name field in the Issue table).
i_code	t_isin	Issue subcode in the depositary.
i_code_s	t_i_c	Code of security issue for GUI.

4.7.  Issue – Information about Securities

The Issue table contains information about securities classified according to their particular group (<list>) in the TS.