Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 4

We are glad to announce to you our new knowledgebase. Please find actual information here https://brokerhelp.etnatrader.com/administrator-guide/glossary/transactions

DB Column Name (dbo.Transaction)Description
IdDisplays an unique identifier number of security name
FeeId

Displays an unique identifier number for Fee. A certain amount of Fee is determined by a comission plan for each client .

If the type of the transaction is OptionExpiration, Payment, ManualManipulation or Clearing, then the field will be empty

OrderStateId

Displays an unique identifier number for corresponded state of the order.

If the type of the transaction is OptionExpiration, Payment, ManualManipulation or Clearing, then the field will be empty

AccountIdDisplays an unique identifier number of user
DateDate of a transaction creation
ValueValue of your transaction. As for cash,  this parameter shows the cost of the transaction.
Descriptionif the type of transaction is Payment or ManualManipulation, then it will be shown a description of a transaction
SecurityId

Displays an unique identifier number of security name.

If the type of the transaction is Payment or ManualManipulation, then it is not using any securities and the field will be empty.

QuantityAmount of shares to buy or sell, which is indicated in the last orderstate partial

Type:

0 - Undefined,
1 - Comission,
2 - OrderExecution,
3 - OptionExpiration,
4 - Payment,
5 - ManualManipulation,
6 - Clearing,
7 - Rpl


Displays current transaction state:
0. Undefined - Not defined value. Should never be used
1. Comisssion - Comission transaction
2. OrederExecution - Order execution transaction
3. OptionExpiration - Option expiration transaction
4. Payment - Deposit or withdraw transaction
5. ManualManipulation - Manial order or position update transaction
6. Clearing - Clearing processing transaction
7. Rpl - Realized profit or loss transaction. When user (partially) closes position 2 types of transaction will be created: OrderExecution (return open position money) and Rpl (profit/loss)

 LeavesQuantity Aren't filled shares
IsDayTrade

Transaction is or isn't included in DayTrade. DayTrade is amount of day trades. Check the FINRA explanation about what day trades are. Contains number of day trades during last 5 bussines days (including current).
0 - Transaction is not an a DayTrade
1 - Transaction is an a DayTrade

 MarginValue The amount of delta of margin requirement