create procedure [dbo].[sp_Api5_VenEncabezadoList_AppFact_Read]
(
	@numinv INT = 0,
    @codsii INT = 0,
    @codsuc INT = 0,
	@rutcte INT = 0,
	@fecdocini DATE = '01-12-2025',
    @fecdocfin DATE ='10-12-2025'
)
AS
BEGIN
 SELECT 
        VenEncabezado.*,
        ven.nomdoc,
        cta.digcte,
		cta.nomcte
    FROM 
        VenEncabezado
        INNER JOIN venDocumentos AS ven ON VenEncabezado.codsii = ven.codsii
        INNER JOIN conCtacte AS cta ON VenEncabezado.rutcte = cta.rutcte
    WHERE 
		(@numinv = 0 OR numinv = @numinv)
	AND (@codsii = 0 OR VenEncabezado.codsii = @codsii)
    AND (@codsuc = 0 OR VenEncabezado.codloc = @codsuc)
	AND (@rutcte = 0 OR VenEncabezado.rutcte = @rutcte)
	AND VenEncabezado.flgimp = 'S'
	AND (@fecdocini IS NULL OR @fecdocfin IS NULL OR fecdoc BETWEEN @fecdocini AND @fecdocfin)
	order by venEncabezado.numinv desc
END