USP_SMARTFIELD_REVENUEAPPLICATIONANNUALRENEWER

Parameters

Parameter	Parameter Type	Mode
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@CALCULATIONTYPE	tinyint	IN
@CALCULATEDREVENUE	tinyint	IN
@ASOF	datetime	IN
@DATETYPECODE	tinyint	IN
@STARTDATERECENTDATEUNITCODE	tinyint	IN
@STARTDATERECENTDATEINTERVAL	int	IN
@REVENUETYPECODES	xml	IN
@SELECTIONS	xml	IN
@REVENUEAPPLICATIONSELECTION	uniqueidentifier	IN
@RECOGNITIONTYPES	xml	IN
@INCLUDEHISTORICALDATA	bit	IN
@SMARTFIELDID	uniqueidentifier	IN
@SITES	xml	IN

Definition

Copy



            CREATE procedure dbo.USP_SMARTFIELD_REVENUEAPPLICATIONANNUALRENEWER
            (
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @CALCULATIONTYPE tinyint,
                @CALCULATEDREVENUE tinyint,
                @ASOF datetime,                
                @DATETYPECODE tinyint = null,
                @STARTDATERECENTDATEUNITCODE tinyint = null,
                @STARTDATERECENTDATEINTERVAL int = null,        
                @REVENUETYPECODES xml = null,
                @SELECTIONS xml = null,                
                @REVENUEAPPLICATIONSELECTION uniqueidentifier = null,
                @RECOGNITIONTYPES xml = null,
                @INCLUDEHISTORICALDATA bit = null,
                @SMARTFIELDID uniqueidentifier = null,
                @SITES xml = null
            )
            as
                set nocount on;

                if not exists (select T.c.value('(SITEID)[1]','uniqueidentifier') from @SITES.nodes('/SITES/ITEM') T(c))
                    set @SITES = null;

                exec dbo.USP_CONSTITUENTSMARTFIELD_UNIFIEDRECOGNITIONANDREVENUE    @STARTDATE, @ENDDATE, @CALCULATIONTYPE, 
                                                                                @CALCULATEDREVENUE, @ASOF, @DATETYPECODE,
                                                                                @STARTDATERECENTDATEUNITCODE, @STARTDATERECENTDATEINTERVAL, 
                                                                                @REVENUETYPECODES, @SELECTIONS, @REVENUEAPPLICATIONSELECTION,
                                                                                @RECOGNITIONTYPES, @INCLUDEHISTORICALDATA,
                                                                                @SMARTFIELDID = @SMARTFIELDID, @SITES = @SITES;