UFN_PLANNEDGIFTASSET_CONVERTAMOUNTSINXML

Fills in multicurrency fields in the given assets XML.
Return

Return Type
xml
Parameters

Parameter	Parameter Type	Mode
@ASSETS	xml	IN
@BASECURRENCYID	uniqueidentifier	IN
@ORGANIZATIONEXCHANGERATEID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
Definition

Copy


            CREATE function dbo.UFN_PLANNEDGIFTASSET_CONVERTAMOUNTSINXML(
                @ASSETS xml,
                @BASECURRENCYID uniqueidentifier,
                @ORGANIZATIONEXCHANGERATEID uniqueidentifier,
                @TRANSACTIONCURRENCYID uniqueidentifier,
                @BASEEXCHANGERATEID uniqueidentifier
            )
            returns xml
            as
            begin    

                declare @ORGANIZATIONCURRENCYID uniqueidentifier = dbo.UFN_CURRENCY_GETORGANIZATIONCURRENCY();

                return (
                    select 
                        ASSETS.ID,
                        ASSETS.ASSETTYPECODEID,
                        ASSETS.DESCRIPTION,
                        CURRENCYVALUES_VALUE.BASEAMOUNT VALUE,
                        CURRENCYVALUES_COSTBASIS.BASEAMOUNT COSTBASIS,
                        ASSETS.ASSETVALUATIONMETHODCODEID,
                        ASSETS.VALUATIONSOURCE,
                        ASSETS.ADDRESSID,
                        ASSETS.SEQUENCE,
                        (
                            select 
                                ASSETHOLDERSXML.ID,
                                ASSETS.ID as PLANNEDGIFTASSETID,
                                ASSETHOLDERSXML.HOLDERCONSTITUENTID
                            from
                                dbo.UFN_PLANNEDGIFT_ASSETHOLDERS_FROMITEMLISTXML(ASSETS.ASSETHOLDERS) as ASSETHOLDERSXML
                            for xml raw('ITEM'), type, elements, binary base64
                        ) ASSETHOLDERS,
                        @BASECURRENCYID BASECURRENCYID,
                        CURRENCYVALUES_VALUE.ORGANIZATIONAMOUNT ORGANIZATIONVALUE,
                        CURRENCYVALUES_COSTBASIS.ORGANIZATIONAMOUNT ORGANIZATIONCOSTBASIS,
                        @ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID,
                        ASSETS.VALUE TRANSACTIONVALUE,
                        ASSETS.COSTBASIS TRANSACTIONCOSTBASIS,
                        @TRANSACTIONCURRENCYID TRANSACTIONCURRENCYID,
                        @BASEEXCHANGERATEID BASEEXCHANGERATEID
                    from dbo.UFN_PLANNEDGIFT_ASSETS_FROMITEMLISTXML(@ASSETS) ASSETS 
                    outer apply dbo.UFN_CURRENCY_GETCURRENCYVALUES_2
                        (
                            VALUE,
                            null,
                            @BASECURRENCYID,
                            @BASEEXCHANGERATEID,
                            @TRANSACTIONCURRENCYID,
                            null,
                            null,
                            null,
                            @ORGANIZATIONEXCHANGERATEID,
                            0
                        ) CURRENCYVALUES_VALUE 
                    outer apply dbo.UFN_CURRENCY_GETCURRENCYVALUES_2
                        (
                            COSTBASIS,
                            null,
                            @BASECURRENCYID,
                            @BASEEXCHANGERATEID,
                            @TRANSACTIONCURRENCYID,
                            null,
                            null,
                            null,
                            @ORGANIZATIONEXCHANGERATEID,
                            0
                        ) CURRENCYVALUES_COSTBASIS    
                    for xml raw('ITEM'),type,elements,root('ASSETS'),BINARY BASE64
                )
            end