OpportunityDeals
A deal associated with the opportunity.
Columns
| Name | Type | References | Description |
| OptyDealId [KEY] | Long | This is the primary key of the opportunity deals table. | |
| OptyNumber [KEY] | String |
Opportunities.OptyNumber | |
| CreatedBy | String | The user who created the opportunity deal record. | |
| CreationDate | Datetime | The date and time when the opportunity deal record was created. | |
| DealId | Long | The unique identifier of the deal. | |
| LastUpdateDate | Datetime | The date and time when the opportunity deal record was last updated. | |
| LastUpdatedBy | String | The user who last updated the opportunity deal record. | |
| LastUpdateLogin | String | The session login associated to the user who last updated the opportunity deal record. | |
| OptyId | Long | The unique identifier of the opportunity. | |
| PartyName | String | The name of the partner. | |
| OpportunityLastUpdateDate | Datetime | The date and time when the opportunity was last updated. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. | |
| 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. |