UFN_CONSTITUENT_MAPFROM_REVENUERECOGNITIONDEFAULT

Maps a revenue recognition credit default to the constituent who owns it.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUERECOGNITIONDEFAULTID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENT_MAPFROM_REVENUERECOGNITIONDEFAULT
            (
                @REVENUERECOGNITIONDEFAULTID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @CONSTITUENTID uniqueidentifier;

                select top 1 
                    @CONSTITUENTID = SOURCECONSTITUENTID
                from dbo.REVENUERECOGNITIONDEFAULT
                where ID = @REVENUERECOGNITIONDEFAULTID;

                return @CONSTITUENTID;
            end