TOTVS CRM | SFA - 12.1.2501
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
putlocalregiao(integer, integer, integer, character varying)
Parameters
Name
Type
Mode
internalid
integer
IN
idlocal
integer
IN
idregiao
integer
IN
externalid
character varying
IN
Definition
begin update localregiao set idlocal = case when PutLocalRegiao.idlocal = -99999 then localregiao.idlocal else PutLocalRegiao.idlocal end, idregiao = case when PutLocalRegiao.idregiao = -99999 then localregiao.idregiao else PutLocalRegiao.idregiao end, codigoerp = case when Putlocalregiao.externalid = 'NOVALUEWS' then codigoerp else Putlocalregiao.externalid end where idlocalregiao = internalid ; return query select internalid; END;