UFN_REVENUE_GETHOUSEHOLDRAISEDTOTAL_NO_REVENUE_RULES

Provide household raised total in a given FAF event, excluding revenue rules

Return

Return Type
money

Parameters

Parameter Parameter Type Mode Description
@HOUSEHOLDID uniqueidentifier IN
@EVENTID uniqueidentifier IN

Definition

Copy


create function [dbo].[UFN_REVENUE_GETHOUSEHOLDRAISEDTOTAL_NO_REVENUE_RULES](
     @HOUSEHOLDID    as uniqueidentifier
    ,@EVENTID        as uniqueidentifier
)
returns money
with execute as caller
as 
begin
     return (select [dbo].[UFN_REVENUE_GETGROUPRAISEDTOTAL_NO_REVENUE_RULES](@EVENTID ,@HOUSEHOLDID ,3));
end