UFN_FINANCIALTRANSACTION_LINEITEMAPPLICATIONSSOURCE_TOITEMLISTXML

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

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@SOURCELINEITEMID	uniqueidentifier	IN

Definition

Copy



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