select ROUND(SUM(TOTAL),2) as TOTAL, NAT_REC, CST_PIS from
(select sum(B.totalproduto) as TOTAL, PR.ITM_TAB_EXCLUSAO AS NAT_REC, B.CST_PIS
from PRODUTOS_NOTASAIDA B
inner join LVSAIDAS A on B.primaria=A.primaria
inner join PRODUTO PR on PR.coditem=B.id_produto
inner join CFOP C on C.cfop=B.cfop
left join GRUPO GR on GR.codgrupo=PR.grupo
left join FAMILIAS FAM on FAM.codigo=PR.familia
left join CATEGORIAS CA on CA.id_categoria=PR.categoria
left join CLIENTES CL on CL.codigocli=PR.id_fabricante
left join ALIQUOTAS AL on AL.posicao=A.aliquota
left join TRIBUTACAOPISCOFINS T on B.CODTRIBPISCOFINS=T.ID
where A.empresa in (1) and A.modelo in (1,2,4,55) and A.PARTICIPAPIS='S' and C.PARTICIPAPISCOFINS='S'
and A.cancelado='N'
and A.emissao between ('2013-02-01') and ('2019-10-01')
and B.CST_PIS in (04,06)
group by PR.ITM_TAB_EXCLUSAO, B.CST_PIS 

union all

    select sum(A.qtdxunit-A.desconto+A.acrescimo-A.DESCONTO_ITEM) as TOTAL, PR.ITM_TAB_EXCLUSAO AS NAT_REC, A.CST_PIS
    from MOVDIARIO A
    inner join PRODUTO PR on PR.coditem=A.id_produto
    left join GRUPO GR on GR.codgrupo=PR.grupo
    left join FAMILIAS FAM on FAM.codigo=PR.familia
    left join CATEGORIAS CA on CA.id_categoria=PR.categoria
    left join CLIENTES CL on CL.codigocli=PR.id_fabricante
    left join ALIQUOTAS AL on AL.posicao=A.aliquota
    left join TRIBUTACAOPISCOFINS T on PR.COD_TRIBPISCOFINSVENDAS=T.ID
    where A.empresa in (1)
    and A.tipo='V' and (A.situacao='' or A.situacao is null or A.situacao=' ')
    and
    A.CST_PIS in (04,06) and A.emissao between ('2019-10-01') and ('2019-10-31')
    group by PR.ITM_TAB_EXCLUSAO, A.CST_PIS 

  union all

  select sum(A.VL_ITEM) as TOTAL, PR.ITM_TAB_EXCLUSAO AS NAT_REC, A.CST_PIS
  from itens_registroiss A
  inner join registrosiss B on A.primaria=B.primaria
  inner join PRODUTO PR on A.COD_ITEM=PR.CODITEM
  left join tributacaopiscofins T on A.COD_TRIBUTACAOPISCOFINS=T.ID
  where B.id_empresa in (1)
  and B.IND_OPER=1 and
  A.CST_PIS in (04,06) AND B.DT_EXE_SERV between ('2019-10-01') and ('2019-10-31') and
  B.COD_SIT=0
  group by PR.ITM_TAB_EXCLUSAO, A.CST_PIS

  UNION ALL

  select sum(A.VL_OPER) as TOTAL, A.ITM_TAB_EXCLUSAO AS NAT_REC, A.CST_PIS
  from DEMAISDOCUMENTOSPISCOFINS A
  where A.DT_OPER between ('2019-10-01') and ('2019-10-31') and A.REGIME='NC'
  AND A.ID_EMPRESA in (1) and (IND_OPER=1 or IND_OPER=2) and A.CST_PIS in (04,06)
  group by A.ITM_TAB_EXCLUSAO, A.CST_PIS
  )
  as TMP
  group by CST_PIS

***************************************************************************************************

#M400
select ROUND(SUM(TOTAL),2) as TOTAL, CST_PIS from
(select sum(B.totalproduto) as TOTAL, B.CST_PIS
from PRODUTOS_NOTASAIDA B
inner join LVSAIDAS A on B.primaria=A.primaria
inner join PRODUTO PR on PR.coditem=B.id_produto
inner join CFOP C on C.cfop=B.cfop
left join GRUPO GR on GR.codgrupo=PR.grupo
left join FAMILIAS FAM on FAM.codigo=PR.familia
left join CATEGORIAS CA on CA.id_categoria=PR.categoria
left join CLIENTES CL on CL.codigocli=PR.id_fabricante
left join ALIQUOTAS AL on AL.posicao=A.aliquota
left join TRIBUTACAOPISCOFINS T on B.CODTRIBPISCOFINS=T.ID
where A.empresa in (1) and A.modelo in (1,2,4,55) and A.PARTICIPAPIS='S' and C.PARTICIPAPISCOFINS='S'
and A.cancelado='N'
and A.emissao between ('2013-02-01') and ('2013-02-28')
and B.CST_PIS in (04,05,06,07,08,09)
group by B.CST_PIS

  union all

  select sum(A.qtdxunit-A.desconto+A.acrescimo-A.DESCONTO_ITEM) as TOTAL, A.CST_PIS
  from MOVDIARIO A
  inner join PRODUTO PR on PR.coditem=A.id_produto
  left join GRUPO GR on GR.codgrupo=PR.grupo
  left join FAMILIAS FAM on FAM.codigo=PR.familia
  left join CATEGORIAS CA on CA.id_categoria=PR.categoria
  left join CLIENTES CL on CL.codigocli=PR.id_fabricante
  left join ALIQUOTAS AL on AL.posicao=A.aliquota
  left join TRIBUTACAOPISCOFINS T on PR.COD_TRIBPISCOFINSVENDAS=T.ID
  where A.empresa in (1)
  and A.tipo='V' and (A.situacao='' or A.situacao is null or A.situacao=' ')
  and
  A.CST_PIS in (04,05,06,07,08,09) and A.emissao between ('2013-02-01') and ('2013-02-28')
  group by A.CST_PIS

  union all
  	
  select sum(A.VL_ITEM) as TOTAL, A.CST_PIS
  from itens_registroiss A
  inner join registrosiss B on A.primaria=B.primaria
  left join tributacaopiscofins T on A.COD_TRIBUTACAOPISCOFINS=T.ID
  where B.id_empresa in (1)
  and B.IND_OPER=1 and
  A.CST_PIS in (04,05,06,07,08,09) AND B.DT_EXE_SERV between ('2013-02-01') and ('2013-02-28') and
  B.COD_SIT=0
  group by A.CST_PIS

  UNION ALL

  select sum(A.VL_OPER) as TOTAL, A.CST_PIS
  from DEMAISDOCUMENTOSPISCOFINS A
  where A.DT_OPER between ('2013-02-01') and ('2013-02-28') and A.REGIME='NC'
  AND A.ID_EMPRESA in (1) and (IND_OPER=1 or IND_OPER=2) and A.CST_PIS in (04,05,06,07,08,09)
  group by A.CST_PIS

  )
  as TMP
  group by CST_PIS;
  
