UFN_CONSTITUENT_GIVINGHISTORY
Returns all revenue and revenue splits in a constituent's entire giving history.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | |
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @SITEFILTERMODE | tinyint | IN | |
| @SITESSELECTED | xml | IN | |
| @SECURITYFEATUREID | uniqueidentifier | IN | |
| @SECURITYFEATURETYPE | tinyint | IN |
Definition
Copy
CREATE function [dbo].[UFN_CONSTITUENT_GIVINGHISTORY]
(
@CONSTITUENTID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier,
@SITEFILTERMODE tinyint = 0,
@SITESSELECTED xml = null,
@SECURITYFEATUREID uniqueidentifier = null,
@SECURITYFEATURETYPE tinyint = null
)
returns table
as
return
(
select * from dbo.UFN_CONSTITUENT_GIVINGHISTORYINCURRENCY(@CONSTITUENTID, @CURRENTAPPUSERID, @SITEFILTERMODE, @SITESSELECTED,
@SECURITYFEATUREID, @SECURITYFEATURETYPE, default)
)