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