RevenueCost
Generates opportunity periodic revenue versus cost data for given products.
Table Specific Information
Select
- ProductId supports the '=' operator.
- Interval supports the '=' operator.
- Start supports the '=' operator.
- End supports the '=' operator.
- FiscalYearStart supports the '=' operator.
SELECT * FROM RevenueCost where ProductId = 'b7c23fa5-6cd3-4bcd-a036-f8bbb85ba760' Select * FROM RevenueCost
Columns
Name | Type | Description |
AlternateText | String | Alternate Text |
Cost | Integer | Cost |
OppCount | Integer | Opp Count |
Revenue | Integer | Revenue |
TimePeriod | String | Time Period |
ProductId | String | Product Id |
Interval | String | Interval
使用できる値は次のとおりです。daily, weekly, monthly, quarterly, yearly |
FiscalYearStart | Integer | Fiscal Year Start |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Date | Datetime | Date Range of Activities By User |