Opportunity Revenue
The revenue line associated with the opportunity representing the projected revenue expected from selling a product.
QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/}Revenue
Logical Business Objects
-
CRM : Opportunity Management : Opportunity
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
| Relationship Type | Object or Service |
|---|---|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Contained by |
|
|
Contained by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
ActualCloseDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when the revenue line was closed. |
|
AdditionalAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
An additional currency enabled field on the revenue object to store any custom numeric value. |
|
AdditionalNumber |
decimal |
An additional numeric field on the revenue object to store any custom numeric value. |
|
AdditionalText1 |
string |
An additional text field on the revenue object to store any custom text. |
|
AdditionalText2 |
string |
An additional text field on the revenue object to store any custom text. |
|
AmountAggregatedForScheduleFlag |
boolean |
The aggregated amount based on the set schedule. |
|
AttachmentEntityName |
string |
The entity name used to retrieve attachment associated with the product. |
|
BUOrgId |
long |
The identifier of the business unit. |
|
ChildSplitRevenue |
Split revenues |
|
|
CloseReasonCode |
string |
The win/loss reason for this revenue item. |
|
CloseReasonCodeSetId |
long |
The set identifier for the Win/Loss reason of this revenue. |
|
Comments |
string |
The comments for the record. |
|
CommitFlag |
boolean |
Indicates if this revenue line should be used for forecasting. |
|
ConflictId |
long |
The attribute value is used to guarantee the uniqueness of the row when duplicates are created in different databases. |
|
ContractEndDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The end date of the contract for the quote |
|
ContractStartDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The start date of the contract for the quote |
|
ConversionRate |
decimal |
The rate used to convert the revenue amount to the opportunity summary currency, if the currency of the revenue line is different from that of the opportunity. This is the amount that one currency can be exchanged for, at a specific point of time. |
|
ConversionRateType |
string |
The currency conversion rate type that is used to derive the exchange rate for converting the user-entered currency to CRM Corporate currency. |
|
CostAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The cost amount. |
|
CreatedBy |
string |
The user who created the record. |
|
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was created. |
|
CreditRcptPartOrgPartyId |
long |
The identifier of the partner organization to which the credit recipient belongs. |
|
CrmConversionRate |
decimal |
This rate is used to convert the revenue amount to the CRM common currency for the Revenue Forecast Metrics, if the currency of the revenue line is different. This is the amount that one currency can be exchanged for, at a specific point of time. |
|
CrmConversionRateType |
string |
This rate type used to convert the revenue amount to the CRM common currency for Revenue Forecast Metrics, if the currency of the revenue line is different. It is usually spot, user-defined, or corporate. |
|
CrmCurcyCode |
string |
The CRM common currency code. |
|
CustomerAccountId |
long |
The identifier of the customer account. |
|
Description |
string |
The free text description of the record. |
|
Discount |
decimal |
The percentage of discount. |
|
DownsideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The worst case amount. |
|
EffectiveDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The estimated close date for this revenue; defaulted from opportunity's close date. |
|
ExpectAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The expected revenue amount. |
|
ExpectDlvryDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The expected delivery date. This column is used by Opportunity products only. |
|
ExternalAssetKey |
string |
The asset key from an external system. |
|
ExternalParentAssetKey |
string |
The root asset key of the parent from an external system. |
|
ExternalRootAssetKey |
string |
The root asset key obtained from an external system. |
|
ForecastOverrideCode |
string |
The code for Forecast Override. The values include, ALWAYS, NEVER, or CRITERIA. |
|
InventoryItemId |
long |
The identifier of the product inventory item. |
|
InventoryOrgId |
long |
The identifier of the inventory organization. |
|
ItemNumber |
string |
The item number of the product associated with the revenue. |
|
ItemNumberInternal |
string |
The item number of the product associated with the revenue. |
|
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated. |
|
LastUpdateLogin |
string |
The login of the user who last updated the record. |
|
LastUpdatedBy |
string |
The user who last updated the record. |
|
MarginAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The margin amount. |
|
MonthlyRecurringRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The monthly recurring revenue on the revenue line |
|
MonthlyUsageRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The monthly usage revenue on the revenue line |
|
Name |
string |
The name of the opportunity. |
|
Name1 |
string |
The name of the territory. |
|
NonRecurringRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Non-Recurring Revenue Amount (Net) |
|
NqSplitAllocTypeCode |
string |
The non-quota split allocation type code. Values supported are Adhoc amount or Proportional to Revenue. |
|
ObjectVersionNumber |
int |
The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row. |
|
OptyId |
long |
The unique identifier of the opportunity. |
|
OptyLeadId |
long |
The identifier of the lead associated with the opportunity. |
|
OptyNumber |
string |
The opportunity number. This is a public surrogate key. |
|
OrganizationId |
long |
The inventory organization identifier to which the product belongs. |
|
OwnerDealExpirationDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The owner deal expiration date. |
|
OwnerDealProtectedDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The owner deal protected date. |
|
OwnerLockAsgnFlag |
boolean |
Indicates whether the revenue owner assignment should be locked. |
|
OwnerOrgTreeCode |
string |
The owner organization tree code. |
|
OwnerOrgTreeStructCode |
string |
The owner organization tree structure code. |
|
OwnerResourceOrgId |
long |
The identifier for resource organization of the revenue owner. |
|
ParentRevnId |
long |
The identifier of the parent revenue line. It is used for Lineset functionality. |
|
PartEngagementTypeCd |
string |
The type of partner engagement. |
|
PartOrgPartyId |
long |
The identifier of the partner organization associated to the revenue. |
|
PartOrgPartyName |
string |
The name of the partner organization associated to the revenue. |
|
PartyName |
string |
The name of the party. |
|
PartyName1 |
string |
The name of the party. |
|
PartyName2 |
string |
The name of the party. |
|
PartyUniqueName1 |
string |
The unique name for the primary revenue competitor. |
|
PrCmptPartyId |
long |
Primary competitor party id. |
|
PrPartOrgPartyId |
long |
The Primary Revenue Partner Organization Party. |
|
PrTerritoryUpdatedById |
long |
The identifier of the user who last updated the forecast territory. |
|
PrTerritoryUpdatedByPartyName |
string |
The user who last updated the forecast territory. |
|
PrTerritoryVersionId |
long |
The primary territory for this revenue item. |
|
PriceTypeCode |
string |
The type of pricing associated with the revenue line |
|
PrimaryFlag |
boolean |
Indicates whether the revenue record is a summary revenue. |
|
ProdGroupId |
long |
The identifier of the product group. |
|
ProdGroupModelConfigAttributes |
string |
Model Configuration Attributes associated with the Product Group in Revenue Line. |
|
ProdGroupModelFamily |
string |
The model family associated with the product group. |
|
ProdGroupModelLine |
string |
The model line associated with the product group. |
|
ProdGroupModelName |
string |
Model Name associated with the Product Group in Revenue Line. |
|
ProdGroupName |
string |
The name of the product group associated with the revenue. |
|
ProdGroupQuotableFlag |
boolean |
Indicates if a product group is quotable. |
|
ProductConfigurableFlag |
boolean |
Indicates that a product allows configuration. |
|
ProductModelConfigAttributes |
string |
Model Configuration Attributes associated with the Product in Revenue Line. |
|
ProductModelFamily |
string |
The model family associated with the product. |
|
ProductModelLine |
string |
The model line associated with the product. |
|
ProductModelName |
string |
Model Name associated with the Product in Revenue Line. |
|
ProductType |
string |
The type of product on the revenue line (item or product group). |
|
Quantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The product quantity. |
|
RecurAdditionalAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The additional amount value for the recurrence. |
|
RecurAdditionalNumber |
decimal |
The additional number value for the recurrence. |
|
RecurDownsideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The downside amount for the recurrence. |
|
RecurEndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The recurrence end date. |
|
RecurExpectAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The expected revenue amount for the recurrence. |
|
RecurFrequencyCode |
string |
The frequency for the recurrence. |
|
RecurNumberPeriods |
int |
The number of periods for creating the recurrence. |
|
RecurParentRevnId |
long |
Indicates the parent revenue identifier for the recurrence. |
|
RecurPeriodOrEndDateCode |
string |
Indicates if a date is specified or a number of periods is specified to end the recurrence. |
|
RecurQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The recurrence quantity. |
|
RecurRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The recurring revenue amount on the revenue line |
|
RecurRevnAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The revenue amount for the recurrence. |
|
RecurStartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The recurrence start date. |
|
RecurTypeCode |
string |
The recurring type code. |
|
RecurUnitPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The unit price for the recurrence. |
|
RecurUpsideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The upside amount for the recurrence. |
|
RecurringRevenue |
The recurring revenue child occurrences. |
|
|
ResourcePartyId |
long |
The identifier for revenue owner. |
|
RevenueTerritory |
The territories assigned to the revenue. |
|
|
RevenueTypeCategory |
string |
The Revenue category type on the opportunity revenue line. |
|
RevnAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The revenue amount. |
|
RevnAmountCurcyCode |
string |
The currency on which the revenue line is based. |
|
RevnCategoryCode |
string |
Revenue category used in Revenue Line Set functionality. |
|
RevnCreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The functional creation date for the revenue item. |
|
RevnId |
long |
The revenue identifier.
|
|
RevnLineTypeCode |
string |
The type of revenue line like Opportunity Summary Revenue, Standard Revenue and so on. |
|
RevnNumber |
string |
User editable revenue number. Defaulted from REVN_ID. Needs to be unique, cannot be NULL. |
|
RevnSequenceNumber |
int |
The Revenue Sequence Number. |
|
SalesAccountId |
long |
The identifier of the opportunity sales account. |
|
SalesAccountUniqueName |
string |
The name of the sales account. |
|
SalesChannelCd |
string |
The sales channel code. |
|
SalesCreditTypeCode |
string |
Quota or Non-quota sales credit type. |
|
ScheduleAction |
string |
Transient attribute. Web services need to pass a value to indicate the action to be taken on Recurring Schedule - create, delete, extend, replace. |
|
ScheduleNonRecurringAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The nonrecurring amount based on the set schedule. |
|
ScheduleRecurringAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The recurring amount based on the set schedule. |
|
ScheduleUsageAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The usage amount based on the set schedule. |
|
SplitParentRevnId |
long |
The identifier of the split parent revenue. |
|
SplitPercent |
decimal |
The split percentage. |
|
SplitRevenue |
The split revenues. |
|
|
SplitRevenueNonQuota |
The non-revenue credits associated with the revenue record. |
|
|
SplitRevenueNonQuotaOtherSplits |
The non-revenue sales credits, excluding the record with the maximum percentage. |
|
|
SplitRevenueOtherSplits |
The revenue sales credits, excluding the record with the maximum percentage. |
|
|
SplitTypeCode |
string |
Indicates whether the split is revenue or non-revenue. |
|
StatusCode |
string |
The pre-defined code used to indicate the status. |
|
StatusCodeSetId |
long |
The set id for the status of this revenue. |
|
SubscriptionId |
long |
The unique identifier of the subscription. |
|
SubscriptionLineId |
long |
The unique identifier of the subscription line within a subscription. |
|
TargetPartyId |
long |
The Party identifier of the opportunity sales account. |
|
TypeCode |
string |
Indicates the revenue type for this revenue. |
|
TypeCodeSetId |
long |
The Set identifier for the revenue type of this opportunity. |
|
UOMCode |
string |
The unit of measure code for product. |
|
UnitPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The unit price for product. |
|
UpsideAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The best case amount. |
|
UsageRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The usage revenue amount on the revenue line |
|
UserLastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time when the row was last updated. |
|
ViewCriteriaIdentifier |
string |
Indicates when a View Criteria is seeded rather than a custom one. |
|
WinProb |
decimal |
The win probability percent. |