UFN_REVENUEBATCH_GETUNAPPLIEDMATCHINGGIFTSPLITS_TOITEMLISTXML
Gets a table with unapplied matching gift splits from an xml string
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHREVENUEID | uniqueidentifier | IN |
Definition
Copy
CREATE FUNCTION dbo.UFN_REVENUEBATCH_GETUNAPPLIEDMATCHINGGIFTSPLITS_TOITEMLISTXML(
@BATCHREVENUEID uniqueidentifier
)
returns xml
as
BEGIN
RETURN (
SELECT AMOUNT, DESIGNATIONID, ID, SEQUENCE
FROM dbo.UFN_REVENUEBATCH_GETUNAPPLIEDMATCHINGGIFTSPLITS(@BATCHREVENUEID)
for xml raw('ITEM'),type,elements,root('UNAPPLIEDMATCHINGGIFTSPLITS'),BINARY BASE64
)
END