UFN_REVENUESOLICITOR_CONVERTAMOUNTSINXML

Fills in multicurrency fields in the given solicitors XML.

Return

Return Type
xml

Parameters

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

Definition

Copy



            create function dbo.UFN_REVENUESOLICITOR_CONVERTAMOUNTSINXML(
                @SOLICITORS xml,
                @BASECURRENCYID uniqueidentifier,
                @ORGANIZATIONEXCHANGERATEID uniqueidentifier
            )
            returns xml
            as
            begin

                declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

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

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