/*SELECT idbaixa, CAST((D.valorrecebido * 0.015) AS NUMERIC(14,2)) AS basecomissao,
100 AS percentual, CAST((D.valorrecebido * 0.015) AS NUMERIC(14,2)) AS comissao, data
FROM COMISSAO_PRAZO CP
INNER JOIN duplicatas_baixas D ON CP.idbaixa = D.codigo
WHERE D.datarecebimento between '01.09.2021' and '30.09.2021'*/
/*select N.idnf AS IDNF,N.vendaavista AS BASECOMISSAO,100 AS PERCENTUAL,N.vendaavista AS COMISSAO
from NF_COMISSAO N
INNER JOIN NF ON N.IDNF = NF.CODIGO
where nf.tipo = 'SP'
AND nf.dataemissao between '01.09.2021' and '30.09.2021'*/
/*select
n.id, n.idnf,
nf.COMISSAO as basecomissao,
CAST((NF.comissao * ((100.00 - CAST(((NF.valorprazo / NF.valortotal) * 100) AS NUMERIC(14,2))) / 100)) AS NUMERIC(14,2)) AS vendaavista,
CAST((NF.comissao * (ROUND(((NF.valorprazo / NF.valortotal) * 100),2) / 100))AS NUMERIC(14,2)) AS vendaaprazo,
(100.00 - CAST(((NF.valorprazo / NF.valortotal) * 100) AS NUMERIC(14,2))) AS percavista,
CAST(((NF.valorprazo / NF.valortotal) * 100) AS NUMERIC(14,2)) AS percaprazo
from nf_comissao n
inner join nf on n.idnf = nf.codigo
where nf.tipo = 'SP'
AND nf.dataemissao between '01.09.2021' and '30.09.2021'*/
/*update nf set nf.comissao = (nf.valortotal * 0.015)
where nf.dataemissao between '01.09.2021' and '30.09.2021'
and nf.tipo = 'SP'*/
