( ITEM.QUANTIDADE * TPRD.PRECO5 ) AS CUSTO,

( ITEM.QUANTIDADE ) AS QUANTIDADE,

( TPRD.PRECO5 ) AS PRECO,

( ITEM.VALORLIQUIDO ) AS VALORVENDA,

YEAR(NF.DATASAIDA) AS ANO,

MONTH(NF.DATASAIDA) AS MES,

DAY(NF.DATASAIDA) AS DIA,

CONFIRMACAO.CODTMV

FROM   TMOV CONFIRMACAO

LEFT JOIN TVEN

ON CONFIRMACAO.CODVEN1 = TVEN.CODVEN

INNER JOIN TMOVRELAC

ON CONFIRMACAO.IDMOV = TMOVRELAC.IDMOVORIGEM

INNER JOIN TMOV NF

ON TMOVRELAC.IDMOVDESTINO = NF.IDMOV

LEFT JOIN TITMMOV ITEM

ON CONFIRMACAO.IDMOV = ITEM.IDMOV

LEFT JOIN TPRD

ON ITEM.IDPRD = TPRD.IDPRD

WHERE  CONFIRMACAO.CODTMV IN ( '2.1.01', '1.2.22' )

AND CONFIRMACAO.STATUS = 'F'

AND CONFIRMACAO.CODCFO <> 'C001414'

AND NF.CODTMV IN ( '2.2.01', '2.2.20', '2.2.02', '2.2.40' )