Deal Products

The product or product family associated with the deal registration that a customer is interested in.

QName: {http://xmlns.oracle.com/apps/marketing/dealMgmt/deals/dealService/}DealProduct

Logical Business Objects

  • CRM : Lead Management : Sales Lead

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

Deal Registration

Handled by

Deal Registration Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

Amount

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

The total amount.

ConvCurrencyCode

string

The conversion currency code.

ConvExchangeRate

decimal

The conversion exchange rate.

ConvRateType

string

The conversion rate type.

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.

CurrencyCode

string

The currency code. This attribute is used by CRM Extensibility framework.

DealId

long

The deal identifier to which the product row belongs to.

DealProdId

long

The deal product identifier. It is a primary key.
  • Primary Key

InvOrgId

long

The inventory organization identifier.

InventoryItemId

long

The inventory item identifier.

ItemDescription

string

The item description.

ItemName

string

The item name.

ItemNumber

string

Public Unique Identifier for Item in Deal Registration

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.

ProductGroupDescription

string

The product group description.

ProductGroupId

long

The product group identifier.

ProductGroupName

string

The product group name.

ProductGroupNumber

string

Public Unique Identifier for Product Group in Deal Registration

ProductType

string

The product type.

Quantity

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

The product quantity.

RegisteredPrice

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

The product registered price.

UOMCode

string

The product UOM Code.