SecuritySold
This table holds securities sold information for each trade-option combo. It is used for reporting and not for MarketGrid processing.
- Section: CartaX
Metadata
- Base Table Class: Static
- Default Size: Trade * 2 = 2000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this SecuritySold. |
| Status | Set of Status | 4 | |
| Trade | Foreign key to Trade | 8 | Settlement transaction that applies to the Trade.Id. |
| Label | String | 48 | The long text identifier of this SecuritySold. |
| Quantity | Integer (signed) | 8 | |
| CostBasis | Integer (signed) | 8 | |
| AcquisitionDate | Integer (unsigned) | 8 | The timestamp of this record. |
| 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 SecuritySold. |
| OwnerGroup | Foreign key to Group | 8 | The Id of the Group that owns this SecuritySold. |
| OwnerFirm | Foreign key to Firm | 8 | The Id of the Firm that owns this SecuritySold. |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this SecuritySold. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this SecuritySold was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this SecuritySold. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this SecuritySold was last updated. |