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
)