SSIS Components for Act! CRM

Build 24.0.9062

ForecastByRepDetails

Generates forecasted opportunity data by a given user.

Table Specific Information

Select

The 本製品 will use the Act! CRM API to process WHERE clause conditions built with the following column and operator. UserId is required to make a request and the rest of the filter is executed client-side within the 本製品.

  • UserId supports the '=' operator.

The 本製品 processes other filters client-side within the 本製品. For example, the following queries are processed server side:

SELECT * FROM ForecastByRepDetails where UserID = 'b7c23fa5-6cd3-4bcd-a036-f8bbb85ba760'

Columns

Name Type Description
EstCloseDate Datetime Est Close Date
OppName String Opp Name
ProbabilityPct Integer Probablity Pct
RepName String Rep Name
Status String Status
WeightedValue Decimal Weighted Value
UserId String User ID
OppId String Opp Id

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062