Flash_Blotter (deprecated)
- Tanmai Sharma (Unlicensed)
- Niranjan Rajendran (Unlicensed)
Owned by Tanmai Sharma (Unlicensed)
| Column | Data Type | Description | Additional Links |
|---|---|---|---|
| flash_blotter_id | integer | unique flash blotter id (common field with fbmvh) | |
| blotter_id | integer | related blotter id (common field with blotters and fbmvh) | |
| flash_blotter_type | text | cash or security type | |
| ticketref | text | ticket reference of transactions | |
| traded_on | date | Trade Date of the transaction | |
| settled_on | date | The date on which the transaction was settled or settlement date | |
| ticker | text | ||
| isin | text | ||
| quantity | numeric | quantity of security in transaction | |
| trade_price | numeric | traded price | |
| trade_date_dirty_px | numeric | dirty price of trade if any (for bonds) | |
| trade_type | text | type transaction | |
| ticket_created_at | date | ||
| ticket_updated_at | date | ||
| price_updated_at | date | ||
| security_name | text | ||
| custodian_name | text | ||
| parent_username | text | ||
| child_username | text | ||
| parent_display_name | text | ||
| child_display_name | text | ||
| contract_id | integer | id of contract | |
| contract_currency | text | ||
| contract _currency_id | integer | ||
| ccy_account_code | text | ||
| contract _type | text | one of the 7 contract types (non mtm, equity, bond, fund, insurance, real estate, others) | |
| user_id | integer | account id | |
| user_account_id | integer | ccy account id | |
| strategy_tag_id | integer | based on transaction type and asset class | |
| transaction_id | null | not in use | |
| transaction_type_id | integer | ||
| security_id | integer | ||
| related_security_id | integer | id for related security ticker for transaction types (Distribution, Contribution, Interest, Loan Cost) for cash payments | |
| related_security_ticker | text | for transaction types (Distribution, Contribution, Interest, Loan Cost) for cash payments | |
| related_security_name | text | name for related security | |
| user_asset_class | text | user defined asset class | |
| user_geography | text | user defined geography | |
| user_industry | text | user defined industry | |
| canopy_asset_class | text | canopy defined asset class | https://mesitis.atlassian.net/wiki/spaces/HOW/pages/368836759/Canopy+Asset+Classes |
| bb_composite_rating | null | not in use | |
| em_dm | null | not in use | |
| canopy_geography | null | 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 | NOTE - Day1Price calculations (for a Date and Security): For trade types ('Loan Drawdown', 'Loan Repayment', 'Deposit Drawdown', 'Deposit Repayment'): ClosePrice = 1, CleanPrice =1 For rest of trade types: Get latest available price (close and price_clean fields) from prices table --- for that security, for that date, for a price source type User or Custodian or BBG (in that order of priority) | |
| 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 | |
| base_ccy | text | portfolio base currency | |
| bank_narration | text | transaction narration |