UFN_REVENUEUPDATEBATCH_GETAPPLICATIONSTREAM_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  9/30/2015 1:00:17 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_REVENUEUPDATEBATCH_GETAPPLICATIONSTREAM
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_REVENUEUPDATEBATCH_GETAPPLICATIONSTREAM_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(AMOUNTDUE)[1]','money') AS 'AMOUNTDUE',
T.c.value('(APPLICATIONCURRENCYID)[1]','uniqueidentifier') AS 'APPLICATIONCURRENCYID',
T.c.value('(APPLICATIONID)[1]','uniqueidentifier') AS 'APPLICATIONID',
T.c.value('(APPLIED)[1]','money') AS 'APPLIED',
T.c.value('(BALANCE)[1]','money') AS 'BALANCE',
T.c.value('(CONSTITUENTID)[1]','uniqueidentifier') AS 'CONSTITUENTID',
T.c.value('(CONSTITUENTNAME)[1]','nvarchar(255)') AS 'CONSTITUENTNAME',
T.c.value('(DATEDUE)[1]','datetime') AS 'DATEDUE',
T.c.value('(DESCRIPTION)[1]','nvarchar(255)') AS 'DESCRIPTION',
T.c.value('(DESIGNATIONLIST)[1]','nvarchar(512)') AS 'DESIGNATIONLIST',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
cast (T.c.value('(MEMBERSHIPS)[1]','nvarchar(max)') as xml) AS 'MEMBERSHIPS',
T.c.value('(PDACCOUNTSYSTEMID)[1]','uniqueidentifier') AS 'PDACCOUNTSYSTEMID',
T.c.value('(RECEIPTAMOUNT)[1]','money') AS 'RECEIPTAMOUNT',
T.c.value('(REVENUESPLITID)[1]','uniqueidentifier') AS 'REVENUESPLITID',
T.c.value('(SPONSORSHIPOPPORTUNITY)[1]','nvarchar(255)') AS 'SPONSORSHIPOPPORTUNITY',
T.c.value('(SPONSORSHIPRGADDITIONALGIFT)[1]','bit') AS 'SPONSORSHIPRGADDITIONALGIFT',
T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID',
T.c.value('(TYPECODE)[1]','tinyint') AS 'TYPECODE'
FROM @ITEMLISTXML.nodes('/REVENUESTREAMS/ITEM') T(c)
)