Service Lead Service Data Object

The transaction record created when a party has expressed an interest in a product or service. It represents a selling opportunity.

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

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

Sales Lead Resources

Contains

Sales Lead Product

Contains

Sales Lead Contact

Handled by

Sales Lead Service Version 1

Attributes

The following table describes attributes in the service data object.

Name Type Description

AcceptedDate

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

The date when the lead was accepted.

Address1

string

The first line of the address.

Address2

string

The second line of the address.

ApprovalDate

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

The date when the lead was approved. This is applicable to deals only.

ApprovalTaskId

string

The unique identifier of the approval task associated with the approval process for the lead. This is applicable to deals only.

ApproverId

long

The party identifier associated with the approver of the lead registration record.

AssignmentStatusCode

string

Includes the current assignment related status for the lead. For example, whether the lead is assigned or unassigned.

BudgetAmount

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

The budget amount associated with the sales lead.

BudgetStatus

string

The budget status associated with the budget amount associated with the sales lead.

CampaignContactId

long

The campaign contact identifier associated with the sales lead.

ChannelType

string

Indicates the channel through which the lead contacted the company.

City

string

The name of the city.

ConvertedTimestamp

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

Indicates when the lead was converted to an opportunity.

Country

string

The name of the country.

County

string

The name of the county.

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.

CustomerId

long

The party identifier associated with the customer who is associated with the sales lead.

CustomerNeed

string

Indicates which needs the lead product serves for the lead customer.

DealAmount

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

The deal size associated with the sales lead.

DecisionMakerIdentifiedFlag

boolean

Indicates whether a decision maker is identified for the sales lead.

Description

string

The free text description of the record.

EmailAddress

string

The email address associated with the record.

EstimatedCloseDate

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

The estimated close date of the deal. This is a deal specific attribute.

ExpirationDate

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

The expiration date associated with the sales lead.

FollowupTimestamp

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

Indicates when the sales lead must be followed up.

ImportTaskId

long

The unique identifier of the import task associated with the lead. This is applicable to imported leads only.

LastAssignmentDate

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

The date when the lead was last run through automated batch lead assignment process.

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.

LeadAcceptedFlag

boolean

Indicates if the lead is accepted.

LeadId

long

The primary identifier of the sales lead.
  • Primary Key

LeadNumber

string

The unique identifier of the sales lead. It also acts as a public surrogate key.

MklLeadResources

Sales Lead Resources

Indicates the reference to lead resources (child).

MklLeadTcMembers

Sales Lead Contacts

Indicates the reference to lead contacts (child).

MklProdAssoc

Sales Lead Products

Indicates the reference to lead products (child).

Name

string

The name of the sales lead.

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.

OwnerId

long

The resource identifier for the lead owner resource.

OwnerPartyName

string

The name associated with the owner of the sales lead.

PartnerId

long

The unique identifier of the partner.

PartnerPartyName

string

The name associated with the primary partner of the sales lead. This is a deal specific attribute.

PartnerProgramId

long

A reference to the partner program in which the primary partner associated with the sales lead is enrolled. This is a deal specific attribute.

PartnerType

string

Indicates the type of the primary partner associated with the sales lead. This is a deal specific attribute.

PartnerTypeMeaning

string

The meaning of the type of primary partner associated with the sales lead. This is a deal specific attribute.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

PostalCode

string

The postal code element of the address.

PrimaryContactId

long

The unique identifier of the sales lead contact marked as a primary lead contact.

PrimaryContactPartyName

string

The name associated with the primary lead contact.

PrimaryInventoryItemDescription

string

The description associated with the sales lead.

PrimaryInventoryItemId

long

The inventory item identifier associated with the primary lead product.

PrimaryInventoryOrgId

long

The inventory item organization identifier associated with primary lead product.

PrimaryProductDescription

string

The description of the primary lead product.

PrimaryProductGroupId

long

The unique identifier of the primary product group associated with the lead.

ProductGroupName

string

The name associated with the primary lead product Group.

ProgramName

string

The name of the partner program in which the primary partner associated with the sales lead is enrolled. This is a deal specific attribute.

Project

string

The customer project identified for the sales lead.

QualificationScore

long

The qualification score associated with the lead. This score is computed by the assignment manager.

QualifiedDate

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

Indicates the date when the sales lead was qualified.

Rank

string

The rank associated with the sales lead.

ReassignCommentText

string

Comments added to the lead during reassign operation.

ReassignReasonCode

string

The reason code specified by the user when the lead was reassigned.

RegistrationNumber

string

The registration number of the sales lead. This unique identifier is generated when the sales lead is approved. This is a deal specific attribute.

RegistrationStatus

string

The approval Status of the sales lead. This is a deal specific attribute.

RegistrationType

string

Indicates the registration type of the sales lead. This is a deal specific attribute.

RegistrationTypeMeaning

string

Indicates the meaning of the registration type of the sales lead. This is a deal specific attribute.

RejectByTerritoryId

long

The territory identifier associated with the territory to which the resources who rejected the lead belonged at the time of rejection.

RejectByTerritoryVersionId

long

The territory version identifier associated with the territory to which the resources who rejected the lead belonged at the time of rejection.

RejectByUserId

long

The unique identifier of the sales representative who rejected the sales lead.

RejectComment

string

The comments provided by the sales representative who rejected the sales lead.

RejectReasonCode

string

Indicates the rejection reason code provided by the sales representative who rejected the sales lead.

RejectedCount

long

Indicates the number of times the sales lead was rejected by sales representatives.

RejectedTimestamp

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

Indicates the date and time when the sales lead was rejected by a sales representative.

RelationshipId

long

The relationship identifier for the record.

RetireComment

string

The comments recorded when the sales lead is moved to retired status.

RetireReasonCode

string

The reason code recorded when the sales lead is moved to retired status.

RetiredTimestamp

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

The date and time recorded when the sales lead is moved to retired status.

SalesChannel

string

Indicates the sales channel responsible for following up on the sales lead.

SalesChannelMeaning

string

The meaning of the sales channel associated with the sales lead.

Score

long

The score associated with the sales lead. The score is computed based on the scoring rules.

SourceCode

string

The marketing source code associated with the sales lead.

State

string

The name of the state.

StatusCode

string

The pre-defined code used to indicate the status.

Timeframe

string

The time frame associated with the sales lead.

ToReassignFlag

boolean

Indicates whether the sales lead must be reassigned during the next batch assignment run.

ToRescoreFlag

boolean

Indicates whether the sales lead must be rescored during the next batch assignment run.

UniqueName

string

The unique name of the customer associated with the sales lead.