1 files changed, 18 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql
index a682cd23..86ee0039 100644
--- a/sql/dawn.sql
+++ b/sql/dawn.sql
@@ -5074,4 +5074,21 @@ BEGIN
     ) b 
     ON a.identifier=b.cusip;
 END;
-$$ LANGUAGE PLPGSQL;
-\ No newline at end of file
+$$ LANGUAGE PLPGSQL;
+
+
+CREATE OR REPLACE VIEW tranche_cashflow_settlements
+AS SELECT tc.date AS settle_date,
+    cds.dealid,
+    tc.tranche_id AS id,
+    cds.cp_code AS counterparty,
+    counterparties.name,
+    tc.principal::numeric(11,2) AS principal,
+    tc.accrued::numeric(11,2) AS accrued,
+    (COALESCE(tc.principal, 0::double precision) + COALESCE(tc.accrued, 0::double precision))::numeric(11,2) AS total_cashflow,
+    tc.currency,
+    cds.fund
+   FROM tranche_cashflows tc
+     LEFT JOIN cds ON tc.tranche_id = cds.id
+     LEFT JOIN counterparties ON cds.cp_code::text = counterparties.code::text
+  ORDER BY tc.date DESC, cds.fund, cds.cp_code;
+\ No newline at end of file