Get all unforecasted revenue items
get
/crmRestApi/resources/11.13.18.05/territoryForecasts/{ForecastParticipantId}/child/unforecastedPipeline
Request
Path Parameters
-
ForecastParticipantId(required): integer(int64)
The unique identifier of the participant associated with the territory forecast.
Query Parameters
-
dependency: string
This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2
Format: <attr1>=<val1>,<attr2>=<value2> -
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- PrimaryKey: Finds all the revenue items that are not included in the forecast associated with a territory.
Finder Variables:- RevnId; integer; The unique identifier of the revenue item.
- RevnNumberRowFinder: Finds a revenue line with the unique public identifier.
Finder Variables:- RevnNumber; string; The unique public identifier of a revenue line.
- PrimaryKey: Finds all the revenue items that are not included in the forecast associated with a territory.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- ActualCloseDate; string; The date when the revenue line was closed.
- AssetId; integer; Identifier of the asset of the opportunity.
- BUOrgId; integer; The unique identifier of the business unit that owns the opportunity.
- CalculatedLineRevnAmtInCorpCur; number; The opportunity revenue amount converted to the corporate currency.
- CloseReasonCode; string; The reason for winning or losing the revenue.
- CommitFlag; boolean; Indicates if the revenue line should be used for forecasting. If the value is True, then the revenue line should be used for forecasting. The default value is False.
- CompetitorPartyName; string; The name of the primary competitor. For the opportunity.
- ConflictId; integer; Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server).
- CurrStgId; integer; The unique identifier of the sales stage of the opportunity.
- CustomerRegistryId; string; The customer registry identifier of the sales account associated with the opportunity.
- Description; string; The user-provided description of the product associated with the revenue.
- DownsideAmount; number; The minimum amount of revenue for the opportunity.
- EffectiveDate; string; The date when the child revenue closes. The default value is the opportunity's close date.
- ForecastOverrideCode; string; The code that indicates if the revenue forecast should be overridden. The valid values are ALWAYS, NEVER, and CRITERIA.
- LastUpdateDate; string; The date when the record was last updated.
- Name1; string; The name of the territory.
- OpportunityCreationDate; string; The date and time when the underlying opportunity was created.
- OpportunityCurrencyCode; string; The currency on which the opportunity amount is based on.
- OpportunityOwnerPartyName; string; The name of the opportunity owner.
- OpportunityOwnerResourcePartyId; integer; The unique identifier of the opportunity owner.
- OptyEffectiveDate; string; The estimated close date for the opportunity.
- OptyId; integer; The unique identifier of the opportunity.
- OptyLastUpdateDate; string; The date when the underlying opportunity was last updated.
- OptyNumber; string; The alternate key identifier of the opportunity associated with the partner.
- OrganizationId; integer; The unique identifier of the organization to which the product belongs.
- OwnerPartyNumber; string; The alternate identifier of the opportunity owner.
- PartOrgPartyName; string; The name of the primary partner associated with the child revenue.
- PartyName2; string; Name of this party
- PrimaryCompetitorPartyNumber; string; Primary competitor party id.
- PrimaryContactPartyId; integer; The unique identifier of the primary contact.
- PrimaryContactPartyName; string; The name of the primary contact.
- PrimaryFlag; boolean; Indicates if the revenue is the primary revenue. If the value is True, then the revenue is the primary revenue among all the child revenues. The default value is False.
- PrimaryOrganizationName; string; The name of the business unit to which this opportunity belongs.
- PrimaryPartnerCompanyNumber; string; The alternate identifier of the primary partner.
- ProdGroupName; string; The name of the product group associated with the revenue.
- ProductGroupReferenceNumber; string; The product group identifier.
- ProductType; string; The type of product on the revenue line, such as item or product group.
- Quantity; number; The quantity of product for this opportunity.
- RecordSet; string; The revenue category used in Revenue Line Set functionality.
- RecurTypeCode; string; The code indicating if the line is a standard revenue line or recurring revenue line.
- ResourcePartyId; integer; The unique identifier of the revenue owner.
- RevnAmount; number; The amount of revenue that is earned from this opportunity.
- RevnAmountCurcyCode; string; The code indicating the currency used to calculate the revenue for this opportunity.
- RevnId; integer; The unique identifier of the revenue for the opportunity.
- RevnLastUpdateDate; string; The date and time when the revenue line was last updated.
- RevnNumber; string; The user-editable unique identifier for the child revenue. The default value is the revenue identifier.
- SalesChannelCd; string; The sales channel for the opportunity.
- SalesCreditTypeCode; string; The code indicating the type of the sales credit, such as quota or non-quota.
- SplitPercent; number; The percentage of split revenue.
- SplitTypeCode; string; The code that indicates if the split is revenue or non-revenue.
- StatusCd; string; The revenue status code.
- StatusCode; string; The unique code of the status for the child revenue.
- SumRevnDownsideAmt; number; The worst case amount.
- SumRevnUpsideAmt; number; The best case amount.
- SummaryRevnAmt; number; The revenue amount.
- SummaryRevnAmtInCorpCur; number; The revenue amount converted to corporate currency.
- TerrOwnerPartyName; string; The primary territory owner for this revenue item.
- TerrOwnerResourceId; integer; The primary territory owner identitier for this revenue item.
- TimeFilter; string; The time filter associated with the line.
- UnitPrice; number; The estimated unit price for the product.
- UpsideAmount; number; The maximum revenue amount for the opportunity.
- WinProb; integer; The estimated probability of winning the opportunity.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : territoryForecasts-unforecastedPipeline
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : territoryForecasts-unforecastedPipeline-item-response
Type:
Show Source
object-
ActualCloseDate: string
(date)
Title:
Actual Close DateThe date when the revenue line was closed. -
AmountAggregatedForScheduleFlag: boolean
Title:
Divide Amount by TransactionsMaximum Length:1The aggregated amount based on the set schedule. -
AssetId: integer
(int64)
Title:
AssetIdentifier of the asset of the opportunity. -
BUOrgId: integer
(int64)
Title:
Business UnitThe unique identifier of the business unit that owns the opportunity. -
CalculatedLineRevnAmtInCorpCur: number
Title:
Revenue in Corporate CurrencyRead Only:trueThe opportunity revenue amount converted to the corporate currency. -
CloseReasonCode: string
Title:
Win/Loss ReasonMaximum Length:30The reason for winning or losing the revenue. -
Comments: string
Title:
Line CommentsMaximum Length:250The user-provided comments for the revenue line. -
CommitFlag: boolean
Title:
ForecastMaximum Length:1Indicates if the revenue line should be used for forecasting. If the value is True, then the revenue line should be used for forecasting. The default value is False. -
CompetitorPartyName: string
Title:
Competitor Party NameRead Only:trueMaximum Length:360The name of the primary competitor. For the opportunity. -
ConflictId: integer
(int64)
Title:
Conflict IDDefault Value:0Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). -
ContractEndDate: string
(date-time)
Title:
Contract End DateThe end date of the contract for the quote -
ContractStartDate: string
(date-time)
Title:
Contract Start DateThe start date of the contract for the quote -
ConversionRate: number
Title:
Conversion RateThe currency conversion rate for converting the revenue amount to opportunity summary currency. The rate is used if the revenue line is different from that of the opportunity. -
ConversionRateType: string
Title:
Conversion Rate TypeMaximum Length:30The currency conversion rate type for converting the revenue amount to opportunity summary currency. The rate type is used if the revenue line is different from that of the opportunity. For example, the rate type can be spot, user-defined, or corporate. -
CostAmount: number
Title:
CostDefault Value:0The cost amount for the opportunity. -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64The user who created the child revenue record. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date when the record was created. -
CreditRcptPartOrgPartyId: integer
(int64)
Title:
Credit Recipient PartnerThe unique identifier of the credit recipient partner organization party. -
CrmConversionRate: number
Title:
CRM Conversion RateThe currency conversion rate for converting the revenue amount to CRM common currency for the Revenue Forecast Metrics. The rate is used if the revenue line is different from that of the opportunity. -
CrmConversionRateType: string
Title:
CRM Conversion Rate TypeMaximum Length:30The currency conversion rate type for converting the revenue amount to CRM common currency for Revenue Forecast Metrics. The rate type is used if the revenue line is different from that of the opportunity. For example, the rate type can be spot, user-defined, or corporate. -
CrmCurcyCode: string
Title:
CurrencyMaximum Length:15The common CRM currency code associated with the pipeline. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. -
CurrStgId: integer
(int64)
Title:
Sales StageRead Only:trueThe unique identifier of the sales stage of the opportunity. -
CustomerAccountId: integer
(int64)
Title:
Revenue Customer Account IDThe unique identifier of the customer account that owns the opportunity. -
CustomerRegistryId: string
Title:
Account Registry IDRead Only:trueMaximum Length:30The customer registry identifier of the sales account associated with the opportunity. -
DeleteFlag: boolean
Read Only:
trueIndicates whether the forecast item has been deleted from the forecast. -
Description: string
Title:
ProductMaximum Length:240The user-provided description of the product associated with the revenue. -
Discount: number
Title:
DiscountThe discount percent. -
DownsideAmount: number
Title:
Worst CaseDefault Value:0The minimum amount of revenue for the opportunity. -
EffectiveDate: string
(date)
Title:
Close DateThe date when the child revenue closes. The default value is the opportunity's close date. -
EffectiveEndDate: string
(date)
Read Only:
trueThe opportunity revenue line recurrence start date. -
EffectiveStartDate: string
(date)
Read Only:
trueThe opportunity revenue line recurrence end date. -
ExpectAmount: number
Title:
Expected RevenueDefault Value:0The expected amount of revenue for the opportunity. -
ExpectDlvryDate: string
(date)
Title:
Expected Delivery DateThe date when the product in the opportunity is expected to be delivered. This is used only for opportunities that include products. -
ExternalAssetKey: string
Title:
External Asset KeyMaximum Length:255The asset key from an external system. -
ExternalParentAssetKey: string
Title:
External Parent Asset KeyMaximum Length:255The root asset key of the parent from an external system. -
ExternalRootAssetKey: string
Title:
External Root Asset KeyMaximum Length:255The root asset key obtained from an external system. -
ForecastCategory: string
Title:
Forecast CategoryMaximum Length:30Specifies the categories used to represent the commitment level for sales forecasting such as pipeline, best case, most likely and so on. -
ForecastOverrideCode: string
Title:
Include in ForecastMaximum Length:30The code that indicates if the revenue forecast should be overridden. The valid values are ALWAYS, NEVER, and CRITERIA. -
InventoryItemId: integer
(int64)
Title:
ProductThe unique identifier of the product in the inventory. -
InventoryOrgId: integer
(int64)
Title:
ProductThe unique identifier of the organization in the inventory. -
ItemNumber: string
Title:
Item NumberRead Only:trueMaximum Length:300The alternate key identifier of the product that is associated with the revenue. -
ItemNumberInternal: string
Title:
Item Number InternalMaximum Length:300The unique internal number of the product that is associated with the revenue. -
LastUpdateDate: string
(date-time)
Title:
Update DateRead Only:trueThe date when the record was last updated. -
LastUpdatedBy: string
Title:
Updated ByRead Only:trueMaximum Length:64The user who last updated the record. -
LastUpdateLogin: string
Title:
Last Update LoginRead Only:trueMaximum Length:32The login of the user who last updated the record. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MarginAmount: number
Title:
MarginDefault Value:0The margin amount for the opportunity. -
MonthlyRecurringRevenue: number
Title:
Monthly Recurring RevenueThe monthly recurring revenue on the revenue line -
MonthlyUsageRevenue: number
Title:
Monthly Usage RevenueThe monthly usage revenue on the revenue line -
Name1: string
Title:
Forecast TerritoryRead Only:trueMaximum Length:60The name of the territory. -
NonRecurringRevenue: number
Title:
Nonrecurring RevenueNon-Recurring Revenue Amount (Net) -
NqSplitAllocTypeCode: string
Title:
Allocation StyleMaximum Length:30The code indicating the non-quota allocation split type. The valid values are Adhoc amount and Proportional to Revenue. -
OpportunityCreationDate: string
(date-time)
Title:
Opportunity Creation DateRead Only:trueThe date and time when the underlying opportunity was created. -
OpportunityCurrencyCode: string
Title:
Opportunity CurrencyRead Only:trueMaximum Length:15The currency on which the opportunity amount is based on. -
OpportunityOwnerPartyName: string
Title:
Opportunity OwnerRead Only:trueMaximum Length:360The name of the opportunity owner. -
OpportunityOwnerResourcePartyId: integer
(int64)
Title:
OwnerRead Only:trueThe unique identifier of the opportunity owner. -
OpportunityPrSrcNumber: string
Title:
Primary SourceRead Only:trueMaximum Length:100The primary marketing source or campaign that generated this opportunity. -
OptyEffectiveDate: string
(date)
Title:
Opportunity Close DateRead Only:trueThe estimated close date for the opportunity. -
OptyId: integer
(int64)
Title:
Revenue Opportunity IDThe unique identifier of the opportunity. -
OptyLastUpdateDate: string
(date-time)
Title:
Opportunity Last Update DateRead Only:trueThe date when the underlying opportunity was last updated. -
OptyLeadId: integer
(int64)
Title:
Opportunity LeadThe unique identifier of the lead associated with opportunity. -
OptyNumber: string
Title:
Opportunity NumberMaximum Length:30The alternate key identifier of the opportunity associated with the partner. -
OrganizationId: integer
(int64)
Title:
OrganizationThe unique identifier of the organization to which the product belongs. -
OwnerDealExpirationDate: string
(date)
Title:
Effective End DateThe date when the owner deal expires. -
OwnerDealProtectedDate: string
(date)
Title:
Effective Start DateThe date when the owner deal starts. -
OwnerLockAsgnFlag: boolean
Title:
Lock Credit OwnerMaximum Length:1Default Value:falseIndicates if the revenue owner assignment should be locked. If the value is Y, then the owner assignment for the child revenue should be locked. -
OwnerPartyNumber: string
Title:
Owner NumberRead Only:trueMaximum Length:30The alternate identifier of the opportunity owner. -
ParentRevnId: integer
(int64)
Title:
Parent Revenue IDThe unique identifier of the parent revenue line used for Lineset functionality. -
PartEngagementTypeCd: string
Title:
Lead Registration TypeMaximum Length:100The partner engagement type. -
PartOrgPartyId: integer
(int64)
Title:
Partner Organization Party IDRead Only:trueThe unique identifier of the primary revenue partner party. -
PartOrgPartyName: string
Title:
PartnerRead Only:trueMaximum Length:360The name of the primary partner associated with the child revenue. -
PartyName2: string
Title:
Sales Credit RecipientRead Only:trueMaximum Length:360Name of this party -
PrCmptPartyId: integer
(int64)
Title:
CompetitorThe unique identifier of the primary competitor of the child revenue. -
PriceTypeCode: string
Title:
Price TypeMaximum Length:30The type of pricing associated with the revenue line -
PrimaryCompetitorPartyNumber: string
Title:
Primary Competitor Party NumberRead Only:trueMaximum Length:30Primary competitor party id. -
PrimaryContactPartyId: integer
(int64)
Title:
Primary Contact Party IDRead Only:trueThe unique identifier of the primary contact. -
PrimaryContactPartyName: string
Title:
Primary ContactRead Only:trueMaximum Length:360The name of the primary contact. -
PrimaryFlag: boolean
Title:
PrimaryMaximum Length:1Indicates if the revenue is the primary revenue. If the value is True, then the revenue is the primary revenue among all the child revenues. The default value is False. -
PrimaryOrganizationName: string
Read Only:
trueThe name of the business unit to which this opportunity belongs. -
PrimaryPartnerCompanyNumber: string
Title:
Primary Partner NumberMaximum Length:30The alternate identifier of the primary partner. -
ProdGroupId: integer
(int64)
Title:
Product GroupThe unique identifier of the product group. -
ProdGroupModelConfigAttributes: string
Title:
Product Group Model AttributesRead Only:trueMaximum Length:4000Model Configuration Attributes associated with the Product Group in Revenue Line. -
ProdGroupModelFamily: string
Title:
Product Group Model FamilyRead Only:trueMaximum Length:1000The model family associated with the product group. -
ProdGroupModelLine: string
Title:
Product Group Model LineRead Only:trueMaximum Length:1000The model line associated with the product group. -
ProdGroupModelName: string
Title:
Product Group ModelRead Only:trueMaximum Length:1000Model Name associated with the Product Group in Revenue Line. -
ProdGroupName: string
Title:
Product GroupMaximum Length:250The name of the product group associated with the revenue. -
ProdGroupQuotableFlag: boolean
Title:
QuotableRead Only:trueMaximum Length:1Indicates if a product group is quotable. -
ProductConfigurableFlag: boolean
Title:
Configurable ProductRead Only:trueMaximum Length:1Indicates that a product allows configuration. -
ProductGroupReferenceNumber: string
Title:
Product Group Reference NumberMaximum Length:50The product group identifier. -
ProductModelConfigAttributes: string
Title:
Product Model AttributesRead Only:trueMaximum Length:4000Model Configuration Attributes associated with the Product in Revenue Line. -
ProductModelFamily: string
Title:
Product Model FamilyRead Only:trueMaximum Length:1000The model family associated with the product. -
ProductModelLine: string
Title:
Product Model LineRead Only:trueMaximum Length:1000The model line associated with the product. -
ProductModelName: string
Title:
Product ModelRead Only:trueMaximum Length:1000Model Name associated with the Product in Revenue Line. -
ProductType: string
Title:
Product TypeThe type of product on the revenue line, such as item or product group. -
PrPartOrgPartyId: integer
(int64)
Title:
PartnerThe unique identifier of the primary revenue partner organization party. -
PrTerritoryVersionId: integer
(int64)
Title:
Forecast TerritoryThe unique identifier of the primary territory for the revenue item. -
PrTerritoryVersionIdForManual: string
Title:
Manually Assigned Territory Version IDIndicates the version ID of a territory that is to be manually assigned to the revenue record. -
Quantity: number
Title:
QuantityThe quantity of product for this opportunity. -
RecordSet: string
Title:
Record SetRead Only:trueThe revenue category used in Revenue Line Set functionality. -
RecurDownsideAmount: number
Title:
Recurring Worst CaseThe minimum revenue amount from the recurrence. -
RecurEndDate: string
(date)
Title:
End ByThe date when the child revenue recurrence ends. -
RecurFrequencyCode: string
Title:
FrequencyMaximum Length:30The code that indicates the frequency of recurrence for the child revenue. -
RecurNumberPeriods: integer
(int64)
Title:
End AfterThe number of times the child revenue should recur. -
RecurParentRevnId: integer
(int64)
Title:
Recurring Revenue Parent IDThe unique identifier for the parent revenue of the recurring revenue lines. -
RecurPeriodOrEndDateCode: string
Title:
Recurrence Period or End Date CodeDefault Value:EndAfterThe code indicating if a date or the number of recurrences are specified to end the recurrences. -
RecurQuantity: number
Title:
Recurring QuantityThe quantity of the child revenue recurrence. -
RecurRevenue: number
Title:
Recurring RevenueThe recurring revenue amount on the revenue line -
RecurRevnAmount: number
Title:
Scheduled Revenue AmountThe amount of revenue from the child revenue recurrence. -
RecurStartDate: string
(date)
Title:
Start DateThe date when the recurrence starts. -
RecurTypeCode: string
Title:
Recurrence Type CodeMaximum Length:30The code indicating if the line is a standard revenue line or recurring revenue line. -
RecurUnitPrice: number
Title:
Recurring Estimated PriceThe price of each child revenue recurrence. -
RecurUpsideAmount: number
Title:
Recurring Best CaseThe maximum revenue amount from the recurrence. -
ResourcePartyId: integer
(int64)
Title:
OwnerThe unique identifier of the revenue owner. -
RevenueTypeCategory: string
Title:
Revenue Type CategoryMaximum Length:30The Revenue category type on the opportunity revenue line. -
RevnAmount: number
Title:
AmountDefault Value:0The amount of revenue that is earned from this opportunity. -
RevnAmountCurcyCode: string
Title:
Line CurrencyMaximum Length:15The code indicating the currency used to calculate the revenue for this opportunity. -
RevnCategoryCode: string
Title:
Revenue CategoryMaximum Length:30The revenue category used in Revenue Line Set functionality. -
RevnCreationDate: string
(date-time)
Title:
Creation Datefunctional creation date for the revenue item -
RevnId: integer
(int64)
Title:
Revenue IDThe unique identifier of the revenue for the opportunity. -
RevnLastUpdateDate: string
(date-time)
Title:
Update DateThe date and time when the revenue line was last updated. -
RevnLineTypeCode: string
Title:
Revenue Line Type CodeMaximum Length:30The code indicating the type of revenue line, such as Opportunity Summary Revenue or Standard Revenue. -
RevnNumber: string
Title:
Revenue NumberMaximum Length:30The user-editable unique identifier for the child revenue. The default value is the revenue identifier. -
RevnSequenceNumber: integer
(int32)
Title:
Line SetThe number indicating the sequence of the revenue in the pipeline. -
SalesAccountId: integer
(int64)
Title:
AccountThe unique identifier of the opportunity sales account. -
SalesChannelCd: string
Title:
Sales ChannelMaximum Length:50The sales channel for the opportunity. -
SalesCreditTypeCode: string
Title:
Sales Credit TypeMaximum Length:30Default Value:QUOTAThe code indicating the type of the sales credit, such as quota or non-quota. -
SalesMethodId: integer
(int64)
Title:
Sales MethodRead Only:trueThe unique identifier of the sales method. -
ScheduleAction: string
Title:
Schedule ActionTransient attribute. Web services need to pass a value to indicate the action to be taken on Recurring Schedule - create, delete, extend, replace. -
ScheduleNonRecurringAmount: number
Title:
Nonrecurring Amount for ScheduleThe nonrecurring amount based on the set schedule. -
ScheduleRecurringAmount: number
Title:
Recurring Amount for ScheduleThe recurring amount based on the set schedule. -
ScheduleUsageAmount: number
Title:
Usage Amount for ScheduleThe usage amount based on the set schedule. -
SplitParentRevnId: integer
(int64)
Title:
Split Parent Revenue IDThe unique identifier of the split parent revenue. -
SplitPercent: number
Title:
Sales CreditThe percentage of split revenue. -
SplitTypeCode: string
Title:
Split Type CodeMaximum Length:30The code that indicates if the split is revenue or non-revenue. -
StatusCd: string
Title:
Opportunity StatusRead Only:trueMaximum Length:30The revenue status code. -
StatusCode: string
Title:
StatusMaximum Length:30The unique code of the status for the child revenue. -
SubscriptionId: integer
(int64)
Title:
Subscription IdThe unique identifier of the subscription. -
SubscriptionLineId: integer
(int64)
Title:
Subscription Line IdThe unique identifier of the subscription line within a subscription. -
SummaryRevnAmt: number
Title:
Opportunity RevenueRead Only:trueDefault Value:0The revenue amount. -
SummaryRevnAmtInCorpCur: number
Title:
Opportunity Summary Revenue in Corporate CurrencyRead Only:trueThe revenue amount converted to corporate currency. -
SumRevnDownsideAmt: number
Title:
Opportunity Worst CaseRead Only:trueDefault Value:0The worst case amount. -
SumRevnUpsideAmt: number
Title:
Opportunity Best CaseRead Only:trueDefault Value:0The best case amount. -
TargetPartyId: integer
(int64)
Title:
Account Party IDThe unique identifier of the sales account that owns the opportunity. -
TerrOwnerOrganizationId: integer
Read Only:
trueThe primary territory orgnization for this revenue item. -
TerrOwnerPartyName: string
Title:
Forecast Territory OwnerRead Only:trueMaximum Length:360The primary territory owner for this revenue item. -
TerrOwnerResourceId: integer
(int64)
Title:
Resource IDRead Only:trueThe primary territory owner identitier for this revenue item. -
TimeFilter: string
Title:
Close PeriodRead Only:trueThe time filter associated with the line. -
TypeCode: string
Title:
Revenue TypeMaximum Length:30The revenue type for the revenue earned from the opportunity. -
UnitPrice: number
Title:
Estimated PriceThe estimated unit price for the product. -
UOMCode: string
Title:
UOMMaximum Length:3The unit of measure code for the product. -
UpdateFlag: boolean
Read Only:
trueIndicates whether the forecast item has been updated in the forecast. -
UpsideAmount: number
Title:
Best CaseDefault Value:0The maximum revenue amount for the opportunity. -
UsageRevenue: number
Title:
Usage RevenueThe usage revenue amount on the revenue line -
WinProb: integer
(int32)
Title:
Win ProbabilityThe estimated probability of winning the opportunity.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Examples
The following example shows how to get all unforecasted revenue items by submitting a get request on the REST resource using cURL.
cURL Command
curl -u <username:password> \ -X GET https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/territoryForecasts/1897628/child/unforecastedPipeline?onlyData=true
Example of Response Body
The following example shows the contents of the response body in JSON format.
{
"items" : [ {
"RevnId" : 300100090407978,
"TargetPartyId" : 999997550776400,
"CustomerAccountId" : null,
"BUOrgId" : 5186,
"Comments" : null,
"CommitFlag" : false,
"CostAmount" : 0,
"ResourcePartyId" : 300100027483620,
"DownsideAmount" : 0,
"ExpectAmount" : 12500,
"MarginAmount" : 0,
"OptyId" : 300100090387685,
"UnitPrice" : null,
"InventoryItemId" : null,
"InventoryOrgId" : null,
"Quantity" : 10,
"RevnAmount" : 125000,
"RevnAmountCurcyCode" : "USD",
"TypeCode" : null,
"UpsideAmount" : 125000,
"WinProb" : 10,
"UOMCode" : null,
"ExpectDlvryDate" : null,
"CreatedBy" : "ZSF_Sales_Rep3",
"CreationDate" : "2016-07-29T14:59:21-07:00",
"LastUpdatedBy" : "SALES_ADMIN",
"LastUpdateDate" : "2016-09-19T01:53:42-07:00",
"LastUpdateLogin" : "38CC162B2E17133AE05394D0F00AB723",
"Description" : null,
"OrganizationId" : null,
"PrimaryFlag" : false,
"RevnNumber" : "CDRM_99567",
"ProdGroupId" : 999997826070652,
"ProdGroupName" : "Agile Applications",
"RecurFrequencyCode" : "NONE",
"RecurEndDate" : null,
"RecurParentRevnId" : null,
"RecurNumberPeriods" : null,
"RecurQuantity" : null,
"RecurUnitPrice" : null,
"RecurRevnAmount" : null,
"RecurTypeCode" : "NONRECUR",
"RecurStartDate" : null,
"SalesCreditTypeCode" : "QUOTA",
"SplitParentRevnId" : 300100090387706,
"SplitPercent" : 100,
"SplitTypeCode" : "DETAILCHILDSPLIT",
"StatusCode" : "OPEN",
"EffectiveDate" : "2016-10-16",
"CloseReasonCode" : null,
"PrCmptPartyId" : null,
"RecurPeriodOrEndDateCode" : "EndAfter",
"ActualCloseDate" : null,
"PrTerritoryVersionId" : 300100026843435,
"ConversionRate" : 1,
"ConversionRateType" : "Corporate",
"OwnerDealExpirationDate" : null,
"OwnerDealProtectedDate" : null,
"OwnerLockAsgnFlag" : false,
"Name1" : "ZSF_Territory_USWest1",
"ForecastOverrideCode" : "CRITERIA",
"ItemNumber" : null,
"ItemNumberInternal" : null,
"ProductType" : "Group",
"NqSplitAllocTypeCode" : null,
"RecurDownsideAmount" : null,
"RecurUpsideAmount" : null,
"CrmCurcyCode" : "USD",
"CrmConversionRateType" : "Corporate",
"CrmConversionRate" : 1,
"RevnCategoryCode" : null,
"OptyLeadId" : null,
"SalesChannelCd" : "ZPM_DIRECT_CHANNEL_TYPES",
"PrPartOrgPartyId" : null,
"PartEngagementTypeCd" : null,
"CreditRcptPartOrgPartyId" : null,
"PartOrgPartyId" : null,
"PartOrgPartyName" : null,
"ParentRevnId" : null,
"RevnLineTypeCode" : "STANDARD_REVN",
"RevnSequenceNumber" : null,
"TerrOwnerOrganizationId" : 300100027657573,
"EffectiveStartDate" : "2013-08-23",
"EffectiveEndDate" : "4712-12-31",
"SalesAccountId" : 999997550776400,
"Discount" : null
}, {
"RevnId" : 300100090867466,
"TargetPartyId" : 999997550776400,
"CustomerAccountId" : null,
"BUOrgId" : 5186,
"Comments" : null,
"CommitFlag" : false,
"CostAmount" : 0,
"ResourcePartyId" : 300100027483620,
"DownsideAmount" : 0,
"ExpectAmount" : 12500,
"MarginAmount" : 0,
"OptyId" : 300100090867461,
"UnitPrice" : null,
"InventoryItemId" : null,
"InventoryOrgId" : null,
"Quantity" : 10,
"RevnAmount" : 125000,
"RevnAmountCurcyCode" : "USD",
"TypeCode" : null,
"UpsideAmount" : 125000,
"WinProb" : 10,
"UOMCode" : null,
"ExpectDlvryDate" : null,
"CreatedBy" : "ZSF_Sales_Rep3",
"CreationDate" : "2016-08-10T13:06:52-07:00",
"LastUpdatedBy" : "SALES_ADMIN",
"LastUpdateDate" : "2016-09-19T01:53:42-07:00",
"LastUpdateLogin" : "39BD982CDA200C65E05394D0F00A4A4A",
"Description" : null,
"OrganizationId" : null,
"PrimaryFlag" : false,
"RevnNumber" : "CDRM_152488",
"ProdGroupId" : 999997826070652,
"ProdGroupName" : "Agile Applications",
"RecurFrequencyCode" : "NONE",
"RecurEndDate" : null,
"RecurParentRevnId" : null,
"RecurNumberPeriods" : null,
"RecurQuantity" : null,
"RecurUnitPrice" : null,
"RecurRevnAmount" : null,
"RecurTypeCode" : null,
"RecurStartDate" : null,
"SalesCreditTypeCode" : "QUOTA",
"SplitParentRevnId" : null,
"SplitPercent" : 100,
"SplitTypeCode" : "NONE",
"StatusCode" : "OPEN",
"EffectiveDate" : "2016-10-16",
"CloseReasonCode" : null,
"PrCmptPartyId" : null,
"RecurPeriodOrEndDateCode" : "EndAfter",
"ActualCloseDate" : null,
"PrTerritoryVersionId" : 300100026843435,
"ConversionRate" : 1,
"ConversionRateType" : "Corporate",
"OwnerDealExpirationDate" : null,
"OwnerDealProtectedDate" : null,
"OwnerLockAsgnFlag" : false,
"Name1" : "ZSF_Territory_USWest1",
"ForecastOverrideCode" : "CRITERIA",
"ItemNumber" : null,
"ItemNumberInternal" : null,
"ProductType" : "Group",
"NqSplitAllocTypeCode" : "PROPORTIONAL",
"RecurDownsideAmount" : null,
"RecurUpsideAmount" : null,
"CrmCurcyCode" : "USD",
"CrmConversionRateType" : "Corporate",
"CrmConversionRate" : 1,
"RevnCategoryCode" : null,
"OptyLeadId" : null,
"SalesChannelCd" : "ZPM_DIRECT_CHANNEL_TYPES",
"PrPartOrgPartyId" : null,
"PartEngagementTypeCd" : null,
"CreditRcptPartOrgPartyId" : null,
"PartOrgPartyId" : null,
"PartOrgPartyName" : null,
"ParentRevnId" : null,
"RevnLineTypeCode" : "STANDARD_REVN",
"RevnSequenceNumber" : null,
"TerrOwnerOrganizationId" : 300100027657573,
"EffectiveStartDate" : "2013-08-23",
"EffectiveEndDate" : "4712-12-31",
"SalesAccountId" : 999997550776400,
"Discount" : null
}