Fee
Fees are reserved on orders and paid on trades. This table stores fee configurations & multiple Fee records are grouped in the FeeSet table. More details on fees
- Section: Products
Metadata
- Base Table Class: Static
- Default Size: FeeSet * 10 = 1000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this Fee. |
| Status | Set of Status | 4 | |
| FeeSet | Foreign key to FeeSet | 8 | This is a reference to the FeeSet table. It is keyed by the FeeSet column in this table to the Id column in the FeeSet table. |
| FeeBasis | One of FeeBasis | 1 | |
| FeeType | One of FeeType | 1 | |
| FeeCurrencyType | One of FeeCurrencyType | 1 | |
| FeeBuy | Integer (signed) | 8 | |
| FeeSell | Integer (signed) | 8 | |
| MinFeePerOrderBuy | Integer (signed) | 8 | |
| MinFeePerOrderSell | Integer (signed) | 8 | |
| FeeMaker | Integer (signed) | 8 | |
| FeeTaker | Integer (signed) | 8 | |
| MinFeePerOrderMaker | Integer (signed) | 8 | |
| MinFeePerOrderTaker | Integer (signed) | 8 | |
| MaxFeePerTradeBuy | Integer (signed) | 8 | |
| MaxFeePerTradeSell | Integer (signed) | 8 | |
| MaxFeePerTradeMaker | Integer (signed) | 8 | |
| MaxFeePerTradeTaker | Integer (signed) | 8 | |
| Market | Foreign key to Market | 8 | |
| InstrumentGroup | Foreign key to InstrumentGroup | 8 | |
| Instrument | Foreign key to Instrument | 8 | |
| InstrumentMarket | Foreign key to InstrumentMarket | 8 | |
| SettlementInstrumentGroup | Foreign key to InstrumentGroup | 8 | |
| SettlementInstrument | Foreign key to Instrument | 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. |
| OwnerUser | Foreign key to User | 8 | The Id of the User that owns this Fee. |
| OwnerGroup | Foreign key to Group | 8 | The Id of the Group that owns this Fee. |
| OwnerFirm | Foreign key to Firm | 8 | The Id of the Firm that owns this Fee. |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this Fee. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this Fee was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this Fee. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this Fee was last updated. |