Client Fee Expense Details
This section shows details of all client fee expenses for the period and can be viewed by Financial Advisors and Broker Masters only.
Note: This section appears in the Default Statement and Activity Flex Query Reference. All fields that are italicized are only populated in the Consolidated option report.
Column | Description |
---|---|
Account ID | The account number. |
Account Alias | Account alias, if there is one. |
Model | Model, if applicable. |
Currency | The currency denomination of the client fee. |
FX Rate to Base | The conversion rate from asset currency to base currency. |
Date/Time | Date and time of the fee expense. |
Revenue | Amount of commission received from the client. |
Trade ID | Trade ID. |
Exec ID | Execution ID of the transaction. |
Total Commission | The amount of commission. |
Broker Execution Charge | Broker execution fee. |
Clearing Charge | Clearing charges. |
Third-Party Execution Charge | Third-party execution fee. |
Third-Party Regulatory Charge | Third-party regulatory fee. |
Other | Other fee expenses. |
Net | Net amount received after expenses have been paid. |
Net/Base | Net amount received after expenses have been paid, converted to your base currency. |
Asset Class | The asset class of the instrument traded. |
Symbol | The symbol of the instrument traded. |
Description | The name of the instrument traded. |
Underlying Symbol | The underlying symbol of the instrument traded. |
Multiplier | Security or contract size. |
Expiration | The expiration of the contract if applicable. |
Strike | The strike price of the contract if applicable. |
Put/Call | Put or Call. |
Security ID | The security ID of the instrument traded. |
Underlying Security ID | The underlying security ID of the instrument traded. |
Settle Date | The settle date of the trade. |
Trade Price | The transaction price. |
Buy/Sell | Buy or sell. |
Quantity | The number of units traded. |
Proceeds | Calculated by multiplying the quantity and trade price. The proceeds figure will be negative for buys and positive for sells. |