UFN_RECURRINGGIFTINSTALLMENTACTIVITY_FROMITEMLISTXML

/*
Generated by Blackbaud AppFx Platform
Date:  12/15/2016 8:40:58 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.165.0, Culture=neutral, PublicKeyToken=null
Based on:  UFN_RECURRINGGIFTINSTALLMENTACTIVITY
Copyright Blackbaud
*/
CREATE FUNCTION dbo.[UFN_RECURRINGGIFTINSTALLMENTACTIVITY_FROMITEMLISTXML](@ITEMLISTXML xml) RETURNS TABLE AS
RETURN (
SELECT

T.c.value('(ACTIVITY)[1]','nvarchar(100)') AS 'ACTIVITY',
T.c.value('(AMOUNT)[1]','money') AS 'AMOUNT',
T.c.value('(BALANCE)[1]','money') AS 'BALANCE',
T.c.value('(CURRENCYID)[1]','uniqueidentifier') AS 'CURRENCYID',
T.c.value('(DATE)[1]','date') AS 'DATE',
T.c.value('(DETAILS)[1]','nvarchar(500)') AS 'DETAILS',
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(SEQUENCE)[1]','smallint') AS 'SEQUENCE',
T.c.value('(TYPECODE)[1]','tinyint') AS 'TYPECODE'
FROM @ITEMLISTXML.nodes('/INSTALLMENTACTIVITY/ITEM') T(c)
)