UFN_BATCHREVENUE_GETCONSTITUENTSOLICITCODES
Return
Return Type |
---|
table |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@BATCHREVENUEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_BATCHREVENUE_GETCONSTITUENTSOLICITCODES
(
@BATCHREVENUEID uniqueidentifier
)
returns table
as
return
(
select
ID,
CONSTITUENTSOLICITCODEID,
SOLICITCODEID,
STARTDATE,
ENDDATE,
COMMENTS,
SEQUENCE,
CONSENTPREFERENCECODE,
SOURCECODEID,
SOURCEFILEPATH,
PRIVACYPOLICYFILEPATH,
SUPPORTINGINFORMATION,
CONSENTSTATEMENT
from
dbo.BATCHREVENUECONSTITUENTSOLICITCODE
where
BATCHREVENUEID = @BATCHREVENUEID
)