Leads
Usage information for the operation Leads.rsd.
Columns
Name | Type | ReadOnly | References | Description |
LeadId [KEY] | Long | False |
Partner Type. Indicates the type of partner stamped on the lead. | |
AcceptedDate | Date | False |
The date on which lead was accepted by a resource assigned to it. | |
AcceptedDateTime | Datetime | False |
Date and time when the sales lead is accepted by a resource assigned to it. | |
AccountPartyNumber | String | False | ||
AddrElementAttribute1 | String | False |
Additional address element to support flexible address format. | |
AddrElementAttribute2 | String | False |
Additional address element to support flexible address format. | |
AddrElementAttribute3 | String | False |
Additional address element to support flexible address format. | |
AddrElementAttribute4 | String | False |
Additional address element to support flexible address format. | |
AddrElementAttribute5 | String | False |
Additional address element to support flexible address format. | |
AddressLinesPhonetic | String | False |
Phonetic or Kana representation of the Kanji address lines (used in Japan). | |
ApprovalDate | Date | False |
The date on which a partner registered lead is approved by internal channel manager. | |
ApprovalDateTime | Datetime | False |
Date and time when the sales lead is approved. This is only applicable to deal registrations. | |
AssetId | Long | False |
Unique identifier for the Asset associated with the Sales Lead. | |
AssetNumber | String | False |
Unique Number for the Asset associated with the Sales Lead. | |
AssetSerialNumber | String | False |
Serial Number for the Asset associated with the Sales Lead. | |
AssignmentStatusCode | String | False |
Includes the current assignment related status for the lead, for example whether the lead is assigned or unassigned. | |
BudgetAmount | Decimal | False |
Budget amount associated with this sales lead. | |
BudgetCurrencyCode | String | False |
Currency code associated with the Budget Amount associated with this sales lead. | |
BudgetStatus | String | False |
Budget status associated with the Budget Amount associated with this sales lead. | |
Building | String | False |
Specific building name or number at a given address. | |
BusinessUnitId | Long | False |
Business Unit Identifier associated with the business unit of the sales lead creator. | |
CampaignName | String | False |
Name of the campaign associated with the sales lead. | |
ChannelType | String | False |
Indicates the channel through which this lead contacted the company. | |
ClassCode1 | String | False |
The auxilliary dimension for the Account. | |
ClassCode2 | String | False |
The auxilliary dimension for the Account. | |
ClassCode3 | String | False |
The auxilliary dimension for the Account. | |
ClassCode4 | String | False |
The auxilliary dimension for the Account. | |
ContactFormattedAddress | String | False | ||
ContactPartyNumber | String | False | ||
ContactTimezoneCd | String | False |
Preferred time zone of the contact pursued on the lead. | |
ConvertedDateTime | Datetime | False |
Date and time when the sales lead is converted to an opportunity. | |
CreatedBy | String | False |
Indicates the user who created this record. | |
CreationDate | Datetime | False |
Indicates the date and time when this record is created. | |
CurrencyCode | String | False |
Currency code for the lead. | |
CustomerId | Long | False |
Customer Id. It is a reference to the customer record in the TCA schema. | |
CustomerNeed | String | False |
Indicates what need the lead product serves for the lead customer. | |
CustomerPartyName | String | False |
Name of the customer. | |
DealAmount | Decimal | False |
The total amount attributed to a lead. | |
DecisionMakerIdentifiedFlag | Bool | False |
Indicates if the decision maker at customer site has been identified. | |
DeleteFlag | Bool | False |
This flag controls if the user has access to delete the record | |
Description | String | False |
Description associated with this sales lead. | |
Distance | Double | False |
Distance from the input location. | |
EstimatedCloseDate | Date | False |
Estimated close date for a deal once registered | |
ExpirationDate | Date | False |
Expiration date associated with this sales lead. | |
FloorNumber | String | False |
Specific floor number at a given address or in a particular building when building number is provided. | |
FormattedPhoneNumber1 | String | False | ||
InventoryItemDescription | String | False |
The description of the product added to a lead. | |
JobTitle | String | False |
Job title of the primary contact on the sales lead. | |
LastAssignmentDate | Datetime | False |
The date on which the lead was last reassigned. | |
LastUpdateDate | Datetime | False |
Who column: indicates the date and time of the last update of the row. | |
LastUpdateLogin | String | False |
Who column: indicates the login of the user who last updated the row. | |
LastUpdatedBy | String | False |
Who column: indicates the user who last updated the row. | |
Latitude | Double | False |
Latitude information for the location. | |
LeadAcceptedFlag | Bool | False |
Indicates if the lead has been accepted. | |
LeadAging | Long | False |
The number of days elapsed since the lead was created. | |
LeadCreatedBy | String | False |
Functional WHO: Indicates the user who created this record. | |
LeadCreationDate | Datetime | False |
Functional WHO: Indicates the date and time when this record is created. | |
LeadLastUpdateDate | Datetime | False |
Functional WHO: Indicates the date and time of the last update of the row. | |
LeadLastUpdatedBy | String | False |
Functional WHO: Indicates the user who last updated the row. | |
LeadNumber | String | False |
User friendly unique identifier for a lead. | |
Longitude | Double | False |
Longitude information for the location. | |
Name | String | False |
Lead Name used for identifying the lead. | |
OrganizationSize | String | False |
Organization Size | |
OrganizationType | String | False |
Organization Type | |
OwnerId | Long | False |
Party identifier associated with the owner of this sales lead. | |
OwnerPartyName | String | False |
Name associated with the owner of this sales lead. | |
OwnerPartyNumber | String | False | ||
PartnerCompanyNumber | String | False | ||
PartnerId | Long | False |
Unique identifier for the primary partner associated with the lead. | |
PartnerPartyName | String | False |
Name associated with the primary partner of this sales lead. This is a deal specific attribute. | |
PartnerProgramId | Long | False |
A reference to the partner program in which the primary partner associated with this sales lead is enrolled. This is a deal specific attribute. | |
PartnerProgramNumber | String | False | ||
PartnerType | String | False |
Indicates the type of the primary partner associated with this sales lead. This is a deal specific attribute. | |
PostalPlus4Code | String | False |
Four digit extension to the United States Postal ZIP code. | |
PrimaryContactAddress1 | String | False |
The first line of address associated with the primary contact of the lead. | |
PrimaryContactAddress2 | String | False |
The second line of address associated with the primary contact of the lead. | |
PrimaryContactAddress3 | String | False |
The third line of address associated with the primary contact of the lead. | |
PrimaryContactAddress4 | String | False |
The fourth line of address associated with the primary contact of the lead. | |
PrimaryContactCity | String | False |
The city where the primary contact of the lead is located. | |
PrimaryContactCountry | String | False |
The country where the primary contact of the lead is located. | |
PrimaryContactCountryName | String | False |
Full name associated with primary contact country code | |
PrimaryContactCounty | String | False |
The county where the primary contact of the lead is located. | |
PrimaryContactEmailAddress | String | False |
Email address for the primary sales lead contact on the lead | |
PrimaryContactId | Long | False |
Identifer of the sales lead contact marked as a primary lead contact. | |
PrimaryContactPartyName | String | False |
Name associated with the primary lead contact. | |
PrimaryContactPersonFirstName | String | False |
First name of the primary contact for a lead. | |
PrimaryContactPersonLastName | String | False |
Last name of the primary contact for a lead. | |
PrimaryContactPersonMiddleName | String | False |
Middle name of the primary contact for a lead. | |
PrimaryContactPostalCode | String | False |
The zip code where the primary contact of the lead is located. | |
PrimaryContactProvince | String | False |
The province where the primary contact of the lead is located. | |
PrimaryContactRelationshipId | Long | False |
Unique identifier of the relationship primary contact has with its parent organization. | |
PrimaryContactState | String | False |
The state where the primary contact of the lead is located. | |
PrimaryInventoryItemId | Long | False |
Unique identifier of the primary product associated with a lead. | |
PrimaryInventoryItemNumber | String | False | ||
PrimaryInventoryOrgId | Long | False |
Unique identifier of the organization to which the primary product associated with a lead belongs. | |
PrimaryPhoneAreaCode | String | False |
Primary phone area code for the sales lead contact. | |
PrimaryPhoneCountryCode | String | False |
Primary phone country code for the sales lead contact. | |
PrimaryPhoneNumber | String | False |
Primary phone number for the sales lead contact. | |
PrimaryProductGroupId | Long | False |
Unique identifier of the primary product group associated with a lead. | |
PrimaryProductGroupReferenceNumber | String | False | ||
ProductGroupDescription | String | False |
Description of the product or product group associated with a lead. | |
ProductGroupName | String | False |
Name of the product group associated with a lead. | |
ProgramName | String | False |
Name of the partner program in which the primary partner associated with this sales lead is enrolled. This is a deal specific attribute. | |
Project | String | False |
customer project identified for this sales lead. | |
QualificationScore | Long | False |
Qualification score for a lead. | |
QualifiedDate | Date | False |
Indicates the date when this sales lead was qualified. | |
QualifiedDateTime | Datetime | False |
Date and time when the sales lead is qualified. | |
Rank | String | False |
Rank associated with this sales lead. | |
ReassignComment | String | False |
Comment provided by a user while requesting the lead reassignment. | |
ReassignReasonCode | String | False |
Pre-defined code used to indicate the reason for lead reassignment. | |
RecordSet | String | False | ||
RegistrationNumber | String | False |
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 | False |
Approval Status of the sales lead. This is a deal specific attribute. | |
RegistrationType | String | False |
Indicates the registration type of the sales lead. This is a deal specific attribute. | |
RejectByUserId | Long | False |
Identifier of the sales representative who rejected this sales lead. | |
RejectComment | String | False |
Comments provided by the sales representative who rejected this sales lead. | |
RejectReasonCode | String | False |
Pre-defined code used to indicate the reason for rejecting a lead. | |
RejectedDateTime | Datetime | False |
Date and time when the sales lead is rejected. | |
RetireComment | String | False |
Comments recorded when the sales lead is moved to a retired status. | |
RetireReasonCode | String | False |
Pre-defined code used to indicate the reason for retiring a lead. | |
RetiredDateTime | Datetime | False |
Date and time when the sales lead is moved to a retired status. | |
SalesChannel | String | False |
Indicates the sales channel responsible for following up on this sales lead. | |
Score | Long | False |
The score associated with this sales lead. This score is computed based on the scoring rules. | |
SourceCode | String | False |
Marketing source code associated with this sales lead. | |
StatusCode | String | False |
Pre-defined code used to indicate the status of a lead. | |
Timeframe | String | False |
Timeframe associated with this sales lead. | |
ToReassignFlag | Bool | False |
Identifies leads that are marked for reassignment. | |
UpdateFlag | Bool | False |
This flag controls if the user has access to update the record | |
WorkPhoneAreaCode | String | False |
Work phone area code for the sales lead contact. | |
WorkPhoneCountryCode | String | False |
Work phone country code for the sales lead contact. | |
WorkPhoneNumber | String | False |
Work phone number for the sales lead contact. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Finder | String |
Input specifying the Finder type. |
ContactId | String |
The unique identifier of the Contact. |
SysEffectiveDate | String |
SysEffectiveDate. |
ResourcePartyIdRest | String |
The unique identifier of the Resource. |
RestCreationDateLower | String |
Finds the leads that are created before the date specified. |
RestCreationDateUpper | String |
Finds the leads with the specified creation date. |
RestRecordSet | String |
Finds the leads with the specified record set value. |
RestStatusCode | String |
Finds the leads with the specified status code. |