UFN_BANKACCOUNTTRANSACTION_GETGLDISTRIBUTION_FROMITEMLISTXML

CREATE function dbo.UFN_BANKACCOUNTTRANSACTION_GETGLDISTRIBUTION_FROMITEMLISTXML
(
  @ITEMLISTXML xml
)
returns table as
return (
select
  T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
  T.c.value('(TRANSACTIONTYPECODE)[1]','tinyint') AS 'TRANSACTIONTYPECODE',
  T.c.value('(ACCOUNT)[1]','nvarchar(100)') AS 'ACCOUNT',
  T.c.value('(GLACCOUNTID)[1]','uniqueidentifier') AS 'GLACCOUNTID',
  T.c.value('(PROJECT)[1]','nvarchar(100)') AS 'PROJECT',
  T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
  T.c.value('(REFERENCE)[1]','nvarchar(100)') AS 'REFERENCE',
  T.c.value('(ORGANIZATIONAMOUNT)[1]','money') AS 'ORGANIZATIONAMOUNT',
  T.c.value('(BASECURRENCYID)[1]','uniqueidentifier') AS 'BASECURRENCYID',
  T.c.value('(TRANSACTIONAMOUNT)[1]','money') AS 'TRANSACTIONAMOUNT',
  T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID',
  T.c.value('(BASEEXCHANGERATEID)[1]','uniqueidentifier') AS 'BASEEXCHANGERATEID',
  T.c.value('(ORGANIZATIONEXCHANGERATEID)[1]','uniqueidentifier') AS 'ORGANIZATIONEXCHANGERATEID',
  T.c.value('(GLTRANSACTIONID)[1]','uniqueidentifier') AS 'GLTRANSACTIONID'  
  FROM @ITEMLISTXML.nodes('/GLDISTRIBUTION/ITEM') T(c)
)