diff options
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 4da8bbf8..932ff603 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -4771,6 +4771,7 @@ AS SELECT a.*, c.name from(SELECT unnest(ARRAY[fx_swaps.dealid::text, fx_swaps. fx_swaps.portfolio, fx_swaps.folder, fx_swaps.cp_code, + fx_swaps.cash_account, unnest(ARRAY[fx_swaps.near_buy_currency, fx_swaps.far_buy_currency]) AS buy_currency, unnest(ARRAY[fx_swaps.near_sell_currency, fx_swaps.far_sell_currency]) AS sell_currency, unnest(ARRAY[fx_swaps.near_buy_amount::numeric(11,2), fx_swaps.far_buy_amount::numeric(11,2)]) AS buy_amount, @@ -4788,6 +4789,7 @@ UNION spots.portfolio, spots.folder, spots.cp_code, + spots.cash_account, spots.buy_currency, spots.sell_currency, spots.buy_amount::numeric(11,2), |