UFN_PLANNEDGIFT_ASSETS_2_TOITEMLISTXML

Used to convert the results of UFN_PLANNEDGIFT_ASSETS_2 to xml.
Return

Return Type
xml
Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN
Definition

Copy


            create function dbo.UFN_PLANNEDGIFT_ASSETS_2_TOITEMLISTXML
            (
                @PLANNEDGIFTID uniqueidentifier
            ) returns xml as
            begin
                return (
                    select
                        PLANNEDGIFTASSET.ID,
                        PLANNEDGIFTASSET.ADDRESSID, 
                        PLANNEDGIFTASSET.ASSETTYPECODEID,
                        PLANNEDGIFTASSET.ASSETVALUATIONMETHODCODEID,
                        PLANNEDGIFTASSET.COSTBASIS,
                        PLANNEDGIFTASSET.DESCRIPTION,
                        PLANNEDGIFTASSET.SEQUENCE,
                        PLANNEDGIFTASSET.VALUATIONSOURCE,
                        PLANNEDGIFTASSET.VALUE,
                        (
                            select 
                                ID, PLANNEDGIFTASSETID, HOLDERCONSTITUENTID
                            from
                                dbo.PLANNEDGIFTASSETHOLDER
                            where
                                PLANNEDGIFTASSETHOLDER.PLANNEDGIFTASSETID = PLANNEDGIFTASSET.ID
                            for xml raw('ITEM'), type, elements, binary base64
                        ) ASSETHOLDERS,
                        PLANNEDGIFTASSET.BASECURRENCYID,
                        PLANNEDGIFTASSET.ORGANIZATIONVALUE,
                        PLANNEDGIFTASSET.ORGANIZATIONCOSTBASIS,
                        PLANNEDGIFTASSET.ORGANIZATIONEXCHANGERATEID,
                        PLANNEDGIFTASSET.TRANSACTIONVALUE,
                        PLANNEDGIFTASSET.TRANSACTIONCOSTBASIS,
                        PLANNEDGIFTASSET.TRANSACTIONCURRENCYID,
                        PLANNEDGIFTASSET.BASEEXCHANGERATEID
                    from
                        dbo.PLANNEDGIFTASSET
                    where
                        PLANNEDGIFTASSET.PLANNEDGIFTID = @PLANNEDGIFTID
                    order by 
                        SEQUENCE
                    for xml raw('ITEM'), type, elements, root('ASSETS'), BINARY BASE64
                )
            end