Category Summary Revenue

The summarized revenue amount for a given revenue category within an opportunity revenue line set.

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

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

BUOrgId

long

The business unit identifier.

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.

CrmCategorySummaryRevenue

decimal

The category summary revenue in corporate currency.

CrmConversionRate

decimal

The rate is used for the conversion of the revenue amount to the CRM common currency to facilitate the computation of the revenue forecast metrics. This is the amount that one currency can be exchanged for, at a specific point of time.

CrmConversionRateType

string

The rate type is used for the conversion of the revenue amount to the crm common currency for Revenue Forecast Metrics, if the currency of the revenue line is different. This is usually spot, user defined or corporate.

CrmCurcyCode

string

The CRM common currency code.

EffectiveDate

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

The estimated close date for the category summary revenue line.

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.

OptyId

long

The unique identifier of the opportunity.

PrimaryFlag

boolean

The attribute that indicates whether the revenue record is a summary revenue line.

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.

RevnCategoryCode

string

The revenue category used in Revenue Line Set functionality.

RevnId

long

The attribute for revenue identifier.
  • Primary Key

RevnLineTypeCode

string

This denotes the type of revenue line like opportunity Summary Revenue, Standard Revenue and so on.

RevnNumber

string

The attribute for revenue number.

UserLastUpdateDate

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

The date and time when the row was last updated.