UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK_TOITEMLISTXML
Return
Return Type |
---|
xml |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:28:21 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Based on: UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK_TOITEMLISTXML](
)
returns xml
as
BEGIN
RETURN (
SELECT
[BALANCE],
[DATE],
[ID],
[REVENUEID],
[STATUSCODE],
[TRANSACTIONAMOUNT],
[WRITEOFFAMOUNT]
FROM dbo.[UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS_BULK]()
order by DATE, ID
for xml path('ITEM'),type,elements,root('INSTALLMENTS'),BINARY BASE64
)
END