Opportunity Subscription

Opportunity Subscription aggregates all revenue subscriptions to opportunity level.

QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/opportunities/opportunityService/}OpportunitySubscription

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

Handled by

Opportunity Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

CorpCurrencyCode

string

Corporate currency code for extensibility.

CreatedBy

string

Who column: indicates the user who created the row.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Who column: indicates the date and time of the creation of the row.

CurcyConvRateType

string

Currency conversion rate type for extensibility.

Currency

string

The currency associated with the subscription.

CurrencyCode

string

Currency code for the extensibility.

DeleteFlag

boolean

This flag controls if the user has access to delete the record.

EndDate

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

The end date of the subscription.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

Who column: indicates the date and time of the last update of the row.

LastUpdateLogin

string

Who column: indicates the session login associated to the user who last updated the row.

LastUpdatedBy

string

Who column: indicates the user who last updated the row.

NetPrice

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

The total contract value of the subscription.

ObjectVersionNumber

int

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

OptyId

long

Parent Opportunity

OptySubscriptionId

long

Primary Key, the unique internal identifier of the row.
  • Primary Key

OptySubscriptionNumber

string

The unique number to associate a subscription with an opportunity.

PrimaryFlag

boolean

Indicates if a subscription is the Primary Subscription associated with the opportunity.

StartDate

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

The start date of the subscription.

Status

string

The current status of the subscription.

SubscriptionId

long

A subscription associated with opportunity.

SubscriptionId1

long

Displays the unique identifier of a subscription.

SubscriptionNumber

string

The number assigned to the line within a subscription by the system or the customer.

SubscriptionPeriod

string

The duration of the subscription.

UpdateFlag

boolean

This flag controls if the user has access to update the record.