TradeReport_change
- Section: Change Tables
Metadata
- Base Table Class: Change
- Default Size: Order = 1000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this TradeReport. |
| Status | Set of Status | 4 | |
| Timestamp | Integer (unsigned) | 8 | The time at which this change record was generated. This is not the same as the business-level timestamp of this TradeReport_change. |
| Reference | String | 20 | The published identifier for this TradeReport_change. It is a string of characters that uniquely identifies every TradeReport_change in the system. |
| Order | Foreign key to Order | 8 | |
| PairedOrder | Foreign key to Order | 8 | This field is used to track the paired Order on the other side of a Reported Trade. |
| InstrumentMarket | Foreign key to InstrumentMarket | 8 | |
| Tag | String | 50 | For tagged Instruments, this is the identifier of the individual holding. |
| Vintage | Integer (unsigned) | 4 | A year in YYYY format. |
| Side | One of OrderSide | 1 | Whether this is a Buy (0) or a Sell (1). |
| Type | Set of OrderType | 4 | |
| OrderStatus | Set of OrderStatus | 4 | |
| Currency | Foreign key to Instrument | 8 | |
| SettlementCurrency | Foreign key to Instrument | 8 | |
| PriceDecimals | Integer (unsigned) | 1 | The number of decimal places that should be used when interpreting prices for this TradeReport_change. 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. |
| Price | Integer (signed) | 8 | |
| QuantityDecimals | Integer (unsigned) | 1 | The number of decimal places that should be used when interpreting quantities for this TradeReport_change. Quantities 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 quantity of 12345 with QuantityDecimals set to 3 means 12.345. |
| Quantity | Integer (signed) | 8 | |
| ValueDecimals | Integer (unsigned) | 1 | The number of decimal places that should be used when interpreting the value of this TradeReport_change. 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. |
| Value | Integer (signed) | 8 | |
| SettlementValueDecimals | Integer (unsigned) | 1 | The number of decimal places that should be used when interpreting the value of this TradeReport_change. 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 SettlementValueDecimals of 2 means 11,500.00. |
| SettlementValue | Integer (signed) | 8 | |
| Account | Foreign key to Account | 8 | |
| ExpiryDate | Integer (signed) | 4 | Represents a date as an integer in YYYYMMDD format. |
| ExpiryTime | Integer (signed) | 4 | Represents time as an integer in HHMMSS format. |
| OwnerFirm | Foreign key to Firm | 8 | |
| OwnerGroup | Foreign key to Group | 8 | |
| OwnerUser | Foreign key to User | 8 | |
| 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. |
| BCSequence | Integer (unsigned) | 8 | The sequence number of this TradeReport_change message in the overall broadcast sequence. |
| Reloaded | Integer (unsigned) | 1 | Set to true for change records that are generated during a normal startup from engine cache files. |
| InstanceId | Integer (unsigned) | 4 | |
| RunId | Integer (unsigned) | 4 | |
| ChangedField | One of KVPKey | 4 | |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this TradeReport. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this TradeReport was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this TradeReport. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this TradeReport was last updated. |
Foreign Keys
The following diagram shows the tables that have a foreign key link to the TradeReport_change table. All Table nodes can be clicked to take you to that table's definition page.
graph LR; Order-->|last_TradeReport_change|TradeReport_change click Order "/marketgrid/developer/model/tables/Order"