UFN_MEMBERSHIPLEVELTERMS_CONVERTAMOUNTSINXML

Fills in multicurrency fields in the given membership level terms XML.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode
@TERMS	xml	IN
@BASECURRENCYID	uniqueidentifier	IN
@ORGANIZATIONEXCHANGERATEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_MEMBERSHIPLEVELTERMS_CONVERTAMOUNTSINXML(
                @TERMS xml,
                @BASECURRENCYID uniqueidentifier,
                @ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )
            returns xml
            as
            begin

                declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                return (
                    select 
                        ID,
                        TERMCODE,
                        AMOUNT,
                        SEQUENCE,
                        @BASECURRENCYID BASECURRENCYID,
                        case
                            when @BASECURRENCYID <> @ORGANIZATIONCURRENCYID
                                then dbo.UFN_CURRENCY_CONVERT(AMOUNT, @ORGANIZATIONEXCHANGERATEID)
                            else AMOUNT
                        end ORGANIZATIONAMOUNT,
                        @ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID

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