Advertisement
Guest User

Untitled

a guest
Jul 19th, 2018
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. SELECT TB1.CODCLI,
  2. TB1.NOMECLI,
  3. TB1.NUMNOTA,
  4. TB1.DATAEMISSAO,
  5. TB0.DATVENC,
  6. TB2.CODIGOPRODUTO,
  7. TB3.NOMEPROD,
  8. CAST(TB2.QUANTIDADE AS DECIMAL(12,2)) AS QUANTIDADE,
  9. CAST(TB2.VALORUNITARIO AS DECIMAL(12,2)) as VALORUNITARIO,
  10. CAST(TB1.VALORFRETE AS DECIMAL(12,2)) AS VALORFRETE,
  11. CAST(TB1.VALORTOTALNOTA AS DECIMAL(12,2)) AS VALORTOTALNOTA,
  12. TB2.CODCFOP,
  13. TB4.DATA,
  14. current_time,
  15. EXTRACT (YEAR FROM CURRENT_DATE) AS ANO,
  16. EXTRACT (MONTH FROM CURRENT_DATE) AS MES,
  17. EXTRACT (DAY FROM CURRENT_DATE) AS DIA
  18. FROM CONTARECEBER TB0
  19. LEFT JOIN CONTARECEBERREC TB4 ON TB0.CODCR = TB4.CODCR
  20. INNER JOIN MOVENDA TB1 ON CAST(TB1.NUMNOTA AS VARCHAR(20)) = TB0.NUMDOC
  21. INNER JOIN MOVENDAPROD TB2 ON TB2.CODMOVENDA = TB1.CODMOVENDA
  22. INNER JOIN PRODUTO TB3 ON TB2.CODIGOPRODUTO = TB3.CODIGO
  23. WHERE
  24. (TB1.CODCLI BETWEEN '00000001' AND '999999999') AND
  25. (TB2.CODIGOPRODUTO BETWEEN '00000001' AND '999999999')
  26. AND (TB1.DATAEMISSAO BETWEEN '2018-07-10' AND '2018-07-10')
  27. AND TB1.FLAGCANCELADA = 'N'
  28. ORDER BY TB1.NUMNOTA ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement