CREATE VIEW [dbo].VW_Pagamentos_Cartao
AS
     SELECT CAST(t2.nrCNPJ AS VARCHAR(14) not null) 'nrCNPJ',
            CAST(t1.nrNSU AS VARCHAR(41))'nrNSU',
            CAST(t1.dtEmissao AS VARCHAR(10))'dtVenda',
            CAST(t3.idBandeira AS VARCHAR(10))'cdBandeira',
            CAST(t3.dsBandeira AS VARCHAR(30))'dsBandeira',
            CAST(t1.vlPagamento AS DECIMAL)'vlVenda',
            CAST(t1.qtParcelas AS INT)'qtParcelas',
            CAST(t1.idPagamentoVenda AS VARCHAR(40))'cdERP'
     FROM dbAtosCapital.card.tbPagamentoVenda t1
          INNER JOIN dbAtosCapital.card.tbEmpresa t2 ON t1.idEmpresa = t2.idEmpresa
          INNER JOIN dbAtosCapital.card.tbBandeira t3 ON t1.idBandeira = t3.idBandeira
     WHERE t1.idFormaPagamento IN(3, 4);