Referable Product

The product purchased by a reference customer where the customer agreed to endorse it as part of a reference program.

QName: {http://xmlns.oracle.com/apps/sales/baseSales/references/referenceService/}ReferableProduct

Logical Business Objects

  • CRM : Sales : Sales Reference Customer

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

Reference

Handled by

Sales Reference Customer

Attributes

The following table describes attributes in the service data object.

Name Type Description

Comments

string

The comments for the record.

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.

Description

string

The free text description of the record.

EndDate

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

Indicates the date till which the entity is active. This date is inclusive and the status of the entity is dependent on this.

InventoryItemId

long

The item identifier for the referenceable product.

InventoryOrgId

long

The item organization identifier for the referenceable product.

KeyContactId

long

The key contact party identifier.

KeyContactRelationId

long

The key contact relationship identifier.

LastOrderDate

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

Indicates the date when a customer most recently ordered the Referenceable Product.

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.

LevelCode

string

The information regarding the reference customer implementation level of the referenceable product (e.g. IMPLEMENTATION, IN_PRODUCTION, NO_LONGER_USING).

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.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

ProdGroupName

string

The product group name of the referenceable product.

ProductGroupId

long

The product group identifier for the referenceable product.

Quantity

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

The quantity of referenceable product purchased.

ReferableCode

string

The code that indicates if the reference will be a reference for this referable product.

ReferableProductName

string

The referable product or product group name.

ReferenceProductId

long

The referable product identifier.
  • Primary Key

Revenue

decimal

The revenue amount for the referenceable product purchase.

RevnCurrencyCode

string

The revenue amount currency code.

RowTypeCode

string

The code that indicates if the referenceable product is a product or product group.

StartDate

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

Indicates the date from which this entity is active. This date is inclusive and the status of an entity is dependent on this.

Status

string

The status of the record.

SubjectId

long

The key contact party identifier.

UOMCode

string

The unit of measure for the specified referenceable product quantity.

UserLastUpdateDate

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

The date and time when the row was last updated.