UFN_PLEDGEWRITEOFFBATCH_GETRECOGNITIONCREDITS_FROMITEMLISTXML

            CREATE FUNCTION [dbo].[UFN_PLEDGEWRITEOFFBATCH_GETRECOGNITIONCREDITS_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
                RETURN (
                        SELECT

                        T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
                        T.c.value('(REVENUESPLITID)[1]','uniqueidentifier') AS 'REVENUESPLITID',
                        T.c.value('(DESIGNATIONNAME)[1]','nvarchar(255)') AS 'DESIGNATIONNAME',
                        T.c.value('(CONSTITUENTNAME)[1]','nvarchar(255)') AS 'CONSTITUENTNAME',
                        T.c.value('(RECOGNITIONCREDITTYPE)[1]','nvarchar(255)') AS 'RECOGNITIONCREDITTYPE',
                        T.c.value('(EFFECTIVEDATE)[1]','datetime') AS 'EFFECTIVEDATE',
                        T.c.value('(ORIGINALAMOUNT)[1]','money') AS 'ORIGINALAMOUNT',
                        T.c.value('(ADJUSTEDAMOUNT)[1]','money') AS 'ADJUSTEDAMOUNT',
                        T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID'
                        FROM @ITEMLISTXML.nodes('/RECOGNITIONCREDITS/ITEM') T(c)
                    )