Sales Lead Products

The product associated with a sales lead.

QName: {http://xmlns.oracle.com/apps/marketing/leadMgmt/leads/leadService/}MklProdAssoc

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

Extended by

Sales Lead Products

Contained by

Sales Lead

Contained by

Service Lead Service Data Object

Handled by

Sales Lead Service Version 2

Handled by

Sales Lead Service Version 1

Attributes

The following table describes attributes in the service data object.

Name Type Description

Amount

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

The amount associated with the sales lead product.

AverageTimeToClose

decimal

Indicates average time to close for the sales lead product.

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.

Description

string

The free text description of the record.

EstimatedUnitPrice

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

The estimated unit price for the lead product.

InventoryItemId

long

The inventory item identifier associated with the lead product.

LastUpdateDate

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

The date when the record was last updated.

LastUpdatedBy

string

The user who last updated the record.

LeadId

long

The unique identifier of the sales lead for the sales lead product.

LeadProductId

long

The primary key that represents the identifier of the current lead product.
  • Primary Key

LeadProductNumber

string

This is a public surrogate key for the table and is defaulted with a unique number. It cannot be null.

LongDescription

string

The long description of the sales lead product.

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.

OrganizationId

long

The inventory organization identifier associated with the lead product.

PrimaryFlag

boolean

Indicates whether this product is a primary product for this lead.

ProductGroupDescription

string

The description of the product group.

ProductGroupId

long

The unique identifier of the product group.

ProductGroupName

string

The name of the product group if the record represents a product group.

ProductName

string

The name of product or product group. It is the same as the product name if the record represents a product. It is the same as the product group name if the record represents a product group.

ProductType

string

Indicates if the record represents a product or a product group.

Quantity

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

The product quantity identified for the product on the lead.

UOMCode

string

The unit of measure associated with the sales lead product line.