TOTVS CRM | SFA - 12.1.2501

Parameters

Name	Type	Mode
internalid	integer	IN
idncancelada	integer	IN
numeronotafiscal	character varying	IN
serie	character varying	IN
horaatualizacao	character varying	IN
dataemissao	character varying	IN
valorfaturado	numeric	IN
idclientelocal	integer	IN
idcliente	integer	IN
idusuario	integer	IN
idtiponotafiscal	integer	IN
idfiliallocalfaturamento	integer	IN
idfiliallocalretirada	integer	IN
idfiliallocalvenda	integer	IN
observacao	character varying	IN
idcondicaopagamento	integer	IN
valorfrete	numeric	IN
valorseguro	numeric	IN
externalid	character varying	IN

Definition

declare
	curdate date;
begin

	curdate := 'now';	  

	update notafiscal set 
		idncancelada = case when PutNotaFiscal.idncancelada = -99999 then notafiscal.idncancelada else PutNotaFiscal.idncancelada end, 
		numeronotafiscal = case when PutNotaFiscal.numeronotafiscal = 'NOVALUEWS' then notafiscal.numeronotafiscal else PutNotaFiscal.numeronotafiscal end, 
		serie = case when PutNotaFiscal.serie = 'NOVALUEWS' then notafiscal.serie else PutNotaFiscal.serie end, 
		horaatualizacao = case when PutNotaFiscal.horaatualizacao = 'NOVALUEWS' then notafiscal.horaatualizacao else PutNotaFiscal.horaatualizacao end, 
		dataemissao = case when PutNotaFiscal.dataemissao = 'NOVALUEWS' then notafiscal.dataemissao else TO_DATE(PutNotaFiscal.dataemissao,'YYYY-MM-DD') end, 
		valorfaturado = case when PutNotaFiscal.valorfaturado = -99999 then notafiscal.valorfaturado else PutNotaFiscal.valorfaturado end, 
		idlocal = case when PutNotaFiscal.idclientelocal = -99999 then notafiscal.idlocal else PutNotaFiscal.idclientelocal end, 
		idparceiro = case when PutNotaFiscal.idcliente = -99999 then notafiscal.idparceiro else PutNotaFiscal.idcliente end, 
		idusuario = case when PutNotaFiscal.idusuario = -99999 then notafiscal.idusuario else PutNotaFiscal.idusuario end, 
		idtiponotafiscal = case when PutNotaFiscal.idtiponotafiscal = -99999 then notafiscal.idtiponotafiscal else PutNotaFiscal.idtiponotafiscal end, 
		idlocalfilialfaturamento = case when PutNotaFiscal.idfiliallocalfaturamento = -99999 then notafiscal.idlocalfilialfaturamento else PutNotaFiscal.idfiliallocalfaturamento end, 
		idlocalfilialretirada = case when PutNotaFiscal.idfiliallocalretirada = -99999 then notafiscal.idlocalfilialretirada else PutNotaFiscal.idfiliallocalretirada end, 
		idlocalfilialvenda = case when PutNotaFiscal.idfiliallocalvenda = -99999 then notafiscal.idlocalfilialvenda else PutNotaFiscal.idfiliallocalvenda end, 
		observacao = case when PutNotaFiscal.observacao = 'NOVALUEWS' then notafiscal.observacao else PutNotaFiscal.observacao end, 
		idcondicaopagamento = case when PutNotaFiscal.idcondicaopagamento = -99999 then notafiscal.idcondicaopagamento else PutNotaFiscal.idcondicaopagamento end, 
		valorfrete = case when PutNotaFiscal.valorfrete = -99999 then notafiscal.valorfrete else PutNotaFiscal.valorfrete end, 
		valorseguro = case when PutNotaFiscal.valorseguro = -99999 then notafiscal.valorseguro else PutNotaFiscal.valorseguro end, 
		dataatualizacao = curdate,
		codigoerp = case when Putnotafiscal.externalid = 'NOVALUEWS' then codigoerp else Putnotafiscal.externalid end 
	where idnotafiscal = internalid ;

	return query select internalid;
END;

putnotafiscal(integer, integer, character varying, character varying, character varying, character varying, numeric, integer, integer, integer, integer, integer, integer, integer, character varying, integer, numeric, numeric, character varying)

Parameters

Definition