OpportunityRevenueProductGroups
The product group resource is used to view, create, and update the product groups associated with an opportunity. The product group let you categorize products and services that you sell.
Columns
| Name | Type | References | Description |
| ProdGroupId [KEY] | Integer | This is the primary key of the revenue territories table. | |
| RevnId [KEY] | Long | ||
| OptyNumber [KEY] | String | ||
| Description | String | The user-provided description of the product group. | |
| DisplayName | String | The name of the product group. | |
| LastUpdateDate | String | The date the product group was last updated. | |
| 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. | |
| OptyId | String | Input specifying the Opty Id. |