UFN_PLANNEDGIFTADDITION_GETASSETS_TOITEMLISTXML
Used to convert the results of UFN_PLANNEDGIFTADDITION_GETASSETS to xml.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PLANNEDGIFTADDITIONID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_PLANNEDGIFTADDITION_GETASSETS_TOITEMLISTXML]
(
@PLANNEDGIFTADDITIONID uniqueidentifier
)
returns xml
as
begin
return (
select
[ADDRESSID],
[ASSETHOLDERS],
[ASSETTYPECODEID],
[ASSETVALUATIONMETHODCODEID],
[BASECURRENCYID],
[BASEEXCHANGERATEID],
[COSTBASIS],
[DESCRIPTION],
[ID],
[ORGANIZATIONCOSTBASIS],
[ORGANIZATIONEXCHANGERATEID],
[ORGANIZATIONVALUE],
[SEQUENCE],
[TRANSACTIONCOSTBASIS],
[TRANSACTIONCURRENCYID],
[TRANSACTIONVALUE],
[VALUATIONSOURCE],
[VALUE]
from dbo.[UFN_PLANNEDGIFTADDITION_GETASSETS](@PLANNEDGIFTADDITIONID)
for xml raw('ITEM'),type,elements,root('ASSETS'),BINARY BASE64
)
END