UFN_PDACCOUNTCODEMAP_GETGIFTFEEDESCRIPTION

Returns the description of the account code mapping with the given ID from the GIFTFEEGLDISTRIBUTION table.

Return

Return Type
nvarchar(30)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_PDACCOUNTCODEMAP_GETGIFTFEEDESCRIPTION(@ID uniqueidentifier)
            returns nvarchar(30)
            with execute as caller
            as begin
                declare @S nvarchar(30)
                select @S = T2.DESCRIPTION
                from dbo.GIFTFEEGLDISTRIBUTION T1
                    inner join dbo.GLPAYMENTMETHODREVENUETYPEMAPPING T2 
                    on T1.GLPAYMENTMETHODREVENUETYPEMAPPINGID = T2.ID
                where
                    T1.ID = @ID
                return @S
            end