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. |