UFN_RECEIVABLEPAYMENTAPPLICATIONS_TOITEMLISTXML
Used to convert the results of UFN_RECEIVABLEPAYMENTAPPLICATIONS to xml.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECEIVABLEPAYMENTLINEITEMID | uniqueidentifier | IN | |
| @RECEIVABLEPAYMENTOWNERID | uniqueidentifier | IN | |
| @INCLUDEPOSSIBLEAPPLICATIONS | bit | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/2/2010 7:16:24 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Based on: UFN_RECEIVABLEPAYMENTAPPLICATIONS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_RECEIVABLEPAYMENTAPPLICATIONS_TOITEMLISTXML](
@RECEIVABLEPAYMENTLINEITEMID uniqueidentifier
, @RECEIVABLEPAYMENTOWNERID uniqueidentifier
, @INCLUDEPOSSIBLEAPPLICATIONS bit
)
returns xml
as
BEGIN
RETURN (
SELECT [AMOUNT], [APPLICATIONDATE], [APPLIEDTOID], [APPLIEDTOLINEITEMDESCRIPTION], [APPLIEDTOLINEITEMID], [BILLINGITEMNAME], [CHARGEAMOUNT], [CHARGEAMOUNTREMAINING], [CHARGEDUEDATE], [DATE], [ID], [NAME], [SOURCELINEITEMID]
FROM dbo.[UFN_RECEIVABLEPAYMENTAPPLICATIONS](@RECEIVABLEPAYMENTLINEITEMID, @RECEIVABLEPAYMENTOWNERID, @INCLUDEPOSSIBLEAPPLICATIONS)
order by DATE
for xml raw('ITEM'),type,elements,root('APPLICATIONS'),BINARY BASE64
)
END