OpportunityPartners
The opportunity partner resource is used to view, create, and update the partners associated with this opportunity.The opportunity partner is used to store information about partners who are contributing to the selling effort of the current opportunity.
Columns
| Name | Type | ReadOnly | References | Description |
| RevnPartOrgPartyId [KEY] | Long | False |
This is the primary key of the opportunity partners 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 contact record was created. | |
| DealEstCloseDate | Datetime | False |
The date when the deal registration is estimated to close. | |
| DealExpirationDate | Datetime | False |
The date when the deal registration will expire. | |
| DealType | String | False |
The type of deal registration. | |
| 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. | |
| OptyId | Long | False |
The unique identifier of the opportunity. | |
| PartOrgEmailAddress | String | False |
The email address of the primary partner organization for this revenue. | |
| PartOrgFormattedPhoneNumber | String | False |
The phone number of the primary partner organization for this revenue. | |
| PartOrgPartyId | Long | False |
The unique identifier of the partner organization associated with the revenue. | |
| PartProgramId | Long | False |
The unique identifier of the partner program associated with the revenue. | |
| PartTypeCd | String | False |
The type of the party associated with the summary or primary revenue of the opportunity. | |
| PartyId | Long | False |
The unique identifier of the partner party is associated with the opportunity. | |
| PartyName | String | False |
The name of the partner associated with the opportunity. | |
| PartyName1 | String | False |
The name of the primary partner resource associated with the opportunity. | |
| PreferredContactEmail | String | False |
The e-mail address of the partner's primary contact. | |
| PreferredContactName | String | False |
The name of the partner's primary contact. | |
| PreferredContactPhone | String | False |
The phone number of the partner's primary contact. | |
| PrPartResourcePartyId | Long | False |
The unique identifier of the primary partner resource. | |
| RegistrationNumber | String | False |
The registration number of the deal registration. | |
| RegistrationStatus | String | False |
The registration status of the partner who create the opportunity or deal. | |
| RevnId | Long | False |
The unique identifier of the summary or primary revenue for the opportunity. | |
| RevnPartnerNumber | String | False |
The unique number of the associated between the opportunity partner and a revenue line. | |
| OpportunityLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| RecordSet | String |
Input specifying the resource type. |
| Finder | String |
Input specifying the Finder type. |
| 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. |
| LeadNumber | String |
Input specifying the Lead Number. |
| 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. |