UFN_CREDIT_GETSALESORDERITEMS2_TOITEMLISTXML

/*
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_TOITEMLISTXML](
@SALESORDERID uniqueidentifier
    )
returns xml
as
BEGIN

RETURN (
 SELECT 
  [AMOUNTPAID] as [@AMOUNTPAID],
  [DESCRIPTION] as [@DESCRIPTION],
  [DISCOUNTS] as [@DISCOUNTS],
  [EVENTREGISTRANTID] as [@EVENTREGISTRANTID],
  [HASCONTRIBUTEDREVENUE] as [@HASCONTRIBUTEDREVENUE],
  [ISCOMBINATION] as [@ISCOMBINATION],
  [ITEMID] as [@ITEMID],
  [PARENTITEMID] as [@PARENTITEMID],
  [PRICE] as [@PRICE],
  [PROGRAMID] as [@PROGRAMID],
  [REVENUESPLITID] as [@REVENUESPLITID],
  [SALESORDERITEMID] as [@SALESORDERITEMID],
  [SORTFIELD] as [@SORTFIELD],
  [TICKETNUMBER] as [@TICKETNUMBER],
  [TYPECODE] as [@TYPECODE]
 FROM dbo.[UFN_CREDIT_GETSALESORDERITEMS2](@SALESORDERID)
 order by SORTFIELD
 for xml path('ITEM'),type,elements,root('ITEMS'),BINARY BASE64

)

END