UFN_CREDIT_GETORDERPAYMENTS_2_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:26:27 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_CREDIT_GETORDERPAYMENTS_2
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_CREDIT_GETORDERPAYMENTS_2_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(@AMOUNTPAID)[1]','money') AS 'AMOUNTPAID',
T.c.value('(@DESCRIPTION)[1]','nvarchar(144)') AS 'DESCRIPTION',
T.c.value('(@DISPLAYDESCRIPTION)[1]','nvarchar(166)') AS 'DISPLAYDESCRIPTION',
T.c.value('(@DISPLAYSOURCE)[1]','int') AS 'DISPLAYSOURCE',
T.c.value('(@INCLUDE)[1]','bit') AS 'INCLUDE',
T.c.value('(@OTHERPAYMENTMETHODCODEID)[1]','uniqueidentifier') AS 'OTHERPAYMENTMETHODCODEID',
T.c.value('(@PAYMENTDATE)[1]','datetime') AS 'PAYMENTDATE',
T.c.value('(@PAYMENTTYPECODE)[1]','tinyint') AS 'PAYMENTTYPECODE',
T.c.value('(@REFUNDAMOUNT)[1]','int') AS 'REFUNDAMOUNT',
T.c.value('(@REVENUEID)[1]','uniqueidentifier') AS 'REVENUEID',
T.c.value('(@REVENUESPLITID)[1]','uniqueidentifier') AS 'REVENUESPLITID',
T.c.value('(@SOURCENUMBER)[1]','int') AS 'SOURCENUMBER',
T.c.value('(@SOURCETYPE)[1]','int') AS 'SOURCETYPE',
T.c.value('(@TRANSACTIONID)[1]','uniqueidentifier') AS 'TRANSACTIONID'
FROM @ITEMLISTXML.nodes('/PAYMENTS/ITEM') T(c)
)