TOTVS CRM | SFA - 12.1.2501
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
postlocaltabelapreco(integer, integer, integer, character varying)
Parameters
Name
Type
Mode
idcliente
integer
IN
idtabelapreco
integer
IN
idnpadrao
integer
IN
externalid
character varying
IN
Definition
declare internalid integer; begin insert into localtabelapreco (idlocaltabelapreco, idparceiro, idtabelapreco, idnpadrao, codigoerp) values (nextval('seqpklocaltabelapreco'),idcliente, idtabelapreco, idnpadrao, externalid) returning idlocaltabelapreco into internalid; return query select internalid; END;