HoldingTransaction_change
This is an entity to record changes in the HoldingTransaction structure. It holds records that are already prepared for sending out via the market data streams (for example resolving internal shared memory indexes into external foreign key Ids)
- Section: Change Tables
Metadata
- Base Table Class: Change
- Default Size: HoldingTransaction * 2 = 2000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this HoldingTransaction. |
| 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 HoldingTransaction_change. |
| ExternalAccount | Foreign key to ExternalAccount | 8 | |
| ExternalTimestamp | Integer (unsigned) | 8 | |
| RecordId | Integer (signed) | 8 | |
| Holding | Foreign key to Holding | 8 | |
| PairedHoldingTransaction | Foreign key to HoldingTransaction | 8 | |
| Firm | Foreign key to Firm | 8 | |
| Instrument | Foreign key to Instrument | 8 | |
| Tag | String | 50 | For tagged Instruments, this is the identifier of the individual holding. |
| ExternalId | String | 30 | A place for writing the identifier of this HoldingTransaction_change at the external venue where it is managed. |
| ExternalTransactionId | String | 20 | A place for writing the identifier of the external transaction that is connected with this HoldingTransaction_change record at the external venue to which it is related. |
| QuantityDecimals | Integer (unsigned) | 1 | The number of decimal places that should be used when interpreting quantities for this HoldingTransaction_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 | |
| PrevQuantity | Integer (signed) | 8 | |
| Balance | Integer (signed) | 8 | The Balance in the Holding record after application of this Holding Transaction. |
| AvailableBalance | Integer (signed) | 8 | The AvailableBalance in the Holding record after application of this Holding Transaction. |
| AvailableToTransfer | Integer (signed) | 8 | The usesable balance in the Holding record after application of this Holding Transaction. |
| Type | One of HoldingTransactionType | 1 | |
| HoldingTransactionStatus | One of HoldingTransactionStatus | 1 | |
| ExternalStatus | String | 1024 | |
| Reason | One of HoldingTransactionReason | 1 | |
| SuspenseAccountReason | One of Result | 2 | |
| VerifyExternal | Integer (unsigned) | 1 | |
| NoParent | Integer (unsigned) | 1 | |
| ProjectId | String | 50 | The identifier of the specific project at the external register associated with this HoldingTransaction_change record. |
| Vintage | Integer (unsigned) | 4 | A year in YYYY format. |
| ProjectType | Foreign key to ProjectType | 8 | |
| Region | Foreign key to Region | 8 | |
| Country | Foreign key to Country | 8 | |
| Account | Foreign key to Account | 8 | |
| AccountName | String | 254 | |
| Trade | Foreign key to Trade | 8 | If this transaction is related to settlement of a trade, this is the particular trade to which it applies. |
| TradeSettlementType | One of TradeSettlementType | 1 | The type of trade settlement transction. |
| TradeCostsAction | One of TradeCostsAction | 1 | The action for a trade costs transaction. |
| TradeReport | Foreign key to Order | 8 | |
| BankTransaction | Foreign key to BankTransaction | 8 | |
| LinkedHoldingTransaction | Foreign key to HoldingTransaction | 8 | For a transaction resulting from a bank ACH return, this links back to the transaction generated by the original ACH request. |
| HoldingTransactionSource | One of Source | 1 | |
| HoldingTransactionMetaData | String | 2000 | |
| BankTransactionErrorMessage | String | 100 | |
| CreateMemo | String | 100 | |
| VerifyMemo | String | 100 | |
| ConfirmAfterDays | Integer (unsigned) | 2 | |
| ConfirmAfter | Integer (unsigned) | 8 | |
| DenyVoidTransaction | Integer (unsigned) | 1 | Setting this attribute to true removes the 'Void' transaction option when dealing with an Unconfirmed HoldingTransaction. It is inherited from the ExternalAccountProvider of the Instrument. |
| IsForNetting | Integer (unsigned) | 1 | |
| IsPayrollProceeds | Integer (unsigned) | 1 | |
| 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 HoldingTransaction_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 HoldingTransaction. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this HoldingTransaction was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this HoldingTransaction. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this HoldingTransaction was last updated. |