diff options
Diffstat (limited to 'sql/dawn.sql')
| -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 9d4e26d7..cfa530fa 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -3937,8 +3937,8 @@ UNION LEFT JOIN counterparties c ON cp_code=code ; CREATE OR REPLACE function list_orphaned_cash(p_date date, p_fund fund) -RETURNS TABLE(fund fund, trade_date date,amount float, port portfolio, strat strategy, account text, currency currency, full_globeop_strat TEXT) AS $$ +RETURNS TABLE(fund fund, trade_date date,amount float, portfolio portfolio, clean_strat strategy, cash_account text, currency currency, folder TEXT) AS $$ BEGIN - RETURN Query SELECT a.*, coalesce(pfm.folder::text, a.strat::text) FROM (SELECT vr.fund, vr.periodenddate, sum(vr.endqty) AS amount, vr.port, vr.strat, vr.custacctname AS account, vr.invid::currency AS currency FROM valuation_reports vr + RETURN Query SELECT a.*, coalesce(pfm.folder::text, a.strat::text) FROM (SELECT vr.fund, vr.periodenddate, -sum(vr.endqty) AS amount, vr.port, vr.strat, vr.custacctname AS account, vr.invid::currency AS currency FROM valuation_reports vr WHERE vr.periodenddate =p_date AND vr.fund=p_fund AND vr.invid IN ('USD', 'EUR') AND vr.port NOT IN ('GFS_HELPER_BUSINESS_UNIT', 'CASH') GROUP BY (vr.port, vr.strat, vr.custacctname, vr.invid, vr.fund, vr.periodenddate) HAVING sum(vr.endqty) !=0) a LEFT JOIN portfolio_folder_mapping pfm on a.strat::text = pfm.clean_folder::text WHERE active; END; $$ LANGUAGE plpgsql; |