USP_DATAFORMTEMPLATE_ADD_REVENUEOPPORTUNITYLINK_PRELOAD
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @CONSTITUENTID | uniqueidentifier | INOUT | |
| @CONSTITUENTNAME | nvarchar(100) | INOUT | |
| @REVENUETYPECODE | tinyint | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_REVENUEOPPORTUNITYLINK_PRELOAD
(
@REVENUEID uniqueidentifier,
@CONSTITUENTID uniqueidentifier = null output,
@CONSTITUENTNAME nvarchar(100) = null output,
@REVENUETYPECODE tinyint = null output
)
as
set nocount on;
select
@CONSTITUENTID = FINANCIALTRANSACTION.CONSTITUENTID,
@CONSTITUENTNAME = NF.NAME,
@REVENUETYPECODE = FINANCIALTRANSACTION.TYPECODE
from dbo.FINANCIALTRANSACTION
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(FINANCIALTRANSACTION.CONSTITUENTID) NF
where ID = @REVENUEID;
return 0;