USP_IDSMARTFIELD_REVENUEAPPLICATION

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

  if @CALCULATEDREVENUE = 0 or @CALCULATEDREVENUE = 1 
  begin
    --Note that this SP does not need @INCLUDEHISTORICALDATA since that option is household-specific

    exec dbo.[USP_CONSTITUENTIDSMARTFIELD_REVENUESPLIT]    
      @STARTDATE, 
      @ENDDATE, 
      @CALCULATIONTYPE, 
      @CALCULATEDREVENUE, 
      @ASOF,
      @DATETYPECODE, 
      @STARTDATERECENTDATEUNITCODE, 
      @STARTDATERECENTDATEINTERVAL,
      @REVENUETYPECODES, 
      @SELECTIONS, 
      @REVENUEAPPLICATIONSELECTION,
      @RECOGNITIONTYPES,
      @CURRENCYID,
      @SMARTFIELDID,
      @SITES;
  end
  else
  begin
    exec dbo.[USP_CONSTITUENTIDSMARTFIELD_HH_REVENUESPLITANDRECOGNITIONS]    
      @STARTDATE, 
      @ENDDATE, 
      @CALCULATIONTYPE, 
      @CALCULATEDREVENUE, 
      @ASOF,
      @DATETYPECODE, 
      @STARTDATERECENTDATEUNITCODE, 
      @STARTDATERECENTDATEINTERVAL,
      @REVENUETYPECODES, 
      @SELECTIONS, 
      @REVENUEAPPLICATIONSELECTION,
      @RECOGNITIONTYPES, 
      @INCLUDEHISTORICALDATA,
      @CURRENCYID,
      @SMARTFIELDID,
      @SITES;
  end