Sales Status Category Mapping

The definition of the set of allowed revenue status categories for a given opportunity status category.

QName: {http://xmlns.oracle.com/apps/sales/baseSales/common/salesLookups/salesLookupService/}StatusCategoryMapping

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

Handled by

Sales Status Category Mapping

Attributes

The following table describes attributes in the service data object.

Name Type Description

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.

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.

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.

OpptyStatusCategory

string

The attribute for status category.

OpptyStatusCategoryOrderId

long

The status category mapping identifier.
  • Primary Key

RevnLost

string

The attribute that indicates whether the revenue line can be in the LOST status category when the opportunity uses this status category.

RevnNosale

string

The attribute that indicates whether the revenue line can be in the NO SALE status category when the opportunity uses this status category.

RevnOpen

string

The attribute that indicates whether the revenue line can be in the OPEN status category when the opportunity uses this status category.

RevnWon

string

The attribute that indicates whether the revenue line can be in the WON status category when the opportunity uses this status category.

UserLastUpdateDate

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

The date and time when the row was last updated.