OpportunityLeads
The opportunity lead resource is used to view, create, and update the lead that resulted in an opportunity.
Columns
| Name | Type | ReadOnly | References | Description |
| OptyLeadId [KEY] | Long | False |
This is the primary key of the opportunity leads table. | |
| OptyNumber [KEY] | String | False |
Opportunities.OptyNumber | |
| CreatedBy | String | False |
The user who created the record. | |
| CreationDate | Datetime | False |
The date and time when the record was created. | |
| DealEstimatedCloseDate | Date | False |
The date when the deal registration for the opportunity is estimated to be closed. | |
| DealExpirationDate | Date | False |
The date when the lead registration will expire. | |
| DealPartProgramId | Long | False |
The unique identifier of the partner program associated with the lead registration. | |
| DealType | String | False |
The deal or lead registration type for the opportunity. | |
| LastUpdateDate | Datetime | False |
The date when the record was last updated. | |
| LastUpdatedBy | String | False |
The user who last updated the record. | |
| LastUpdateLogin | String | False |
The session login associated to the user who last updated the record. | |
| LeadNumber | String | False |
The unique identification number for the lead. | |
| OptyId | Long | False |
The unique identifier of the opportunity. | |
| PartnerTypeCd | String | False |
The type of the partner for the lead registration. | |
| PrDealPartOrgPartyId | Long | False |
The unique identifier for the partner on the lead registration. | |
| PrDealPartResourcePartyId | Long | False |
The unique identifier for the primary partner resource on the lead registration. | |
| RegistrationNumber | String | False |
The unique registration number of the lead for the opportunity. | |
| UserLastUpdateDate | Datetime | False |
The date and time when the opportunity lead was last updated from mobile. | |
| OpportunityLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. | |
| LeadNumber | String | False |
The alternate key identifier of the lead. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| RecordSet | String |
Input specifying the resource type. |
| Finder | String |
Input specifying the Finder type. |
| PartyId | String |
Input specifying the Party Id. |
| PartyIdAttribute | String |
Input specifying the Party Id Attribute. |
| AttributeName | String |
Input specifying the Attribute Name. |
| RollUpId | String |
Input specifying the RollUp Id. |
| SourceObject | String |
Input specifying the Source Object. |
| SourceObjectId | String |
Input specifying the Source Object Id. |
| ClosePeriod | String |
Input specifying the Close Period. |
| ContactPartyId | String |
Input specifying the Contact Party Id. |
| EffectiveBeginDate | String |
Input specifying the Effective BeginDate. |
| EffectiveEndDate | String |
Input specifying the Effective EndDate. |
| LookupCategory | String |
Input specifying the Lookup Category. |
| OpportunityContactName | String |
Input specifying the Opportunity Contact Name. |
| OptyStatusCode | String |
Input specifying the Opty StatusCode. |
| Partner | String |
Input specifying the Partner. |
| PartnerPartyId | String |
Input specifying the Partner Party Id. |
| Product | String |
Input specifying the Product. |
| ProductGroup | String |
Input specifying the Product Group. |
| ReferenceName | String |
Input specifying the Reference Name. |
| ResourcePartyId | String |
Input specifying the Resource Party Id. |
| TeamMember | String |
Input specifying the Team Member. |
| Name | String |
Input specifying the Name. |