Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- FMC.EMPRESA,
- FMC.REVENDA,
- FMC.NUMERO_NOTA_FISCAL,
- FMC.TIPO_TRANSACAO,
- FMC.DTA_DOCUMENTO,
- FMC.CHASSI,
- FMC.TOT_NOTA_FISCAL,
- FT.STATUS,
- FT.VAL_TITULO,
- SUM(FTP.VAL_PAGAMENTO),
- FMC.NUMERO_DAV,
- CAST((COALESCE((FT.VAL_TITULO), 0.0) -
- COALESCE(SUM(FTP.VAL_PAGAMENTO), 0.0)) AS
- DECIMAL(22, 2)) AS SALDO_TITULO
- FROM FAT_MOVIMENTO_CAPA FMC
- INNER JOIN FIN_TITULO FT ON FT.EMPRESA = FMC.EMPRESA
- INNER JOIN FIN_TITULO_PAGAMENTO FTP ON FTP.EMPRESA = FT.EMPRESA
- WHERE FT.TIPO = 'CR'
- AND FMC.TIPO_TRANSACAO = 'G21'
- AND FMC.EMPRESA = 7
- AND FMC.REVENDA IN (6)
- AND FT.STATUS IN 'PP'
- AND FMC.DTA_DOCUMENTO BETWEEN '01/JAN/2021' AND '31/JAN/2021'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement