UFN_CONSTITID_MAPFROM_TAXDECLARATIONID

Maps a tax declaration id to a constituent id.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@TAXDECLARATIONID uniqueidentifier IN

Definition

Copy


            CREATE function dbo.UFN_CONSTITID_MAPFROM_TAXDECLARATIONID(@TAXDECLARATIONID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin

                DECLARE @ID uniqueidentifier;

                SELECT @ID=CONSTITUENTID from dbo.TAXDECLARATION where ID=@TAXDECLARATIONID;

                RETURN @ID;

            end