UFN_REVENUEUPDATEBATCH_GETMATCHINGGIFTS_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  9/29/2016 3:35:29 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.163.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_REVENUEUPDATEBATCH_GETMATCHINGGIFTS
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_REVENUEUPDATEBATCH_GETMATCHINGGIFTS_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
T.c.value('(APPLYBYPERCENT)[1]','int') AS 'APPLYBYPERCENT',
T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',
T.c.value('(BASEEXCHANGERATEID)[1]','uniqueidentifier') AS 'BASEEXCHANGERATEID',
T.c.value('(COULDNOTDEFAULTMATCHINGGIFT)[1]','int') AS 'COULDNOTDEFAULTMATCHINGGIFT',
T.c.value('(DATE)[1]','datetime') AS 'DATE',
T.c.value('(EXCHANGERATE)[1]','decimal(20, 8)') AS 'EXCHANGERATE',
T.c.value('(HASPAIDMATCHINGGIFT)[1]','int') AS 'HASPAIDMATCHINGGIFT',
T.c.value('(ID)[1]','varchar(36)') AS 'ID',
T.c.value('(MATCHINGCONSTITUENTID)[1]','uniqueidentifier') AS 'MATCHINGCONSTITUENTID',
T.c.value('(MATCHINGGIFTCONDITIONID)[1]','uniqueidentifier') AS 'MATCHINGGIFTCONDITIONID',
T.c.value('(OPPORTUNITYID)[1]','uniqueidentifier') AS 'OPPORTUNITYID',
T.c.value('(ORGANIZATIONID)[1]','uniqueidentifier') AS 'ORGANIZATIONID',
T.c.value('(ORIGINALGIFTTRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'ORIGINALGIFTTRANSACTIONCURRENCYID',
T.c.value('(RELATIONSHIPCONTEXTID)[1]','varchar(1)') AS 'RELATIONSHIPCONTEXTID',
T.c.value('(RELATIONSHIPID)[1]','uniqueidentifier') AS 'RELATIONSHIPID',
T.c.value('(REVENUEMATCHINGGIFTID)[1]','uniqueidentifier') AS 'REVENUEMATCHINGGIFTID',
T.c.value('(SINGLEDESIGNATIONID)[1]','uniqueidentifier') AS 'SINGLEDESIGNATIONID',
cast (T.c.value('(SPLITS)[1]','nvarchar(max)') as xml) AS 'SPLITS',
T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID'
FROM @ITEMLISTXML.nodes('/MATCHINGGIFTS/ITEM') T(c)
)