***************************************************************************************************
#M400
select ROUND(SUM(TOTAL),2) as TOTAL, CST_PIS from
(
  select sum(A.qtdxunit-A.desconto+A.acrescimo-A.DESCONTO_ITEM) as TOTAL, A.CST_PIS
  from MOVDIARIO A
  inner join PRODUTO PR on PR.coditem=A.id_produto
  left join GRUPO GR on GR.codgrupo=PR.grupo
  left join FAMILIAS FAM on FAM.codigo=PR.familia
  left join CATEGORIAS CA on CA.id_categoria=PR.categoria
  left join CLIENTES CL on CL.codigocli=PR.id_fabricante
  left join ALIQUOTAS AL on AL.posicao=A.aliquota
  left join TRIBUTACAOPISCOFINS T on PR.COD_TRIBPISCOFINSVENDAS=T.ID
  where A.empresa in (1)
  and A.tipo='V' and (A.situacao='' or A.situacao is null or A.situacao=' ')
  and
  A.CST_PIS in (04,05,06,07,08,09) and A.emissao between ('2013-02-01') and ('2013-02-28')
  group by A.CST_PIS

  )
  as TMP
  group by CST_PIS;
  
***************************************************************************************************
select A.id_produto,sum(A.qtdxunit) as TotalItem, 
round(sum(A.qtdxunit-A.desconto+A.acrescimo-A.DESCONTO_ITEM),2) as BaseCalculo, 
ROUND(SUM((A.QTDXUNIT-A.DESCONTO+A.ACRESCIMO-A.DESCONTO_ITEM)*(A.ALIQUOTAPIS/100)),2) as ValorPis, 
(ROUND(SUM((A.QTDXUNIT-A.DESCONTO+A.ACRESCIMO-A.DESCONTO_ITEM)*(A.ALIQUOTACOFINS/100)),2)) as ValorCofins, 
A.CST_PIS, A.CST_COFINS, A.ALIQUOTAPIS, A.ALIQUOTACOFINS 
from MOVDIARIO A inner join produto B on A.id_produto=B.coditem 
left join TRIBUTACAOPISCOFINS T on B.COD_TRIBPISCOFINSVENDAS=T.ID 
inner join empresas C on A.empresa=C.codigo_n 
where A.empresa=1 and A.tipo='V'
and (A.situacao is null or A.situacao='' or A.situacao=' ') and 
A.emissao between ('2013-02-01') and ('2013-02-28') 
group by A.CST_PIS, A.CST_COFINS

***************************************************************************************************
select ROUND(SUM(TOTAL),2) as TOTAL, NAT_REC, CST_PIS from
(
    select sum(A.qtdxunit-A.desconto+A.acrescimo-A.DESCONTO_ITEM) as TOTAL, PR.ITM_TAB_EXCLUSAO AS NAT_REC, A.CST_PIS
    from MOVDIARIO A
    inner join PRODUTO PR on PR.coditem=A.id_produto
    left join GRUPO GR on GR.codgrupo=PR.grupo
    left join FAMILIAS FAM on FAM.codigo=PR.familia
    left join CATEGORIAS CA on CA.id_categoria=PR.categoria
    left join CLIENTES CL on CL.codigocli=PR.id_fabricante
    left join ALIQUOTAS AL on AL.posicao=A.aliquota
    left join TRIBUTACAOPISCOFINS T on PR.COD_TRIBPISCOFINSVENDAS=T.ID
    where A.empresa in (1)
    and A.tipo='V' and (A.situacao='' or A.situacao is null or A.situacao=' ')
    and
    A.CST_PIS in (04,05,06,07,08,09) and A.emissao between ('2013-02-01') and ('2013-02-28')
    group by PR.ITM_TAB_EXCLUSAO, A.CST_PIS 
  )
  as TMP
  group by CST_PIS