Opportunity Split Revenue

The revenue or nonrevenue credit allocated to the resource who has contributed to the selling effort for an opportunity revenue line.

QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/revenues/revenueService/}SplitRevenue

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

Contained by

Opportunity

Contained by

Opportunity Recurring Revenue

Contained by

Opportunity Revenue

Handled by

Opportunity Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AssignmentType

string

Indicates how the territory was added to the revenue line; manually selected or automatically assigned.

BUOrgId

long

The identifier of the business unit.

CloseReasonCode

string

The win/loss reason the revenue line.

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.

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. Not currently used in Fusion.

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.

CreditRcptPartOrgPartyName

string

The name of the partner organization to which the credit recipient belongs.

CustomerAccountId

long

The identifier of the customer account.

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 line; defaulted from opportunity's close date.

EffectiveEndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date at the end of the date range within which the row is effective.

EffectiveStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date at the beginning of the date range within which the row is effective.

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 for the product. Not currently used in Fusion.

ForecastOverrideCode

string

Determines if the revenue line should always be forecasted, never be forecasted, or forecasted only when the forecast criteria is met.

InventoryItemId

long

The identifier of the product inventory.

InventoryOrgId

long

The identifier of the inventory organization.

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. Not currently used in Fusion.

Name

string

The name of the resource organization of the credit recipient.

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.

ObjectVersionNumber1

int

The attribute is used to implement optimistic 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 detect whether another session has updated the row since it was last queried.

OptyId

long

The unique identifier of the opportunity.

OwnerDealExpirationDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The deal expiration date of the credit recipient.

OwnerDealProtectedDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The deal protected date of the credit recipient.

OwnerLockAsgnFlag

boolean

Indicates if the credit recipients of the revenue line should be locked from re-assignment by the system.

OwnerOrgTreeCode

string

The resource organization tree code for the credit recipient.

OwnerOrgTreeStructCode

string

The resource organization tree structure code for the credit recipient.

OwnerResourceOrgId

long

The resource organization identifier of the credit recipient.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

PrCmptPartyId

long

Primary competitor identifier.

PrTerritoryUpdatedById

long

The user who last updated the forecast territory.

PrTerritoryUpdatedByPartyName

string

The name of the user who last updated the forecast territory.

PrTerritoryVersionId

long

The Forecast territory version identifier.

PrimaryFlag

boolean

Indicates whether the revenue record is a summary revenue line.

ProdGroupId

long

The identifier of the product group.

Quantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The product quantity.

RecurEndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

End date of the recurrence.

RecurFrequencyCode

string

The frequency for the recurrence.

RecurNumberPeriods

int

The number of periods for the recurrence.

RecurParentRevnId

long

Indicates the parent revenue identifier for the recurrence.

RecurQuantity

{http://xmlns.oracle.com/adf/svc/types/}MeasureType

The recurring quantity. This is the quantity for each recurrence.

RecurRevnAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The recurring revenue amount. This is the revenue amount for each recurrence.

RecurStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The start date of the recurrence.

RecurTypeCode

string

Indicates the type of revenue line, whether it is a parent recurring line, a child recurring line, or a non-recurring line.

ResourcePartyId

long

The resource identifier of the credit recipient.

RevnAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The revenue amount.

RevnAmountCurcyCode

string

The currency on which the revenue line is based.

RevnId

long

The unique identifier of the revenue.
  • Primary Key

RevnNumber

string

Unique number for the revenue line. Initially defaulted from the revenue identifier.

SalesAccountId

long

The identifier of the opportunity sales account.

SalesCreditTypeCode

string

Indicates the type of sales credit - revenue or nonrevenue.

SplitParentRevnId

long

The identifier of the customer account.

SplitPercent

decimal

The split percentage.

SplitTypeCode

string

The sales credit type of this credit split - Revenue or Nonrevenue.

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

Indicates the revenue type for this revenue line.

TypeCodeSetId

long

The Set identifier for the revenue type of this opportunity.

UOMCode

string

The unit of measure code for the product.

UnitPrice

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The unit price for the product.

UpsideAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The best case amount.

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 percent.