UFN_PLEDGEWRITEOFFBATCH_GETINSTALLMENTS_FROMITEMLISTXML

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

                        T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
                        T.c.value('(BALANCE)[1]','money') AS 'BALANCE',
                        T.c.value('(DATE)[1]','datetime') AS 'DATE',
                        T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
                        T.c.value('(INSTALLMENTID)[1]','uniqueidentifier') AS 'INSTALLMENTID',
                        T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
                        T.c.value('(WRITEOFFAMOUNT)[1]','money') AS 'WRITEOFFAMOUNT',
                        T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',
                        T.c.value('(ORGANIZATIONAMOUNT)[1]','money') AS 'ORGANIZATIONAMOUNT',
                        T.c.value('(ORGANIZATIONEXCHANGERATEID)[1]','uniqueidentifier') AS 'ORGANIZATIONEXCHANGERATEID',
                        T.c.value('(TRANSACTIONAMOUNT)[1]','money') AS 'TRANSACTIONAMOUNT',
                        T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID',
                        T.c.value('(BASEEXCHANGERATEID)[1]','uniqueidentifier') AS 'BASEEXCHANGERATEID'
                        FROM @ITEMLISTXML.nodes('/INSTALLMENTS/ITEM') T(c)
                    )