diff options
| -rw-r--r-- | sql/dawn.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index b9e39bd8..05aa078e 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -5087,7 +5087,8 @@ AS SELECT tc.date AS settle_date, 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 + cds.fund, + cds.cpty_id FROM tranche_cashflows tc LEFT JOIN cds ON tc.tranche_id = cds.id LEFT JOIN counterparties ON cds.cp_code::text = counterparties.code::text |