USP_DATALIST_RECOGNITIONDEFAULTSBETWEENCONSTITUENTS

Returns recognition defaults between two constituents.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTONEID	uniqueidentifier	IN	First constituent ID
@CONSTITUENTTWOID	uniqueidentifier	IN	Second constituent ID
@MAXROWS	int	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_RECOGNITIONDEFAULTSBETWEENCONSTITUENTS
                (
                    @CONSTITUENTONEID uniqueidentifier,
                    @CONSTITUENTTWOID uniqueidentifier,
                    @MAXROWS int = null
                )
                as
                    set nocount on;

                    if @MAXROWS is not null
                      set rowcount @MAXROWS;

                    select
                        SOURCECONSTITUENTID,
                        RECIPIENTCONSTITUENTID,
                        MATCHFACTOR,
                        REVENUERECOGNITIONTYPECODEID,
                        ARESETTHROUGHMEMBERDEFAULTINGALLOTHERMEMBERS
                    from dbo.UFN_RECOGNITIONDEFAULTS_GETBETWEENTWOCONSTITUENTS(@CONSTITUENTONEID, @CONSTITUENTTWOID);

                    set rowcount 0;