diff options
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index d4f095b1..7250844f 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3218,7 +3218,8 @@ SELECT eo.id, t.termination_date AS trade_date, t.fee_payment_date AS settle_date, t.termination_amount AS notional, - eo.identifier, + eo.bbg_ticker, + eo.figi, CASE WHEN t.termination_cp=eo.cp_code THEN 'Termination' ELSE @@ -3243,7 +3244,8 @@ SELECT eo.id, eo.trade_date, eo.settle_date, eo.notional, - eo.identifier, + eo.bbg_ticker, + eo.figi, 'New' AS trade_type, eo.folder, eo.portfolio, |