USP_SMARTFIELD_REVENUEAPPLICATIONAMOUNTS

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
@CURRENCYID	uniqueidentifier	IN
@SMARTFIELDID	uniqueidentifier	IN
@SITES	xml	IN

Definition

Copy


CREATE procedure dbo.USP_SMARTFIELD_REVENUEAPPLICATIONAMOUNTS (
  @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
  ,@CURRENCYID uniqueidentifier = 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
  ,@CURRENCYID
  ,@SMARTFIELDID = @SMARTFIELDID
  ,@SITES = @SITES;