TOTVS CRM | SFA - 12.1.2501

Parameters

Name	Type	Mode
internalid	integer	IN
idcliente	integer	IN
idlocal	integer	IN
idtipolimitecredito	integer	IN
datainiciovigencia	character varying	IN
datafimvigencia	character varying	IN
saldolimite	numeric	IN
saldodisponivel	numeric	IN
externalid	character varying	IN

Definition

begin    

	update limitecredito set 
		datainiciovigencia = case when PutLimiteCredito.datainiciovigencia = 'NOVALUEWS' then limitecredito.datainiciovigencia else TO_DATE(PutLimiteCredito.datainiciovigencia,'YYYY-MM-DD') end, 
		datafimvigencia = case when PutLimiteCredito.datafimvigencia = 'NOVALUEWS' then limitecredito.datafimvigencia else TO_DATE(PutLimiteCredito.datafimvigencia,'YYYY-MM-DD') end,
		saldolimite = case when PutLimiteCredito.saldolimite = -99999 then limitecredito.saldolimite else PutLimiteCredito.saldolimite end, 
		saldodisponivel = case when PutLimiteCredito.saldodisponivel = -99999 then limitecredito.saldodisponivel else PutLimiteCredito.saldodisponivel end, 
		idparceiro = case when PutLimiteCredito.idcliente = -99999 then limitecredito.idparceiro else PutLimiteCredito.idcliente end, 
		idlocal = case when PutLimiteCredito.idlocal = -99999 then limitecredito.idlocal else PutLimiteCredito.idlocal end,
		idtipolimitecredito = case when PutLimiteCredito.idtipolimitecredito = -99999 then limitecredito.idtipolimitecredito else PutLimiteCredito.idtipolimitecredito end,
		codigoerp = case when PutLimiteCredito.externalid = 'NOVALUEWS' then limitecredito.codigoerp else PutLimiteCredito.externalid end 
	where idlimitecredito = internalid;

	return query select internalid;
END;

putlimitecredito(integer, integer, integer, integer, character varying, character varying, numeric, numeric, character varying)

Parameters

Definition