UFN_BANKACCOUNTDISBURSEMENTTRANSACTIONS_FROMITEMLISTXML

CREATE function dbo.UFN_BANKACCOUNTDISBURSEMENTTRANSACTIONS_FROMITEMLISTXML(
  @ITEMLISTXML xml
) RETURNS TABLE AS
RETURN (
SELECT
    T.c.value('(BANKACCOUNTTRANSACTIONID)[1]', 'uniqueidentifier') AS 'BANKACCOUNTTRANSACTIONID',
    T.c.value('(DELETE)[1]','bit') AS 'DELETE',
    T.c.value('(TRANSACTIONID)[1]','uniqueidentifier') AS 'TRANSACTIONID',
    T.c.value('(NUMBER)[1]','nvarchar(60)') AS 'NUMBER',
    T.c.value('(DATE)[1]','datetime') AS 'DATE',
      T.c.value('(DESCRIPTION)[1]','nvarchar(1000)') AS 'DESCRIPTION',
      T.c.value('(DATEDUE)[1]','datetime') AS 'DATEDUE',
      T.c.value('(SCHEDULEDAMOUNT)[1]','money') AS 'SCHEDULEDAMOUNT',
      T.c.value('(INVOICEAMOUNT)[1]','money') AS 'INVOICEAMOUNT',
      T.c.value('(POSTSTATUSCODE)[1]','tinyint') AS 'POSTSTATUSCODE',
      T.c.value('(POSTDATE)[1]','datetime') AS 'POSTDATE',
        T.c.value('(TYPECODE)[1]','tinyint') AS 'TYPECODE',
      T.c.value('(REVERSALSTATUSCODE)[1]','tinyint') AS 'REVERSALSTATUSCODE',
      T.c.value('(REVERSEON)[1]','tinyint') AS 'REVERSEON',
      T.c.value('(REVERSALPOSTDATE)[1]','datetime') AS 'REVERSALPOSTDATE',
      T.c.value('(TRANSACTIONTYPE)[1]','nvarchar(23)') AS 'TRANSACTIONTYPE'

  FROM @ITEMLISTXML.nodes('/TRANSACTIONS/ITEM') T(c)
)