UFN_FINANCIALTRANSACTIONLINEITEM_GETJOURNALENTRIES_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  3/19/2013 1:45:45 AM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_FINANCIALTRANSACTIONLINEITEM_GETJOURNALENTRIES
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_FINANCIALTRANSACTIONLINEITEM_GETJOURNALENTRIES_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(ACCOUNT)[1]','nvarchar(100)') AS 'ACCOUNT',
T.c.value('(GLACCOUNTID)[1]','uniqueidentifier') AS 'GLACCOUNTID',
T.c.value('(GLPAYMENTMETHODREVENUETYPEMAPPINGID)[1]','uniqueidentifier') AS 'GLPAYMENTMETHODREVENUETYPEMAPPINGID',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(PROJECT)[1]','nvarchar(100)') AS 'PROJECT',
T.c.value('(REFERENCE)[1]','nvarchar(255)') AS 'REFERENCE',
T.c.value('(TRANSACTIONAMOUNT)[1]','money') AS 'TRANSACTIONAMOUNT',
T.c.value('(TRANSACTIONCURRENCYID)[1]','uniqueidentifier') AS 'TRANSACTIONCURRENCYID',
T.c.value('(TRANSACTIONTYPE)[1]','nvarchar(6)') AS 'TRANSACTIONTYPE',
T.c.value('(TRANSACTIONTYPECODE)[1]','tinyint') AS 'TRANSACTIONTYPECODE'
FROM @ITEMLISTXML.nodes('/GLDISTRIBUTION/ITEM') T(c)
)