USE [FRONTPRUEBASAGORA]
GO
/****** Object:  StoredProcedure [dbo].[UPDATEFEL]    Script Date: 25/05/2020 11:09:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[UPDATEFEL]
   	@NUMSERIE NVARCHAR(4),
	@NUMFACTURA INT,
	@SERIEFEL NVARCHAR(80),
   	@DOCUMENTOFEL NVARCHAR(80),
	@FECHAHORA NVARCHAR(50),
	@UUID NVARCHAR(4000),
	@ERRORFEL NVARCHAR(4000),
	@SERIEYNUMICG NVARCHAR(50)
    AS 
     BEGIN 

		 UPDATE [dbo].[FACTURASVENTACAMPOSLIBRES]
		  SET
			   [SERIEFEL] = @SERIEFEL
			  ,[DOCUMENTOFEL] = @DOCUMENTOFEL
			  ,[FECHAHORACERTIFICACI] = @FECHAHORA
			  ,[UUID] = @UUID
			  ,[ERROR_FEL] = @ERRORFEL
			  ,[SERIEYNUMICG] = @SERIEYNUMICG
		  WHERE 
			   NUMSERIE = @NUMSERIE  AND NUMFACTURA =@NUMFACTURA;
     END