UFN_PLANNEDGIFTPAYOUT_GETGLDISTRIBUTION_TOITEMLISTXML
Gets the payout distributions for Planned Gifts.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_PLANNEDGIFTPAYOUT_GETGLDISTRIBUTION_TOITEMLISTXML
(
@REVENUEID uniqueidentifier
)
returns xml
as
begin
return (
select
[ACCOUNT],
[AMOUNT],
[DEBITCREDIT],
[GLPAYMENTMETHODREVENUETYPEMAPPINGID],
[ID],
[PROJECT],
[REFERENCE],
[TRANSACTIONTYPECODE],
[ORGANIZATIONAMOUNT],
[BASECURRENCYID],
[TRANSACTIONAMOUNT],
[TRANSACTIONCURRENCYID],
[BASEEXCHANGERATEID],
[ORGANIZATIONEXCHANGERATEID]
from
dbo.[UFN_PLANNEDGIFTPAYOUT_GETGLDISTRIBUTION](@REVENUEID)
for xml raw('ITEM'),type,elements,root('GLDISTRIBUTION'),BINARY BASE64
)
end