UFN_REVENUETRIBUTE_CONVERTAMOUNTSINXML

Fills in multicurrency fields in the given tributes XML.

Return

Return Type
xml

Parameters

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

Definition

Copy



            create function dbo.UFN_REVENUETRIBUTE_CONVERTAMOUNTSINXML(
                @TRIBUTES xml,
                @BASECURRENCYID uniqueidentifier,
                @ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )
            returns xml
            as
            begin

                declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

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

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