UFN_BBNC_GETCONSTITACCOUNTIDFROMMAPID

Returns the CONSTITUENTACCOUNT ID for the specified integer bank mapping ID for Blackbaud Internet Solutions.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETCONSTITACCOUNTIDFROMMAPID(@ID int) 
            returns uniqueidentifier
            as begin
                return (
                    select top 1 CONSTITUENTACCOUNTID
                    from dbo.BBNCCONSTITACCOUNTIDMAP
                    where ID = @ID
                    )
            end