Level3_change

Metadata

  • Base Table Class: Change
  • Not in MDB
  • Default Size: Order_change = 4000

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this Level3.
StatusSet of Status4
TimestampInteger (unsigned)8The time at which this change record was generated. This is not the same as the business-level timestamp of this Level3_change.
OrderForeign key to Order8
OriginalIdForeign key to Order8
ExternalAccountProviderForeign key to ExternalAccountProvider8
InstrumentMarketForeign key to InstrumentMarket8
InstrumentForeign key to Instrument8
MarketForeign key to Market8
PriceDecimalsInteger (unsigned)1The number of decimal places that should be used when interpreting prices for this Level3_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.
QuantityDecimalsInteger (unsigned)1The number of decimal places that should be used when interpreting quantities for this Level3_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.
TagString50For tagged Instruments, this is the identifier of the individual holding.
SettlementClassForeign key to SettlementClass8
ExternalTransactionIdString20A place for writing the identifier of the external transaction that is connected with this Level3_change record at the external venue to which it is related.
SecurityLotLabelString20
SecurityLotIdInteger (unsigned)8
PriorityInteger (unsigned)2
ExternalIdString30A place for writing the identifier of this Level3_change at the external venue where it is managed.
CurrencyForeign key to Instrument8
SideOne of OrderSide1Whether this is a Buy (0) or a Sell (1).
OrderTypeSet of OrderType4
OrderStatusSet of OrderStatus4
PriceInteger (signed)8The current Price for this Level3_change instance.
QuantityInteger (signed)8
ProjectIdString50The identifier of the specific project at the external register associated with this Level3_change record.
VintageFromInteger (unsigned)4A year in YYYY format.
VintageToInteger (unsigned)4A year in YYYY format.
ProjectTypeForeign key to ProjectType8
RegionForeign key to Region8
CountryForeign key to Country8
OrderInfoString140Represents some supplementary free text information associated with this Level3_change record.
WriteBackInteger (unsigned)1
ReferenceString20The published identifier for this Level3_change. It is a string of characters that uniquely identifies every Level3_change in the system.
ParentIdForeign key to Order8
MinimumFillInteger (signed)8
UpdateNumberInteger (unsigned)8A 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.
BCSequenceInteger (unsigned)8The sequence number of this Level3_change message in the overall broadcast sequence.
ReloadedInteger (unsigned)1Set to true for change records that are generated during a normal startup from engine cache files.
InstanceIdInteger (unsigned)4
RunIdInteger (unsigned)4
ChangedFieldOne of KVPKey4
CreateUserForeign key to User8The Id of the User that created this Level3.
CreateTimestampInteger (unsigned)8The time at which this Level3 was created.
UpdateUserForeign key to User8The Id of the User that last updated this Level3.
UpdateTimestampInteger (unsigned)8The time at which this Level3 was last updated.