USP_SMARTFIELD_AGGREGATEREVENUEAMOUNTS

Parameters

Parameter	Parameter Type	Mode
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@TYPECODES	xml	IN
@DESIGNATIONS	xml	IN
@INCLUDESOFTCREDITS	bit	IN
@CALCULATIONTYPE	tinyint	IN
@ASOF	datetime	IN
@CAMPAIGNS	xml	IN
@DATETYPECODE	tinyint	IN
@STARTDATERECENTDATEUNITCODE	tinyint	IN
@STARTDATERECENTDATEINTERVAL	int	IN
@CURRENCYID	uniqueidentifier	IN
@SMARTFIELDID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_SMARTFIELD_AGGREGATEREVENUEAMOUNTS
            (
                @STARTDATE datetime = null,
                @ENDDATE datetime = null,
                @TYPECODES xml,
                @DESIGNATIONS xml,                
                @INCLUDESOFTCREDITS bit = 0,
                @CALCULATIONTYPE tinyint = 0,
                @ASOF datetime,
                @CAMPAIGNS xml = null,
                @DATETYPECODE tinyint = null,
                @STARTDATERECENTDATEUNITCODE tinyint = null,
                @STARTDATERECENTDATEINTERVAL int = null,
                @CURRENCYID uniqueidentifier = null,
                @SMARTFIELDID uniqueidentifier = null
            )
            as
                set nocount on;
                exec dbo.USP_CONSTITUENTSMARTFIELD_AGGREGATEREVENUEAMOUNTS
                    @STARTDATE, @ENDDATE, @TYPECODES, @DESIGNATIONS, @INCLUDESOFTCREDITS, @CALCULATIONTYPE,
                    @ASOF, @CAMPAIGNS, @DATETYPECODE, @STARTDATERECENTDATEUNITCODE, @STARTDATERECENTDATEINTERVAL, @CURRENCYID,
                    @SMARTFIELDID = @SMARTFIELDID;