UFN_CONSTITID_MAPFROM_REVENUERECOGNITIONID

Maps a revenue recognition ID to a constituent ID.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUERECOGNITIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITID_MAPFROM_REVENUERECOGNITIONID(@REVENUERECOGNITIONID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @CONSTITUENTID uniqueidentifier;

                select @CONSTITUENTID = REVENUERECOGNITION.CONSTITUENTID 
                from dbo.REVENUERECOGNITION
                where ID = @REVENUERECOGNITIONID

                return @CONSTITUENTID;
            end