Fresbee Wabi Pets

Información del producto

SELECT c.*, c.fecha_emision AS Fecha, c.campo2 AS vuelto, l.codigo_clte AS codigo_cliente, l.codigo_clte AS codigo_clte, t.descripcion_categ AS categoria, p.codigo_termino AS codigo_termino, p.Descripcion_termino as Descripcion_termino, v.Codigo_vendedor, v.Nombre_vendedor, v.Nombre_vendedor AS vendedor, ISNULL(v.Direccion3,' ') AS telefono_vendedor, ISNULL(g.giro_negocio,' ') AS dsc_rubro, ISNULL(l.contacto,' ') AS contacto, ISNULL(l.telefono1,' ') AS telefono1, ISNULL(l.telefono2,' ') AS telefono2, ISNULL(l.e_mail1,' ') AS email1, ISNULL(l.e_mail2,' ') AS email2, ISNULL(l.campo1,' ') As campo1, ISNULL(l.campo2,' ') As campo2, ISNULL(l.campo3,' ') As campo3B, ISNULL(l.campo2,' ') As digver, ISNULL(l.ciudad,' ') As c_ciudad, ISNULL(l.provincia,' ') as c_provincia, ISNULL(l.pais,' ') as c_pais FROM factura c LEFT JOIN clientes l ON c.cliente_id = l.cliente_id LEFT JOIN terminos_pago p ON c.termino_id = p.termino_id LEFT JOIN vendedores v ON c.vendedor_id = v.vendedor_id LEFT JOIN Categorias_clte t ON l.Categoria_Clte_id = t.categoria_clte_id LEFT JOIN giro_negocios g ON l.giro_id = g.giro_id WHERE c.nro_factura = ?wNroDocAct