USP_DATALIST_REVENUESOLICITOR

This data list returns a list of solicitors who are credited in a revenue detail with a revenue context.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            CREATE procedure dbo.USP_DATALIST_REVENUESOLICITOR(@ID uniqueidentifier)
            as
                set nocount on;

                select
                    REVENUESOLICITOR.ID,
                    NF.NAME,
                    REVENUESOLICITOR.AMOUNT,
                    REVENUESOLICITOR.SEQUENCE,
                    REVENUESOLICITOR.CONSTITUENTID,
                    REVENUESOLICITOR.BASECURRENCYID
                from 
                    dbo.REVENUESOLICITOR
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(REVENUESOLICITOR.CONSTITUENTID) NF
                where 
                    REVENUESOLICITOR.REVENUESPLITID = @ID
                order 
                    by REVENUESOLICITOR.SEQUENCE;