SELECT SUM(VALORTOTAL) AS VALORTOTAL , SUM(DINHEIRO) AS DINHEIRO , SUM(PARCELAS) AS PARCELAS, SUM(CHEQUE) AS CHEQUE, SUM(SUPRIMENTO) AS SUPRIMENTO,
SUM(VENDAAVISTA) AS VENDAAVISTA , SUM(PGTOPARCELAS) AS PGTOPARCELAS
 FROM SPCAIXADIA(:DATAI, :DATAF, :CODFUNCIONARIO) S