ENUM TFirmAccess | Status: Added |
Property | New value |
Size | 1 |
Type | ekCombo |
Constant | Status | New value |
N | Added | #0, "No", "No" |
Y | Added | #1, "Yes", "Yes" |
Added | #2, "Unspecified", "Unspecified" | |
S | Added | #3, "Suspended", "=" |
TABLE CLEARING_TRADES | Status: Added |
Property | New value |
Caption | Clearing Trades |
Description | Table contains information on clearing trades (transfers) registered in the Clearing System for a trading/clearing firm since the beginning of the current session. Each Trade is represented by one row. |
Updateable | Yes |
ClearOnUpdate | No |
SystemIndex | 0 |
№ | Field | Status | Pos | Caption | Descr | Size | Type | Enum | DefVal | Key | SecCode | !NULL | VarBlock | NotSharp |
1 | CLEARINGTRADENO | Added | ||||||||||||
2 | TRADENO | Added | ||||||||||||
3 | TRADEDATE | Added | ||||||||||||
4 | TRADETIME | Added | ||||||||||||
5 | MICROSECONDS | Added | ||||||||||||
6 | BUYSELL | Added | ||||||||||||
7 | FIRMID | Added | ||||||||||||
8 | CPFIRMID | Added | ||||||||||||
9 | ACCOUNT | Added | ||||||||||||
10 | SECBOARD | Added | ||||||||||||
11 | SECCODE | Added | ||||||||||||
12 | PRICE | Added | ||||||||||||
13 | QUANTITY | Added | ||||||||||||
14 | VALUE | Added | ||||||||||||
15 | SETTLEDATE | Added | ||||||||||||
16 | SETTLECODE | Added | ||||||||||||
17 | TRADETYPE | Added | ||||||||||||
18 | COMMISSION | Added | ||||||||||||
19 | CLEARINGCENTERCOMM | Added | ||||||||||||
20 | EXCHANGECOMM | Added | ||||||||||||
21 | TRADINGSYSTEMCOMM | Added | ||||||||||||
22 | BANKACCID | Added | ||||||||||||
23 | BASEPRICE | Added | ||||||||||||
24 | CURRENCYID | Added | ||||||||||||
25 | TRANINFO | Added | ||||||||||||
26 | SETTLELIABILITYFLAG | Added | ||||||||||||
27 | CLIENTCODE | Added | ||||||||||||
28 | PARENTTRADENO | Added | ||||||||||||
29 | BANKID | Added | ||||||||||||
30 | CLEARINGBANKACCID | Added | ||||||||||||
31 | BROKERREF | Added | ||||||||||||
32 | EXTREF | Added | ||||||||||||
33 | ACCRUEDINT | Added | ||||||||||||
34 | REPOVALUE | Added | ||||||||||||
35 | ACCRUED2 | Added | ||||||||||||
36 | REPO2VALUE | Added | ||||||||||||
37 | REPOTERM | Added | ||||||||||||
38 | STATUS | Added | ||||||||||||
39 | FACEAMOUNT | Added | ||||||||||||
40 | CLEARINGTRDACCID | Added |
OUT CLEARING_TRADES.CLEARINGTRADENO | Status: Added |
Property | New value |
Caption | Clearing trade No |
Description | Trade number in the Clearing System |
Size | 21 |
Type | INTEGER |
Key | Yes |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.TRADENO | Status: Added |
Property | New value |
Caption | Trade number |
Description | Trade number in the Trading System |
Size | 12 |
Type | INTEGER |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.TRADEDATE | Status: Added |
Property | New value |
Caption | Date |
Size | 8 |
Type | DATE |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.TRADETIME | Status: Added |
Property | New value |
Caption | Time |
Size | 6 |
Type | TIME |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.MICROSECONDS | Status: Added |
Property | New value |
Caption | Microseconds |
Size | 6 |
Type | INTEGER |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.BUYSELL | Status: Added |
Property | New value |
Caption | Direction |
Description | Order direction - "Buy / Sell" |
Size | 1 |
Type | CHAR |
Enum | TBuySell |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.FIRMID | Status: Added |
Property | New value |
Caption | Firm |
Description | ID of the trading firm on whose behalf the trade is registered |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.CPFIRMID | Status: Added |
Property | New value |
Caption | Counterparty |
Description | Counterparty firm |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.ACCOUNT | Status: Added |
Property | New value |
Caption | Trading account |
Description | Trading account |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.SECBOARD | Status: Added |
Property | New value |
Caption | Board |
Description | Board ID for the security |
Size | 4 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.SECCODE | Status: Added |
Property | New value |
Caption | Security |
Description | Security ID |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | Yes |
NotSharp | No |
OUT CLEARING_TRADES.PRICE | Status: Added |
Property | New value |
Size | 10 |
Type | FLOAT |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.QUANTITY | Status: Added |
Property | New value |
Caption | Lots |
Description | Trade volume, expressed in lots |
Size | 16 |
Type | INTEGER |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.VALUE | Status: Added |
Property | New value |
Caption | Value |
Description | Trade value, expressed in the currency of settlement |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.SETTLEDATE | Status: Added |
Property | New value |
Caption | Settlement date |
Description | Trade settlement date |
Size | 8 |
Type | DATE |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.SETTLECODE | Status: Added |
Property | New value |
Caption | Settlement code |
Description | Settlement code for the trade |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.TRADETYPE | Status: Added |
Property | New value |
Caption | Type |
Description | Trade type |
Size | 1 |
Type | CHAR |
Enum | TTradeType |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.COMMISSION | Status: Added |
Property | New value |
Caption | Total commission |
Description | Trade commission, rub. |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.CLEARINGCENTERCOMM | Status: Added |
Property | New value |
Caption | Clearing commission |
Description | Clearing commission, rub. |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.EXCHANGECOMM | Status: Added |
Property | New value |
Caption | Exchange commission |
Description | Exchange commission, rub. |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.TRADINGSYSTEMCOMM | Status: Added |
Property | New value |
Caption | Technical access commission |
Description | Technical access commission, rub. |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.BANKACCID | Status: Added |
Property | New value |
Caption | Bank account |
Description | Settlement account/code ID in the settlement house |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.BASEPRICE | Status: Added |
Property | New value |
Caption | Base price |
Description | Base price could be specified for SWAP negdeals |
Size | 10 |
Type | FLOAT |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.CURRENCYID | Status: Added |
Property | New value |
Caption | Settlement currency |
Description | Settlement currency |
Size | 4 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.TRANINFO | Status: Added |
Property | New value |
Caption | Transfer details |
Size | 210 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.SETTLELIABILITYFLAG | Status: Added |
Property | New value |
Caption | Liability settlement trade |
Description | Trade of liability settlement between Clearing and Trading Members |
Size | 1 |
Type | CHAR |
Enum | TTradeSettleLiabilityFlag |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.CLIENTCODE | Status: Added |
Property | New value |
Caption | Client code |
Description | Client code assigned by the broker |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.PARENTTRADENO | Status: Added |
Property | New value |
Caption | Parent trade |
Description | Parent trade number in the Trading System for REPO trades |
Size | 12 |
Type | INTEGER |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.BANKID | Status: Added |
Property | New value |
Caption | Settlement organization |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.CLEARINGBANKACCID | Status: Added |
Property | New value |
Caption | Clearing bank account |
Description | Clearing account ID in the settlement house |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.BROKERREF | Status: Added |
Property | New value |
Caption | Broker reference |
Description | Additional information entered by the trading firm (usually - client instruction number) |
Size | 20 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.EXTREF | Status: Added |
Property | New value |
Caption | External user ID |
Description | A reference field which may be used as a back-feed by an external system. May contain, for example, a user ID of the external system user who entered the original order into that external system. |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.ACCRUEDINT | Status: Added |
Property | New value |
Caption | Value of accrued interest |
Description | Accrued interest, expressed in the currency of settlement |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.REPOVALUE | Status: Added |
Property | New value |
Caption | REPO value |
Description | REPO value calculated in the currency of settlement for the current date |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.ACCRUED2 | Status: Added |
Property | New value |
Caption | Accrued interest for the buy-back |
Description | Accrued interest on the buy-back date, expressed in the currency of settlement |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.REPO2VALUE | Status: Added |
Property | New value |
Caption | REPO buy-back value |
Description | Value of the 2nd (buy-back) REPO leg, expressed in the currency of settlement |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.REPOTERM | Status: Added |
Property | New value |
Caption | REPO term |
Description | REPO term expressed in calendar days. The term starts on the next day after the first REPO leg settlement and ends on the day of the second REPO leg settlement inclusive. |
Size | 4 |
Type | INTEGER |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.STATUS | Status: Added |
Property | New value |
Caption | Status |
Description | Trade status |
Size | 1 |
Type | CHAR |
Enum | TTradeStatus |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.FACEAMOUNT | Status: Added |
Property | New value |
Caption | FaceAmount |
Description | Value of trade by face value, expressed in the currency of settlement |
Size | 16.2 |
Type | FIXED |
Key | No |
SecCode | No |
NotSharp | No |
OUT CLEARING_TRADES.CLEARINGTRDACCID | Status: Added |
Property | New value |
Caption | Clearing account |
Description | Clearing account number |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
TABLE FIRMS | Status: Modified |
№ | Field | Status | Pos | Caption | Descr | Size | Type | Enum | DefVal | Key | SecCode | !NULL | VarBlock | NotSharp |
1 | CLEARINGACCESS | Added | ||||||||||||
2 | TRADINGACCESS | Added |
OUT FIRMS.CLEARINGACCESS | Status: Added |
Property | New value |
Caption | Clearing access |
Size | 1 |
Type | CHAR |
Enum | TFirmAccess |
Key | No |
SecCode | No |
NotSharp | No |
OUT FIRMS.TRADINGACCESS | Status: Added |
Property | New value |
Caption | Trading access |
Size | 1 |
Type | CHAR |
Enum | TFirmAccess |
Key | No |
SecCode | No |
NotSharp | No |
TABLE SECACCINT | Status: Modified |
№ | Field | Status | Pos | Caption | Descr | Size | Type | Enum | DefVal | Key | SecCode | !NULL | VarBlock | NotSharp |
1 | FACEUNITFLAG | Added |
IN SECACCINT.FACEUNITFLAG | Status: Added |
Property | New value |
Caption | AccInt in FaceUnit |
Description | Accured interest in face unit currency |
Size | 1 |
Type | CHAR |
Enum | TYesNo |
NOT NULL | No |
VarBlock | No |
TABLE SECURITIES | Status: Modified |
№ | Field | Status | Pos | Caption | Descr | Size | Type | Enum | DefVal | Key | SecCode | !NULL | VarBlock | NotSharp |
1 | ISIN | Added |
OUT SECURITIES.ISIN | Status: Added |
Property | New value |
Caption | ISIN |
Description | ISIN code |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |
TABLE USERS | Status: Modified |
№ | Field | Status | Pos | Caption | Descr | Size | Type | Enum | DefVal | Key | SecCode | !NULL | VarBlock | NotSharp |
1 | CLIENTCODE | Deleted |
OUT USERS.CLIENTCODE | Status: Deleted |
Property | Previous value |
Caption | Client code |
Description | Client code assigned by the broker and linked to this User ID |
Size | 12 |
Type | CHAR |
Key | No |
SecCode | No |
NotSharp | No |