OrderNotional
An OrderNotional is the placeholder for holding notional order entries.
- Section: Trading
Metadata
- Base Table Class: Entity
- Default Size: 1000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this OrderNotional. |
| Status | Set of Status | 4 | |
| Reference | String | 20 | The published identifier for this OrderNotional. It is a string of characters that uniquely identifies every OrderNotional in the system. |
| FirstLeg | Foreign key to OrderNotional | 8 | Link to identify the first leg of multiple legs (set) of a notional order. |
| Account | Foreign key to Account | 8 | |
| InstrumentMarket | Foreign key to InstrumentMarket | 8 | |
| OrdinalPhase | Integer (signed) | 1 | For a multi-phase Auction, this is the phase in which this Order was entered. |
| Side | One of OrderSide | 1 | Whether this is a Buy (0) or a Sell (1). |
| OrderStatus | Set of OrderStatus | 4 | |
| ValueDecimals | Integer (unsigned) | 1 | The number of decimal places that should be used when interpreting the value of this OrderNotional. Values within MarketGrid are stored and communicated as integers with fixed numbers of decimals. This field specifies how many digits are to the right of the decimal point. For example, a value of 1150000 with ValueDecimals of 2 means 11,500.00. |
| PriceDecimals | Integer (unsigned) | 1 | The number of decimal places that should be used when interpreting prices for this OrderNotional. Prices within MarketGrid are stored and communicated as integers with fixed numbers of decimals. This field specifies how many digits are to the right of the decimal point. For example, a price of 10350 with PriceDecimals set to 2 means 103.50. |
| Integer (signed) | 8 | ||
| ImpliedPrice | Integer (signed) | 8 | |
| ImpliedValue | Integer (signed) | 8 | The implied value of the company based on the no of shares multiplied by the price. |
| Value | Integer (signed) | 8 | The order value the user is willing to trade based on implied valuation of the instrumentmarket. |
| SettlementCurrency | Foreign key to Instrument | 8 | |
| BaselineOrder | Foreign key to OrderNotional | 8 | Link to identify the previous notional first leg id based on last round entering into an ascending round. |
| OriginalOrder | Foreign key to OrderNotional | 8 | Link to identify the original notional first leg id after amending multiple times. |
| UpdateNumber | Integer (unsigned) | 8 | A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record. |
| OwnerUser | Foreign key to User | 8 | The Id of the User that owns this OrderNotional. |
| OwnerGroup | Foreign key to Group | 8 | The Id of the Group that owns this OrderNotional. |
| OwnerFirm | Foreign key to Firm | 8 | The Id of the Firm that owns this OrderNotional. |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this OrderNotional. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this OrderNotional was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this OrderNotional. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this OrderNotional was last updated. |
Foreign Keys
The following diagram shows the tables that have a foreign key link to the OrderNotional table. All Table nodes can be clicked to take you to that table's definition page.
graph LR; AuctionAccount-->|OrderNotional|OrderNotional click AuctionAccount "/marketgrid/developer/model/tables/AuctionAccount" OrderNotionalQuantity-->|OrderNotional|OrderNotional click OrderNotionalQuantity "/marketgrid/developer/model/tables/OrderNotionalQuantity"