UFN_DESIGNATIONLEVELGIFTFEE_CONVERTAMOUNTSINXML

Fills in multicurrency fields in the given gift fees XML.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode
@GIFTFEESTRUCTURE	xml	IN
@BASECURRENCYID	uniqueidentifier	IN
@ORGANIZATIONEXCHANGERATEID	uniqueidentifier	IN
@USEORGANIZATIONCURRENCY	bit	IN

Definition

Copy



            create function dbo.UFN_DESIGNATIONLEVELGIFTFEE_CONVERTAMOUNTSINXML(
                @GIFTFEESTRUCTURE xml,
                @BASECURRENCYID uniqueidentifier,
                @ORGANIZATIONEXCHANGERATEID uniqueidentifier,
                @USEORGANIZATIONCURRENCY bit
            )
            returns xml
            as
            begin

                declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                return (
                    select 
                        ID,
                        FROMAMOUNT,
                        FEE,
                        @BASECURRENCYID BASECURRENCYID,
                        case
                            when @BASECURRENCYID <> @ORGANIZATIONCURRENCYID
                                then dbo.UFN_CURRENCY_CONVERT(FROMAMOUNT, @ORGANIZATIONEXCHANGERATEID)
                            else FROMAMOUNT
                        end ORGANIZATIONFROMAMOUNT,
                        @ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID,
                        @USEORGANIZATIONCURRENCY USEORGANIZATIONCURRENCY

                    from dbo.UFN_DESIGNATIONLEVELGIFTFEE_GETGIFTFEESTRUCTURE_2_FROMITEMLISTXML(@GIFTFEESTRUCTURE)
                    for xml raw('ITEM'),type,elements,root('GIFTFEESTRUCTURE'),BINARY BASE64
                )
            end