UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONS_TOITEMLISTXML
The TOITEMLISTXML collection function for UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONS.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHREVENUEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONS_TOITEMLISTXML
(
@BATCHREVENUEID uniqueidentifier
)
returns xml
as
begin
return
(
select
APPLIED,
CAMPAIGNS,
DECLINESGIFTAID,
DESIGNATIONID,
CATEGORYCODEID,
DIDCAMPAIGNSDEFAULT,
ID,
ISGIFTAIDSPONSORSHIP,
OPPORTUNITYID,
OTHERTYPECODEID,
SPONSORSHIPID,
TYPECODE,
REVENUESPLITID
from dbo.UFN_REVENUEBATCH_GETADDITIONALAPPLICATIONS(@BATCHREVENUEID)
for xml raw('ITEM'),type,elements,root('ADDITIONALAPPLICATIONSSTREAM'),binary base64
);
end