Opportunity Recurring Revenue
The revenues that span over a period of time sourced from the same product on an opportunity.
QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/}RecurringRevenue
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 |
|
|
Contained by |
|
|
Contained by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
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. |
|
BUOrgId |
long |
The business unit identifier. |
|
Comments |
string |
The comments for the record. |
|
CommitFlag |
boolean |
The attribute that 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. |
|
ConversionRate |
decimal |
This rate is used for the conversion of 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. |
|
CustomerAccountId |
long |
The customer account identifier. |
|
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. |
|
ForecastOverrideCode |
string |
The forecast override code that takes values of always, never, or criteria. |
|
InventoryItemId |
long |
The product inventory item identifier. |
|
InventoryOrgId |
long |
The product inventory organization identifier. |
|
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 attribute for margin amount. |
|
NonRecurringRevenue |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Non-Recurring Revenue Amount (Net) |
|
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. |
|
OwnerResourceOrgId |
long |
The identifier for resource organization of the revenue owner. |
|
PrCmptPartyId |
long |
The primary competitor party identifier. |
|
PrimaryFlag |
boolean |
The attribute that indicates whether the revenue record is a summary revenue line. |
|
ProdGroupId |
long |
The product group identifier. |
|
Quantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity of the product. |
|
RecurEndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The recurrence end date. |
|
RecurFrequencyCode |
string |
The frequency for the recurrence. |
|
RecurNumberPeriods |
int |
The number of periods for creating the recurrence. |
|
RecurParentRevnId |
long |
The attribute that indicates the parent revenue identifier for 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. |
|
ResourcePartyId |
long |
The identifier for revenue owner, inherited from the parent record. |
|
RevnAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The attribute for revenue amount. |
|
RevnAmountCurcyCode |
string |
The currency that the amount on this revenue line is based on. |
|
RevnId |
long |
The attribute for revenue identifier.
|
|
RevnNumber |
string |
The editable revenue number, which is defaulted from REVN_ID. Must be unique and cannot be NULL. |
|
SalesAccountId |
long |
The identifier of the opportunity sales account. |
|
SalesCreditTypeCode |
string |
The quote or non-quota sales credit type. |
|
SplitParentRevnId |
long |
The attribute for split parent revenue identifier. |
|
SplitPercent |
decimal |
The attribute for split percent. |
|
SplitRevenue |
The revenue or nonrevenue credit amount allocated to the resource who has contributed to the selling effort for an opportunity revenue line. |
|
|
SplitTypeCode |
string |
The attribute for split type code. |
|
StatusCode |
string |
The pre-defined code used to indicate the status. |
|
StatusCodeSetId |
long |
The set identifier for the status of this revenue. |
|
TargetPartyId |
long |
The party identifier of the opportunity sales account. |
|
TypeCode |
string |
The attribute that indicates revenue type for this revenue. |
|
TypeCodeSetId |
long |
The set identifier for the revenue type of this opportunity. |
|
UOMCode |
string |
The attribute for unit of measure code for product. |
|
UnitPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The attribute for unit price of 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. |
|
WinProb |
decimal |
The win-probability percentage. |