Sales Lead
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/oracle/apps/marketing/leadMgmt/leads/leadService/}MklLead
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 |
|
|
Contains |
|
|
Contains |
|
|
Contains |
|
|
Extended by |
|
|
Handled by |
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 by a resource assigned to it. |
|
AcceptedDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date and time when the sales lead is accepted by a resource assigned to it. |
|
AddrElementAttribute1 |
string |
Additional address element to support flexible address format. |
|
AddrElementAttribute2 |
string |
Additional address element to support flexible address format. |
|
AddrElementAttribute3 |
string |
Additional address element to support flexible address format. |
|
AddrElementAttribute4 |
string |
Additional address element to support flexible address format. |
|
AddrElementAttribute5 |
string |
Additional address element to support flexible address format. |
|
AddressLinesPhonetic |
string |
Phonetic or Kana representation of the Kanji address lines (used in Japan). |
|
ApprovalDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when a partner registered lead is approved by internal channel manager. |
|
ApprovalDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time when the sales lead was approved. This is applicable to deal registrations only. |
|
ApprovalTaskId |
string |
The unique identifier of the approval task pertaining to a partner registered lead. |
|
ApproverId |
long |
The party identifier associated with the approver of the lead registration record. |
|
AssetId |
long |
Unique identifier for the Asset associated with the Sales Lead. |
|
AssetNumber |
string |
Unique Number for the Asset associated with the Sales Lead. |
|
AssetSerialNumber |
string |
Serial Number for the Asset associated with the Sales Lead. |
|
AssignmentStatusCdMeaning |
string |
Defines the current assignment related status for the lead that is, whether the lead is assigned or unassigned and so on. |
|
AssignmentStatusCode |
string |
Includes the current assignment related status for the lead. For example, whether the lead is assigned or unassigned. |
|
BranchCode |
string |
The branch code pertaining to an organization. |
|
BudgetAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The budget amount associated with the sales lead. |
|
BudgetCurrencyCode |
string |
The currency code associated with the budget amount associated with the sales lead. |
|
BudgetStatus |
string |
The budget status associated with the budget amount associated with the sales lead. |
|
BudgetStatusSetId |
long |
The identifier of the budget status list set. |
|
Building |
string |
Specific building name or number at a given address. |
|
BusinessUnitId |
long |
The business unit identifier associated with the business unit of the sales lead creator. |
|
BusinessUnitName |
string |
The name of the business unit associated with the sales lead. |
|
CampaignId |
long |
The unique identifier for the campaign. |
|
CampaignName |
string |
The name of the campaign associated with the sales lead. |
|
ChannelType |
string |
Indicates the channel through which the lead contacted the company. |
|
ChannelTypeMeaning |
string |
Indicates the channel through which this lead contacted the company. |
|
ChannelTypeSetId |
long |
The identifier of the channel type list set. |
|
ClassCode1 |
string |
The auxiliary dimension for the Account. |
|
ClassCode2 |
string |
The auxiliary dimension for the Account. |
|
ClassCode3 |
string |
The auxiliary dimension for the Account. |
|
ClassCode4 |
string |
The auxiliary dimension for the Account. |
|
ContactTimezoneCd |
string |
Preferred time zone of the contact pursued on the lead. |
|
ConvCurrencyCode |
string |
The currency code used to convert the lead currency. This is typically the corporate currency. |
|
ConvExchangeRate |
decimal |
The exchange rate used to convert the lead currency to the corporate currency. |
|
ConvRateType |
string |
The rate type used to convert the lead currency to the corporate currency. |
|
ConvertedDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time when the sales lead was converted to an opportunity. |
|
ConvertedTimestamp |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Indicates when the lead was converted to an opportunity. |
|
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. |
|
CreationDateFormatted |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Indicates the date and time when the record is created. |
|
CurrencyCode |
string |
The currency code. This attribute is used by CRM Extensibility framework. |
|
CurrencyConversionDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The currency conversion date. |
|
CurrencyMeaning |
string |
The currency code for the lead. |
|
CustomerAddress1 |
string |
The first line of the identifying address. |
|
CustomerAddress2 |
string |
The second line of the identifying address. |
|
CustomerAddress3 |
string |
The third line of the identifying address. |
|
CustomerAddress4 |
string |
The fourth line of the identifying address. |
|
CustomerCategoryCode |
string |
The category code for a customer. |
|
CustomerCity |
string |
The city associated with the sale that is associated with the lead customer. |
|
CustomerCountry |
string |
The country in which customer is located. |
|
CustomerCurrencyFyPotentialRevenue |
decimal |
The potential annual revenues for a customer. |
|
CustomerDoNotCallFlag |
boolean |
Indicates the Do not call flag set for sales lead customer (person). |
|
CustomerDoNotContactFlag |
boolean |
Indicates the Do not contact flag set for sales lead customer (person). |
|
CustomerDoNotEmailFlag |
boolean |
Indicates the do not email flag set for sales lead customer (person). |
|
CustomerDoNotMailFlag |
boolean |
Indicates the do not mail flag set for sales lead customer (person). |
|
CustomerEmployeesTotal |
decimal |
The total number of employees at a customer site. |
|
CustomerId |
long |
The customer identifier. It is a reference to the customer record in the TCA schema. |
|
CustomerIdenAddrLocationId |
long |
The address location identifier pertaining to a customer. |
|
CustomerNeed |
string |
Indicates needs that the lead product serves for the lead customer. |
|
CustomerPartyName |
string |
The name of the customer. |
|
CustomerPartyType |
string |
The type of customer. |
|
CustomerPartyUniqueName |
string |
The concatenation of customer name with postal code to make it unique. |
|
CustomerPersonProfileId |
long |
The unique identifier of the sales lead customer (person) to get the dnc flags. |
|
CustomerPostalCode |
string |
The code in which customer is located. |
|
CustomerPrimaryAddress |
string |
The primary address of the customer associated with the sales lead. |
|
CustomerPrimaryEmailAddress |
string |
The primary email address of the customer associated with the sales lead. |
|
CustomerPrimaryPhoneNumber |
string |
The primary formatted phone number of the customer associated with the sales lead. |
|
CustomerRegistryId |
string |
The customer registry identifier. |
|
CustomerSICCode |
string |
The industry code pertaining to the customer. |
|
CustomerSellToAddress |
string |
The sell-to address of the customer associated with the sales lead. |
|
CustomerState |
string |
The state in which customer is located. |
|
CustomerStatus |
string |
The status of the customer associated with the sales lead. |
|
CustomerURL |
string |
The URL address pertaining to the customer. |
|
DaysUntilExpiration |
int |
The number of days prior to expiration of the partner registered lead. |
|
DealAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The total amount attributed to a lead. |
|
DealTypeSetId |
long |
The identifier of the deal type list set. |
|
DecisionMakerIdentifiedFlag |
boolean |
Indicates if the decision maker at customer site is identified. |
|
DeleteFlag |
boolean |
This flag controls if the user has access to delete the record |
|
Description |
string |
The free text description of the record. |
|
Distance |
decimal |
Distance from the input location. |
|
EstimatedCloseDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The estimated close date for the deal once registered. |
|
ExpirationDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The expiration date associated with the sales lead. |
|
FloorNumber |
string |
Specific floor number at a given address or in a particular building when building number is provided. |
|
FollowupTimestamp |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Indicates when the sales lead must be followed up. |
|
IBAssetId |
long |
Unique identifier for the IB Asset associated with the Sales Lead. |
|
IBAssetNumber |
string |
Unique number for the IB Asset associated with the Sales Lead. |
|
IBAssetSerialNumber |
string |
Unique serial number for the IB Asset associated with the Sales Lead. |
|
ImportTaskId |
long |
The unique identifier of the import activity that resulted in the lead being created. |
|
InventoryItemDescription |
string |
The description of the product added to a lead. |
|
JobTitle |
string |
The job title of the primary contact on the sales lead. |
|
LastAssignmentDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the lead was last reassigned. |
|
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the record was last updated. |
|
LastUpdateDateFormatted |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Indicates the date and time of the last update of the row. |
|
LastUpdateLogin |
string |
The login of the user who last updated the record. |
|
LastUpdatedBy |
string |
The user who last updated the record. |
|
Latitude |
decimal |
Latitude information for the location. |
|
LeadAcceptedFlag |
boolean |
Indicates if the lead is accepted. |
|
LeadAging |
decimal |
The number of days elapsed since the lead was created. |
|
LeadCreatedBy |
string |
Functional WHO: Indicates the user who created this record. |
|
LeadCreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Functional WHO: Indicates the date and time when this record is created. |
|
LeadId |
long |
The partner type. Indicates the type of partner stamped on the lead.
|
|
LeadLastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Functional WHO: Indicates the date and time of the last update of the row. |
|
LeadLastUpdatedBy |
string |
Functional WHO: Indicates the user who last updated the row. |
|
LeadNumber |
string |
User friendly unique identifier for the lead. |
|
LeadOrigin |
string |
Origin of the Lead |
|
LongDescription |
string |
The description of the item. |
|
Longitude |
decimal |
Longitude information for the location. |
|
MklLeadResources |
The lead resource for sales lead. |
|
|
MklLeadTcMembers1 |
The lead contacts for sales lead. |
|
|
MklProdAssoc1 |
The lead products for sales lead. |
|
|
Name |
string |
Lead Name used for identifying the lead. |
|
Note |
Notes added to 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. |
|
OrgContactId |
long |
The unique identifier for the primary sales lead contact of the sales lead. |
|
OrganizationSize |
string |
The size of the organization. |
|
OrganizationType |
string |
The type of the organization. |
|
OwnerId |
long |
The party identifier associated with the owner of the sales lead. |
|
OwnerPartyName |
string |
The name associated with the owner of the sales lead. |
|
OwnerResourceOrgId |
long |
The unique identifier for the organization to which the lead owner belongs. |
|
OwnerTreeCode |
string |
The tree code of the resource hierarchy to which the lead owner belongs. |
|
OwnerTreeStructureCode |
string |
The tree structure code of the resource hierarchy to which the lead owner belongs. |
|
OwnerTreeVersionId |
string |
The tree version identifier of the resource hierarchy to which the lead owner belongs. |
|
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. |
|
PartnerProgramName |
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. |
|
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. |
|
PostalPlus4Code |
string |
Four digit extension to the United States Postal ZIP code. |
|
PrimaryContactAddress1 |
string |
The first line of address associated with the primary contact of the lead. |
|
PrimaryContactAddress2 |
string |
The second line of address associated with the primary contact of the lead. |
|
PrimaryContactAddress3 |
string |
The third line of address associated with the primary contact of the lead. |
|
PrimaryContactAddress4 |
string |
The fourth line of address associated with the primary contact of the lead. |
|
PrimaryContactCity |
string |
The city where the primary contact of the lead is located. |
|
PrimaryContactCountry |
string |
The country where the primary contact of the lead is located. |
|
PrimaryContactCountryName |
string |
Full name associated with primary contact's country code. |
|
PrimaryContactCounty |
string |
The county where the primary contact of the lead is located. |
|
PrimaryContactDoNotCallFlag |
boolean |
Do not call flag set at person level for primary contact associated with sales lead. |
|
PrimaryContactDoNotContactFlag |
boolean |
Do not contact flag set at person level for primary contact associated with sales lead. |
|
PrimaryContactDoNotEmailFlag |
boolean |
The do not email flag set at person level for primary contact associated with sales lead. |
|
PrimaryContactDoNotMailFlag |
boolean |
The do not mail flag set at person level for primary contact associated with sales lead. |
|
PrimaryContactEmailAddress |
string |
The email address of the primary sales lead contact on the lead. |
|
PrimaryContactFormattedPhoneNumber |
string |
The formatted version of the phone number for the primary contact on the sales lead. |
|
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. |
|
PrimaryContactPartyStatus |
string |
Status of the primary contact associated with the sales lead. |
|
PrimaryContactPartyType |
string |
The relationship type for the primary contact of the lead. |
|
PrimaryContactPersonFirstName |
string |
The first name of the primary contact for a lead. |
|
PrimaryContactPersonLastName |
string |
The last name of the primary contact for a lead. |
|
PrimaryContactPersonMiddleName |
string |
The middle name of the primary contact for a lead. |
|
PrimaryContactPersonProfileId |
long |
The unique identifier for the sales lead primary contact person row to get dnc flags. |
|
PrimaryContactPostalCode |
string |
The zip code of the location where the primary contact of the lead is located. |
|
PrimaryContactPrimaryAddress |
string |
The primary address of the primary contact associated with the sales lead. |
|
PrimaryContactProvince |
string |
The province where the primary contact of the lead is located. |
|
PrimaryContactRelationshipId |
long |
The unique identifier of the relationship that a primary contact has with the parent organization. |
|
PrimaryContactSellToAddress |
string |
The sell-to address of the primary contact associated with the sales lead. |
|
PrimaryContactState |
string |
The state where the primary contact of the lead is located. |
|
PrimaryContactTitle |
string |
The title of the primary contact for a lead. |
|
PrimaryContactURL |
string |
The URL address pertaining to the primary contact for a lead. |
|
PrimaryInventoryItemId |
long |
The unique identifier of the primary product associated with a lead. |
|
PrimaryInventoryOrgId |
long |
The unique identifier of the organization to which the primary product associated with a lead belongs. |
|
PrimaryPhoneAreaCode |
string |
The area code within a country code. |
|
PrimaryPhoneCountryCode |
string |
The international country code for a telephone number. For example, it is 33 for France. |
|
PrimaryPhoneNumber |
string |
The telephone number in local format. The number should not include country code, area code, or extension. |
|
PrimaryProductGroupId |
long |
The unique identifier of the primary product group associated with a lead. |
|
ProdNameOrGroupName |
string |
The name of the product associated with a lead. |
|
ProductGroupDescription |
string |
The description of the product or product group associated with a lead. |
|
ProductGroupName |
string |
The name of the product group associated with a lead. |
|
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 for a lead. |
|
QualifiedDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Indicates the date when the sales lead was qualified. |
|
QualifiedDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time when the sales lead was qualified. |
|
Rank |
string |
The rank associated with the sales lead. |
|
RankMeaning |
string |
The meaning associated with specific lead rank. |
|
RankSetId |
long |
The identifier of the rank list set identifier. |
|
ReassignComment |
string |
The comment provided by a user while requesting the lead reassignment. |
|
ReassignReasonCode |
string |
The predefined code used to indicate the reason for lead reassignment. |
|
ReassignReasonCodeSetId |
long |
The reassign reason of the list set identifier. |
|
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. |
|
RegistrationStatusMeaning |
string |
The status of the approval request for the partner registered lead. |
|
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 unique identifier of the territory of the sales representative who rejected the sales lead. |
|
RejectByTerritoryVersionId |
long |
The version identifier of the territory of the sales representative who rejected the sales lead. |
|
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. |
|
RejectReasonCdMeaning |
string |
The meaning associated with the codes for lead rejection reason. |
|
RejectReasonCode |
string |
The predefined code used to indicate the reason for rejecting a lead. |
|
RejectReasonCodeSetId |
long |
The identifier of the reject reason list set. |
|
RejectedCount |
long |
The number of times a lead has been rejected by various users. |
|
RejectedDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time when the sales lead was rejected. |
|
RejectedTimestamp |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date and time when a lead was rejected. |
|
RetireComment |
string |
The comments recorded when the sales lead is moved to a retired status. |
|
RetireReasonCdMeaning |
string |
The meaning associated with the codes for lead retirement reason. |
|
RetireReasonCode |
string |
The predefined code used to indicate the reason for retiring a lead. |
|
RetireReasonCodeSetId |
long |
The identifier of the retire reason list set. |
|
RetiredDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time when the sales lead was moved to a retired status. |
|
RetiredTimestamp |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date and time when a lead was retired. |
|
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. |
|
StatusCdMeaning |
string |
The meaning associated with the codes defined to indicate lead status. |
|
StatusCode |
string |
The pre-defined code used to indicate the status. |
|
Timeframe |
string |
The time frame associated with the sales lead. |
|
TimeframeSetId |
long |
The identifier of the time frame list set. |
|
ToReassignFlag |
boolean |
Identifies leads that are marked for reassignment. |
|
ToRescoreFlag |
boolean |
Identifies leads that are marked for scoring. |
|
UniqueName |
string |
The unique name is a concatenation of the lead name and the time stamp. |
|
UpdateFlag |
boolean |
This flag controls if the user has access to update the record |
|
WorkPhoneAreaCode |
string |
The work phone area code for the sales lead contact. |
|
WorkPhoneCountryCode |
string |
The work phone country code for the sales lead contact. |
|
WorkPhoneNumber |
string |
The work phone number for the sales lead contact. |