Sales Stage

The sales stage for a given sales method describes the progress of an opportunity in the sales cycle.

QName: {http://xmlns.oracle.com/apps/sales/opptyMgmt/salesMethods/salesMethodService/}SalesStage

Logical Business Objects

  • CRM : Opportunity Management : Sales Method

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

Sales Stage Translation

Contains

Process Steps

Contains

Sales Stage Required Fields

Contains

Sales Stage Assessment Template

Contained by

Sales Method

Handled by

Sales Method

Attributes

The following table describes attributes in the service data object.

Name Type Description

AverageDaysAtStage

long

The average days at sales stage.

ConflictId

long

The attribute value is used to guarantee the uniqueness of the row when duplicates are created in different databases.

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.

DeletedFlag

boolean

The flag indicating whether the sales stage has been deleted.

DescriptionText

string

The description of sales stage.

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.

MaximumDaysInStage

long

The maximum days of sales stage.

Name

string

The name of sales stage.

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.

PhaseCd

string

The phase of sales stage.

QuotaFactor

decimal

The sales stage quota factor.

RcmndWinProb

decimal

The recommended win probability for sales stage.

SalesMethodId

long

The sales method identifier of the sales method to which the sales stage belongs.

SalesStageAssessmentTemplate1

Sales Stage Assessment Template

An object representing an assessment template tied to a sales stage of a particular sales method. A sales representative managing an opportunity in this particular stage is prompted to complete the assessment when he is about to move to the next stage in the lifecycle. sales stage assessment templates can be either mandatory or recommended.

SalesStageProcessSteps

Process Steps

A sequence of recommended steps tied to a particular sales stage which is used to guide the sales representative through the opportunity lifecycle.

SalesStageReqFields

Sales Stage Required Fields

A list of fields that are required to be entered for an opportunity prior to exiting the sales stage.

SalesStageTranslation

Sales Stage Translation

The attribute for list of translated sales stages.

SetId

string

The set identifier for sales stage. The value is retrieved from the sales method set identifier.

StageNumber

string

A GUID-based column that has been created to be a part of the Alternate Key for data migration.

StageStatusCd

string

The status of the sales stage.

StgId

long

The unique identifier for sales stage.
  • Primary Key

StgOrder

decimal

The order of the opportunity's sales stage within the sales method.

UserLastUpdateDate

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

The date and time when the row was last updated.