Transactions_Snapshot
- Tanmai Sharma (Unlicensed)
Owned by Tanmai Sharma (Unlicensed)
Jul 03, 2019
1 min read
Loading data...
This table contains the flash_blotter with a mark_to_market for the latest date
| Column Name | Data Type | Description | Additional Links |
|---|---|---|---|
| flash_blotter_id | integer | Not in use | |
| blotter_id | integer | Not in use | |
| flash_blotter_type | text | Not in use | |
| ticketref | text | ||
| traded_on | timestamp | ||
| settled_on | date | ||
| ticker | text | ||
| quantity | numeric | ||
| trade_price | double precision | ||
| trade_date_dirty_px | double precision | ||
| trade_type | text | Canopy trade type: Buy, Sell, Distribution, Contribution etc | |
| ticket_created_at | timestamp | Not in use | |
| ticket_updated_at | timestamp | Not in use | |
| price_updated_at | timestamp | Not in use | |
| security_name | text | ||
| custodian_name | text | ||
| parent_username | text | ||
| child_username | text | ||
| child_displayname | text | ||
| contract_id | integer | Not in use | |
| contract_currency | text | ||
| ccy_account_code | text | ||
| contract_type | text | Based on Asset Class | |
| counterparty_id | integer | Not in use | |
| parent_user_id | integer | Not in use | |
| user_id | integer | Not in use | |
| user_account_id | integer | Not in use | |
| strategy_tag_id | integer | Not in use | |
| transaction_type_id | integer | Not in use | |
| security_id | integer | Not in use | |
| related_security_id | integer | Not in use | |
| tags | jsonb | .json file that contains more information.to extract the information that are inside this .json file, use the custom sql query in tableau - | |
| user_asset_class | text | ||
| user_geography | text | List of Geographical Classifications | http://mesitis.atlassian.net/wiki/spaces/HOW/pages/370540613/List+of+Geographical+Classifications |
| user_industry | text | ||
| canopy_asset_class | text | Canopy Asset Classes | http://mesitis.atlassian.net/wiki/spaces/HOW/pages/368836759/Canopy+Asset+Classes |
| bb_composite_rating | text | Not in use | |
| em_dm | text | Not in use | |
| canopy_geography | text | Not in use | |
| day_1_notional_trade_ccy | numeric | Cash: blotters.settlement_amt_ccy Security: 1. Non-Mtm: blotters.quantity 2. Others: blotters.quantity * (day_1_price_close or 1.0) | |
| day_1_mtm_trade_ccy | numeric | Cash: 0.0 Security: 1. Derivative/Non-Mtm: 0.0 2. Others: blotters.quantity * (day_1_price_close of 1.0) - (blotters.trade_date_dirty_px or blotters.trade_price) | |
| day_1_price_close | numeric | close price on trade date | |
| day_1_price_clean | numeric | clean price on trade date | |
| day_1_fxrate_trade_ccy | numeric | day 1 fx rate against USD | |
| day_1_mtm_usd | numeric | day_1_mtm_trade_ccy in USD | |
| day_1_notional_usd | numeric | day_1_notional_trade_ccy in USD | |
| date | date | ||
| latest_price_close | numeric | latest available close price | |
| latest_price_clean | numeric | latest available clean price | |
| latest_fx_contract_ccy | numeric | latest available contract fxrate against USD | |
| multiplier | numeric | Not In Use | |
| multiplier_x_price | numeric | Not In Use | |
| market_value_usd | numeric | market value in usd | |
| mtm_total_usd | numeric | Profit of the transaction (Market Value - Entry Value) Market Value - Settlement Amount (Gross Amount for TransferfOP) | |
| mtm_price_usd | numeric | The change in MTM only attributable to price movement (prices.close - blotters.trade_price)* flashblotters.quantity | |
| mtm_accrued_usd | numeric | The change in MTM only attributable to FX movement Total - Price - Accrued | |
| mtm_fx_usd | numeric | The change in MTM only attributable to accrued interest (prices.close - prices.clean) - (blotters.trade_date_dirty_px - blotters.trade_price) * flashblotters.quantity |