Revenue Line Set

The collection of revenue lines representing a product offering on an opportunity.

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

Logical Business Objects

  • CRM : Opportunity Management : Sales Revenue

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

Opportunity Revenue

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.

CustomerAccountId

long

The customer's billing account identifier.

CustomerPartyId

long

The party identifier of the sales account.

EffectiveDate

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

The estimated close date for the revenue line set.

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.

OwnerOrgTreeCode

string

The resource organization tree code for the revenue line set owner.

OwnerOrgTreeStructCode

string

The resource organization tree structure code for the revenue line set owner.

OwnerResourceId

long

The resource party identifier of the revenue line set owner.

OwnerResourceOrgId

long

The resource organization identifier of the revenue line set owner.

ProdGroupId

long

The product group identifier.

ProdGroupName

string

The name of the product group associated with the revenue.

Revenue

Opportunity Revenue

The revenue line set members associated with the revenue line set.

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.

RevnId

long

The revenue line set identifier.
  • Primary Key

RevnLineTypeCode

string

This denotes the type of revenue line such as Summary Revenue or Standard Revenue.

RevnSequenceNumber

int

The attribute for revenue sequence number.

SalesAccountId

long

The identifier of the opportunity sales account.

StatusCode

string

The pre-defined code used to indicate the status.

UserLastUpdateDate

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

The date and time when the row was last updated.