Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE VIEW VW_SAOLUIS_RELAPM AS
- SELECT
- PAR.DATAPAGAMENTO as ParcelaDataPagamento,
- PAR.CODIGOUNIDADE as ParcelaCodigoUnidade,
- PAR.VALORTAXABANCARIA as ParcelaValorTarifa,
- PAR.VALORDEVIDO as ParcelaValorDevido,
- PAR.VALORPAGO as ParcelaValorPago,
- PAR.DATAVENCIMENTO as ParcelaDataVencimento,
- PAR.ANOREFERENCIA as ParcelaAnoReferencia,
- PAR.MESREFERENCIA as ParcelaMesReferencia,
- PAR.VALORACRESCIMO as ParcelaValorAcrescimos,
- PAR.DEBITOS as ParcelaValorOriginal,
- ISNULL(APM.VALORTOTAL,0.00) as ParcelaValorAPM,
- BAN.NOME as ParcelaLocalPagto
- FROM TES_PARCELA PAR
- LEFT JOIN PAD_BANCO BAN ON BAN.CODIGOBANCO = PAR.CODIGOBANCO
- OUTER APPLY(SELECT TES_PARCELAEVENTO.VALORTOTAL FROM TES_PARCELAEVENTO
- INNER JOIN TES_EVENTO ON TES_EVENTO.CODIGOEVENTO = TES_PARCELAEVENTO.CODIGOEVENTO
- INNER JOIN TES_EVENTOADICIONAL ON TES_EVENTOADICIONAL.CODIGOEVENTO = TES_EVENTO.CODIGOEVENTO
- WHERE CODIGOPARCELA = PAR.CODIGOPARCELA
- AND CHARINDEX('APM',TES_EVENTO.DESCRICAO) > 0) APM
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement