UFN_PLANNEDGIFT_AUTOCALCULATE_REALIZEDAMOUNT_ENABLEDFORVEHICLE

Returns the number of planned gifts set to auto-calculate the realized amount based on a vehicle code.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@VEHICLECODE	tinyint	IN

Definition

Copy



            create function dbo.UFN_PLANNEDGIFT_AUTOCALCULATE_REALIZEDAMOUNT_ENABLEDFORVEHICLE
            (
                @VEHICLECODE as tinyint
            ) 
            returns int
            with execute as caller
            as
            begin

                declare @PLANNEDGIFTCOUNT int;

                set @PLANNEDGIFTCOUNT = 0;

                select 
                    @PLANNEDGIFTCOUNT = count(ID) 
                from 
                    dbo.PLANNEDGIFT 
                where 
                    VEHICLECODE = @VEHICLECODE and
                    AUTOCALCULATEREALIZEDAMOUNT = 1        

                return @PLANNEDGIFTCOUNT;

            end