UFN_REVENUEBATCH_GETAPPLICATIONS_FROMITEMLISTXML

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

T.c.value('(AMOUNTDUE)[1]','money') AS 'AMOUNTDUE',
T.c.value('(APPLICATIONCOMMITMENTID)[1]','uniqueidentifier') AS 'APPLICATIONCOMMITMENTID',
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('(BATCHREVENUEREGISTRANTID)[1]','uniqueidentifier') AS 'BATCHREVENUEREGISTRANTID',
T.c.value('(CATEGORYCODEID)[1]','uniqueidentifier') AS 'CATEGORYCODEID',
T.c.value('(CONSTITUENTID)[1]','uniqueidentifier') AS 'CONSTITUENTID',
T.c.value('(CONSTITUENTNAME)[1]','nvarchar(700)') AS 'CONSTITUENTNAME',
T.c.value('(DATEDUE)[1]','datetime') AS 'DATEDUE',
T.c.value('(DESCRIPTION)[1]','nvarchar(300)') AS 'DESCRIPTION',
T.c.value('(DESIGNATIONLIST)[1]','nvarchar(300)') AS 'DESIGNATIONLIST',
T.c.value('(DONOTRECEIPT)[1]','bit') AS 'DONOTRECEIPT',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(OVERPAYMENTAPPLICATIONTYPECODE)[1]','tinyint') AS 'OVERPAYMENTAPPLICATIONTYPECODE',
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(300)') AS 'SPONSORSHIPOPPORTUNITY',
T.c.value('(SPONSORSHIPRGADDITIONALGIFT)[1]','bit') AS 'SPONSORSHIPRGADDITIONALGIFT',
T.c.value('(TYPECODE)[1]','tinyint') AS 'TYPECODE',
T.c.value('(WASGENERATED)[1]','bit') AS 'WASGENERATED'
FROM @ITEMLISTXML.nodes('/REVENUESTREAMS/ITEM') T(c)
)