UFN_TRANSLATIONFUNCTION_PDACCOUNTCODEMAPCURRENCY

Return

Return Type
nvarchar(110)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_TRANSLATIONFUNCTION_PDACCOUNTCODEMAPCURRENCY
                (
                    @ID uniqueidentifier
                )
                returns nvarchar(110)
                with execute as caller
                as
                begin
                    declare @CURRENCYNAME nvarchar(110);

                    select 
                        @CURRENCYNAME = NAME
                    from
                        dbo.CURRENCY
                    where
                        ID = @ID;

                    return isnull(@CURRENCYNAME, '');
                end