UFN_FINANCIALTRANSACTION_LINEITEMAPPLICATIONSTARGET_TOITEMLISTXML

Returns an xml representation of all the application line items on a given applied to line item.

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@TARGETLINEITEMID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_FINANCIALTRANSACTION_LINEITEMAPPLICATIONSTARGET_TOITEMLISTXML
                (
                    @TARGETLINEITEMID uniqueidentifier
                )
            returns xml
            with execute as caller
            as begin
                return (
                    select FINANCIALTRANSACTIONLINEITEM.ID,
                            FINANCIALTRANSACTIONLINEITEM.SOURCELINEITEMID,
                            FINANCIALTRANSACTIONLINEITEM.TARGETLINEITEMID,
                            FINANCIALTRANSACTIONLINEITEM.TRANSACTIONAMOUNT as AMOUNT
                    from FINANCIALTRANSACTIONLINEITEM
                    where FINANCIALTRANSACTIONLINEITEM.TARGETLINEITEMID = @TARGETLINEITEMID
                    for xml raw('ITEM'),type,elements,root('APPLICATIONS'),BINARY BASE64);
            end