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
)