UFN_REVENUE_HASDESIGNATION_PLANNEDGIFTLIKEPLEDGE
Returns true if the revenue (and split) can have a designation but counts planned gifts instead of planned gift payments (like pledges are counted)
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUETYPECODE | tinyint | IN | |
| @APPLICATIONCODE | tinyint | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUE_HASDESIGNATION_PLANNEDGIFTLIKEPLEDGE
(
@REVENUETYPECODE tinyint,
@APPLICATIONCODE tinyint
)
returns bit
as begin
-- (Pledge, Matching gift, Planned gift, or Grant award, or Auction donation) or (Payment and (Donation, Recurring gift, Other, Planned gift)
if (@REVENUETYPECODE in (1,3,4,6,7) or (@REVENUETYPECODE = 0 and @APPLICATIONCODE in (0,3,4)))
return 1;
return 0;
end