USP_SMARTFIELD_AGGREGATEHOUSEHOLDREVENUEAMOUNTS

Parameters

Parameter	Parameter Type	Mode
@STARTDATE	datetime	IN
@ENDDATE	datetime	IN
@TYPECODES	xml	IN
@DESIGNATIONS	xml	IN
@AMOUNTCODES	xml	IN
@CALCULATIONTYPE	tinyint	IN
@ASOF	datetime	IN
@CAMPAIGNS	xml	IN
@CURRENCYID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_SMARTFIELD_AGGREGATEHOUSEHOLDREVENUEAMOUNTS
(
    @STARTDATE datetime = null,
    @ENDDATE datetime = null,
    @TYPECODES xml = null,
    @DESIGNATIONS xml = null,
    @AMOUNTCODES xml = null,
    @CALCULATIONTYPE tinyint = 0,
    @ASOF datetime = null,
    @CAMPAIGNS xml = null,
    @CURRENCYID uniqueidentifier = null
)
as
    set nocount on;
    exec dbo.USP_HOUSEHOLDSMARTFIELD_AGGREGATEREVENUEAMOUNTS @STARTDATE, @ENDDATE, @TYPECODES, @DESIGNATIONS, 
                                                             @AMOUNTCODES, @CALCULATIONTYPE, @ASOF,@CAMPAIGNS, null, null, null, 0, @CURRENCYID;