E105

SELECT "Local_GL_Account",
   "Local_GL_Description",
   "Master_Account",
  "Invoice_Number",
   "Invoice_Date",
   "Customer/Supplier",
   amount
FROM  (
       SELECT campo1 AS "Year",
          campo14 AS "Scenario",
          campo2 AS "Month",
          campo3 AS "Entity",
          campo4 AS "Local_GL_Account",
          campo15 AS "Master_Account",
          campo5 AS "Local_GL_Description",
          campo6 AS "Cost_Center",
          campo7 AS "Product",
          campo11 AS "Customer/Supplier",
          campo9 AS "Invoice_Number",
  				CASE WHEN LENGTH(campo10) > 0 THEN       
  					TO_CHAR(TO_DATE('01011900','MMDDYYYY')+TO_NUMBER(campo10,'99999')*INTERVAL '1 Day', 'MM/DD/YYYY')
  				ELSE ''
  				END AS "Invoice_Date",
          campo11 AS "Supplier",
          CAST (REPLACE(campo12,',','.') AS NUMERIC(20,2)) AS amount
       FROM  map_dati_trasformati
       WHERE cod_mappatura='05'
       AND  cod_import='010'
       AND  campo1='2018'
       AND  campo2='12'
       AND  campo3=${$Entity.code} 
       AND  campo6='CC_500'
       AND  campo7='PD_500'
       AND  campo8='CM_500'
       AND  campo15=${$Account.code}
       AND  campo14= ${$Scenario.code} 
) a
UNION ALL
SELECT 'Total',
   '',
   '',
   '',
   '',
   '',
   SUM(amount) AS amount
FROM  (
       SELECT CAST (REPLACE(campo12,',','.') AS NUMERIC(20,2)) AS amount
       FROM  map_dati_trasformati
       WHERE cod_mappatura='05'
       AND  cod_import='010'
       AND  campo1='2018'
       AND  campo2='12'
       AND  campo3=${$Entity.code} 
       AND  campo6='CC_500'
       AND  campo7='PD_500'
     AND  campo8='CM_500'
     AND  campo15=${$Account.code}
       AND  campo14= ${$Scenario.code} 
) a