USP_SMARTFIELD_REVENUEAPPLICATIONDATES

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_REVENUEAPPLICATIONDATES
(
  @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;