Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TB1.CODCLI,
- TB1.NOMECLI,
- TB1.NUMNOTA,
- TB1.DATAEMISSAO,
- TB0.DATVENC,
- TB2.CODIGOPRODUTO,
- TB3.NOMEPROD,
- CAST(TB2.QUANTIDADE AS DECIMAL(12,2)) AS QUANTIDADE,
- CAST(TB2.VALORUNITARIO AS DECIMAL(12,2)) as VALORUNITARIO,
- CAST(TB1.VALORFRETE AS DECIMAL(12,2)) AS VALORFRETE,
- CAST(TB1.VALORTOTALNOTA AS DECIMAL(12,2)) AS VALORTOTALNOTA,
- TB2.CODCFOP,
- TB4.DATA,
- current_time,
- EXTRACT (YEAR FROM CURRENT_DATE) AS ANO,
- EXTRACT (MONTH FROM CURRENT_DATE) AS MES,
- EXTRACT (DAY FROM CURRENT_DATE) AS DIA
- FROM CONTARECEBER TB0
- LEFT JOIN CONTARECEBERREC TB4 ON TB0.CODCR = TB4.CODCR
- INNER JOIN MOVENDA TB1 ON CAST(TB1.NUMNOTA AS VARCHAR(20)) = TB0.NUMDOC
- INNER JOIN MOVENDAPROD TB2 ON TB2.CODMOVENDA = TB1.CODMOVENDA
- INNER JOIN PRODUTO TB3 ON TB2.CODIGOPRODUTO = TB3.CODIGO
- WHERE
- (TB1.CODCLI BETWEEN '00000001' AND '999999999') AND
- (TB2.CODIGOPRODUTO BETWEEN '00000001' AND '999999999')
- AND (TB1.DATAEMISSAO BETWEEN '2018-07-10' AND '2018-07-10')
- AND TB1.FLAGCANCELADA = 'N'
- ORDER BY TB1.NUMNOTA ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement