UFN_CREDIT_GETSALESORDERITEMS2_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  11/11/2014 4:26:05 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_CREDIT_GETSALESORDERITEMS2
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_CREDIT_GETSALESORDERITEMS2_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(@AMOUNTPAID)[1]','money') AS 'AMOUNTPAID',
T.c.value('(@DESCRIPTION)[1]','nvarchar(510)') AS 'DESCRIPTION',
T.c.value('(@DISCOUNTS)[1]','money') AS 'DISCOUNTS',
T.c.value('(@EVENTREGISTRANTID)[1]','uniqueidentifier') AS 'EVENTREGISTRANTID',
T.c.value('(@HASCONTRIBUTEDREVENUE)[1]','bit') AS 'HASCONTRIBUTEDREVENUE',
T.c.value('(@ISCOMBINATION)[1]','bit') AS 'ISCOMBINATION',
T.c.value('(@ITEMID)[1]','uniqueidentifier') AS 'ITEMID',
T.c.value('(@PARENTITEMID)[1]','uniqueidentifier') AS 'PARENTITEMID',
T.c.value('(@PRICE)[1]','money') AS 'PRICE',
T.c.value('(@PROGRAMID)[1]','uniqueidentifier') AS 'PROGRAMID',
T.c.value('(@REVENUESPLITID)[1]','uniqueidentifier') AS 'REVENUESPLITID',
T.c.value('(@SALESORDERITEMID)[1]','uniqueidentifier') AS 'SALESORDERITEMID',
T.c.value('(@SORTFIELD)[1]','nvarchar(200)') AS 'SORTFIELD',
T.c.value('(@TICKETNUMBER)[1]','bigint') AS 'TICKETNUMBER',
T.c.value('(@TYPECODE)[1]','tinyint') AS 'TYPECODE'
FROM @ITEMLISTXML.nodes('/ITEMS/ITEM') T(c)
)