OpportunityRevenueItems
The revenue items resource is used to view, create, and update revenue items of an opportunity. The revenue items associated with opportunities are products, services, or other items a customer might be interested in purchasing. You add revenue items by selecting a product group or product to associate with an opportunity.
Columns
| Name | Type | ReadOnly | References | Description |
| RevnId [KEY] | Long | False |
This is the primary key of the revenue items table. | |
| OptyNumber [KEY] | String | False |
Opportunities.OptyNumber | |
| ActualCloseDate | Date | False |
The date when the revenue line was closed. | |
| BUOrgId | Long | False |
The unique identifier of the Business Unit that owns the opportunity. | |
| CloseReasonCode | String | False |
The reason for winning or losing the revenue. | |
| Comments | String | False |
The user-provided comments for the revenue line. | |
| CommitFlag | Boolean | False |
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. | |
| ConversionRate | Double | False |
The 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 | False |
The 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 | Decimal | False |
The cost amount for the opportunity. | |
| CreatedBy | String | False |
The user who created the child revenue record. | |
| CreationDate | Datetime | False |
The date when the record was created. | |
| CreditRcptPartOrgPartyId | Long | False |
Credit Recipient Partner Organization Party. | |
| CrmConversionRate | Double | False |
The 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 | False |
The 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 | False |
The common CRM currency code. | |
| CustomerAccountId | Long | False |
The unique identifier of the customer account that owns the opportunity. | |
| Description | String | False |
The user-provided description of the product associated with the revenue. | |
| Discount | Decimal | False |
The discount percent. | |
| DownsideAmount | Decimal | False |
The minimum amount of revenue for the opportunity. | |
| EffectiveDate | Date | False |
The date when the child revenue closes. The default value is the opportunity's close date. | |
| ExpectAmount | Decimal | False |
The maximum amount of revenue for the opportunity. | |
| ExpectDlvryDate | Date | False |
The expected delivery date for the product in the opportunity. This used only for opportunities that include products. | |
| ForecastOverrideCode | String | False |
The code that indicates if the revenue forecast should be overridden. The valid values are ALWAYS, NEVER, and CRITERIA. | |
| InventoryItemId | Long | False |
The unique identifier of the product in the inventory. | |
| InventoryOrgId | Long | False |
The unique identifier of the organization in the inventory. | |
| ItemNumber | String | False |
The unique number of the product that is associated with the revenue. | |
| ItemNumberInternal | String | False |
The unique internal number of the product that is associated with the revenue. | |
| LastUpdateDate | Datetime | False |
The date when the record was last updated. | |
| LastUpdatedBy | String | False |
The user who last updated the record. | |
| LastUpdateLogin | String | False |
The login of the user who last updated the record. | |
| MarginAmount | Decimal | False |
The margin amount for the opportunity. | |
| Name1 | String | False |
The name of the territory. | |
| NqSplitAllocTypeCode | String | False |
The code indicating the non-quota allocation split type. The valid values are Adhoc amount and Proportional to Revenue. | |
| OptyId | Long | False |
The unique identified of the opportunity. | |
| OptyLeadId | Long | False |
Identifier for lead associated with opportunity. | |
| OrganizationId | Long | False |
The unique identifier of the organization to which the product belongs. | |
| OwnerDealExpirationDate | Date | False |
The date when the owner deal expires. | |
| OwnerDealProtectedDate | Date | False |
The date when the owner deal starts. | |
| OwnerLockAsgnFlag | Boolean | False |
Indicates if the revenue owner assignment should be locked. If the value is Y, then the owner assignment for the child revenue should be locked. | |
| ParentRevnId | Long | False |
The Parent revenue line id. Used for Lineset functionality. | |
| PartEngagementTypeCd | String | False |
Partner Engagement Type. | |
| PartOrgPartyId | Long | False |
The unique identifier of the primary revenue partner party. | |
| PartOrgPartyName | String | False |
The name of the primary partner associated with the child revenue. | |
| PrCmptPartyId | Long | False |
The unique identifier of the primary competitor of this child revenue. | |
| PrimaryFlag | Boolean | False |
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. | |
| ProdGroupId | Long | False |
The unique identifier of the product group. | |
| ProdGroupName | String | False |
The name of the product group associated with the revenue. | |
| ProductType | String | False |
The type of product on the revenue line, such as item or product group. | |
| PrPartOrgPartyId | Long | False |
Primary Revenue Partner Organization Party. | |
| PrTerritoryVersionId | Long | False |
The unique identifier of the primary territory for this revenue item. | |
| Quantity | Double | False |
The quantity of product for this opportunity. | |
| RecurDownsideAmount | Decimal | False |
The minimum revenue amount from the recurrence. | |
| RecurEndDate | Date | False |
The date when the child revenue recurrence ends. | |
| RecurFrequencyCode | String | False |
The code that indicates the frequency of recurrence for the child revenue. | |
| RecurNumberPeriods | Long | False |
The number of time the child revenue should recur. | |
| RecurParentRevnId | Long | False |
The unique identifier for the parent revenue of the recurring revenue lines. | |
| RecurPeriodOrEndDateCode | String | False |
Indicates if a date or the number of recurrences are specified to end the recurrences. | |
| RecurQuantity | Double | False |
The quantity of the child revenue recurrence. | |
| RecurRevnAmount | Decimal | False |
The amount of revenue from the child revenue recurrence. | |
| RecurStartDate | Date | False |
The date when the recurrence starts. | |
| RecurTypeCode | String | False |
Indicates if the line is a standard revenue line or recurring revenue line. | |
| RecurUnitPrice | Decimal | False |
The price of each child revenue recurrence. | |
| RecurUpsideAmount | Decimal | False |
The maximum revenue amount from the recurrence. | |
| ResourcePartyId | Long | False |
The unique identifier of the revenue owner. | |
| RevnAmount | Decimal | False |
The amount of revenue that is earned from this opportunity. | |
| RevnAmountCurcyCode | String | False |
The currency code used to calculate the revenue for this opportunity. | |
| RevnCategoryCode | String | False |
The revenue category used in Revenue Line Set functionality. | |
| RevnLineTypeCode | String | False |
This denotes the type of revenue line like Opportunity Summary Revenue, Standard Revenue and so on. | |
| RevnNumber | String | False |
The user-editable unique identifier for the child revenue. The default value is the revenue identifier. | |
| RevnSequenceNumber | Long | False |
The Revenue Sequence Number | |
| SalesAccountId | Long | False |
Identifier of the opportunity sales account. | |
| SalesChannelCd | String | False |
Sales Channel Code. | |
| SalesCreditTypeCode | String | False |
The type of the sales credit, such as quota or non-quota. | |
| SplitParentRevnId | Long | False |
The unique identifier of the split parent revenue. | |
| SplitPercent | Double | False |
The percentage of split revenue. | |
| SplitTypeCode | String | False |
The code that indicates if the split is revenue or non-revenue. | |
| StatusCode | String | False |
The unique code of the status for the child revenue. | |
| TargetPartyId | Long | False |
The unique identifier of the sales account that owns the opportunity. | |
| TypeCode | String | False |
The revenue type for the revenue earned from this opportunity. | |
| UnitPrice | Decimal | False |
The estimated unit price for the product. | |
| UOMCode | String | False |
The unit of measure code for the product. | |
| UpsideAmount | Decimal | False |
The maximum amount of revenue for the opportunity. | |
| WinProb | Long | False |
The estimated probability of winning the opportunity. | |
| OpportunityLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. | |
| EffectiveEndDate | Datetime | False |
The end date for the territory owner. | |
| ResourcePartyId | String | False |
The unique identifier of the revenue owner. |
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 |
| RecordSet | String |
Input specifying the resource type. |
| Finder | String |
Input specifying the Finder type. |
| PartyId | String |
Input specifying the Party Id. |
| PartyIdAttribute | String |
Input specifying the Party Id Attribute. |
| AttributeName | String |
Input specifying the Attribute Name. |
| RollUpId | String |
Input specifying the RollUp Id. |
| SourceObject | String |
Input specifying the Source Object. |
| SourceObjectId | String |
Input specifying the Source Object Id. |
| ClosePeriod | String |
Input specifying the Close Period. |
| ContactPartyId | String |
Input specifying the Contact Party Id. |
| EffectiveBeginDate | String |
Input specifying the Effective BeginDate. |
| LeadNumber | String |
Input specifying the Lead Number. |
| LookupCategory | String |
Input specifying the Lookup Category. |
| OpportunityContactName | String |
Input specifying the Opportunity Contact Name. |
| OptyStatusCode | String |
Input specifying the Opty StatusCode. |
| Partner | String |
Input specifying the Partner. |
| PartnerPartyId | String |
Input specifying the Partner Party Id. |
| Product | String |
Input specifying the Product. |
| ProductGroup | String |
Input specifying the Product Group. |
| ReferenceName | String |
Input specifying the Reference Name. |
| TeamMember | String |
Input specifying the Team Member. |
| Name | String |
Input specifying the Name. |