diff options
| -rw-r--r-- | sql/dawn.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 29acc883..6993c389 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3854,7 +3854,7 @@ SELECT trs.id, termination_fee AS upfront, terminations.traded_level as price, maturity_date, - settle_date + fee_payment_date as settle_date FROM terminations RIGHT JOIN trs USING (dealid) LEFT JOIN counterparties on termination_cp=code WHERE termination_date is NOT NULL @@ -3862,7 +3862,7 @@ UNION ALL ( SELECT id, dealid, trade_date, - notional, + notional, underlying_desc, underlying_security, 'New', |