UFN_REVENUE_HASDESIGNATION

Returns true if the revenue (and split) can have a designation

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUETYPECODE	tinyint	IN
@APPLICATIONCODE	tinyint	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUE_HASDESIGNATION
            (
                @REVENUETYPECODE tinyint,
                @APPLICATIONCODE tinyint
            ) 
            returns bit
            as begin
                -- (Pledge, Matching gift, or Grant award, or Auction donation, or Donor challenge) or ((Payment or Planned Gift) AND (Donation, Event registration - donation, Recurring gift, Other, Planned gift)

                --        or Sales Order and Donation

                if (@REVENUETYPECODE in (1,3,4,6,7,8) or (@REVENUETYPECODE = 0 and @APPLICATIONCODE in (0,1,3,4)) or (@REVENUETYPECODE = 5 and @APPLICATIONCODE = 0))
                    return 1;
                return 0;
            end