UFN_REVENUEBATCH_GETUNAPPLIEDMATCHINGGIFTSPLITS_FROMITEMLISTXML

            CREATE FUNCTION dbo.UFN_REVENUEBATCH_GETUNAPPLIEDMATCHINGGIFTSPLITS_FROMITEMLISTXML(@ITEMLISTXML xml) RETURNS TABLE AS
            RETURN (
            SELECT

            T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
            T.c.value('(DESIGNATIONID)[1]','uniqueidentifier') AS 'DESIGNATIONID',
            T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
            T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE'
            FROM @ITEMLISTXML.nodes('/UNAPPLIEDMATCHINGGIFTSPLITS/ITEM') T(c)
            )