UFN_CHARGELINEITEMRESPONSIBILITY_TOITEMLISTXML

Returns the charge responsibility collection for a financial transaction in an xml format

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@FINANCIALTRANSACTIONLINEITEMID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CHARGELINEITEMRESPONSIBILITY_TOITEMLISTXML
                (
                    @FINANCIALTRANSACTIONLINEITEMID uniqueidentifier
                )
            returns xml
            with execute as caller
            as begin
                return (
                    select CHARGELINEITEMRESPONSIBILITY.ID, 
                            CHARGELINEITEMRESPONSIBILITY.FINANCIALTRANSACTIONLINEITEMID, 
                            CHARGELINEITEMRESPONSIBILITY.CONSTITUENTID, 
                            CHARGELINEITEMRESPONSIBILITY.PERCENTAGE
                    from dbo.CHARGELINEITEMRESPONSIBILITY
                    where CHARGELINEITEMRESPONSIBILITY.FINANCIALTRANSACTIONLINEITEMID = @FINANCIALTRANSACTIONLINEITEMID
                    for xml raw('ITEM'),type,elements,root('CHARGELINEITEMRESPONSIBILITY'),BINARY BASE64);
            end