
create PROCEDURE sp_Api5_AppFac_VenDetalleRead
    @numinv INT,
    @coddoc INT,
    @grudoc INT
AS
BEGIN
    SELECT 
        vendetalle.*, 
        vendetalle.tip_impadi AS Tipimpadi,
        CASE 
            WHEN invArticulos.selExento = 1 THEN invArticulos.exentoArt 
            ELSE invFamilia.exento  
        END AS marcaExento,
        ISNULL(imp.descripcion, '') AS DescImpuesto,
		invArticulos.codalt,
		invArticulos.codbar
    FROM vendetalle
    INNER JOIN invArticulos ON vendetalle.codbus = invArticulos.codbus 
    INNER JOIN invFamilia ON vendetalle.codfam = invFamilia.CodFam
    LEFT JOIN venImpuestos AS imp ON vendetalle.tip_impadi = imp.codigo
    WHERE 
        vendetalle.numinv = @numinv
        AND vendetalle.coddoc = @coddoc
        AND vendetalle.grudoc = @grudoc
END