UFN_INSTALLMENT_GETINSTALLMENTS_2_FROMITEMLISTXML

            CREATE function dbo.UFN_INSTALLMENT_GETINSTALLMENTS_2_FROMITEMLISTXML
            (
                @ITEMLISTXML xml
            )
            returns table
            as return
            (
                select
                    T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
                    T.c.value('(APPLIED)[1]','money') AS 'APPLIED',
                    T.c.value('(BALANCE)[1]','money') AS 'BALANCE',
                    T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',
                    T.c.value('(BASEEXCHANGERATEID)[1]','uniqueidentifier') AS 'BASEEXCHANGERATEID',
                    T.c.value('(DATE)[1]','datetime') AS 'DATE',
                    T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
                    cast (T.c.value('(INSTALLMENTSPLITS)[1]','nvarchar(max)') as xml) AS 'INSTALLMENTSPLITS',
                    T.c.value('(ORGANIZATIONAMOUNT)[1]','money') AS 'ORGANIZATIONAMOUNT',
                    T.c.value('(ORGANIZATIONEXCHANGERATEID)[1]','uniqueidentifier') AS 'ORGANIZATIONEXCHANGERATEID',
                    T.c.value('(SEQUENCE)[1]','int') AS 'SEQUENCE',
                    T.c.value('(TRANSACTIONAMOUNT)[1]','money') AS 'TRANSACTIONAMOUNT',
                    T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID',
                    coalesce (T.c.value('(RECEIPTAMOUNT)[1]','money'), 0) AS 'RECEIPTAMOUNT',
                    coalesce (T.c.value('(TRANSACTIONRECEIPTAMOUNT)[1]','money'), 0) AS 'TRANSACTIONRECEIPTAMOUNT',
                    coalesce (T.c.value('(ORGANIZATIONRECEIPTAMOUNT)[1]','money'), 0) AS 'ORGANIZATIONRECEIPTAMOUNT'
                FROM @ITEMLISTXML.nodes('/INSTALLMENTS/ITEM') T(c)
            )