diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index cabe0f43..a6acca18 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3094,6 +3094,12 @@ AS SELECT trades.settle_date, FROM cds_trades WHERE cds_trades.orig_attach IS NOT NULL UNION + SELECT tranche_id::TEXT AS id, tc.date AS settle_date, + cds.fund, cds.cp_code, 'TRANCHE_PAYMENT' AS asset_class, + 'Bilateral Trade'::text AS account, tc.currency, + (COALESCE(tc.principal,0) + COALESCE(tc.accrued,0))::numeric(11,2) AS payment_amount + FROM tranche_cashflows tc LEFT JOIN cds ON tranche_id=cds.id + UNION SELECT swaptions.id::text AS id, swaptions.settle_date, swaptions.fund, |