OpportunityRevenueProducts
The following table describes the default response for this task.
Columns
| Name | Type | References | Description |
| ProductNum [KEY] | String | The number of the product. | |
| RevnId [KEY] | String | ||
| OptyNumber [KEY] | String | ||
| ActiveFlag | Boolean | Indicates if the product is Active. | |
| Description | String | The description of the product associated with the opportunity. | |
| EndDate | Datetime | The effective end date of the product. | |
| InventoryItemId | Long | The unique identifier of the product inventory item associated with the opportunity. | |
| InvOrgId | Long | The unique identifier of the inventory organization. | |
| LastUpdateDate | Datetime | The date the product was last updated. | |
| LongDescription | String | Text to describe the product. | |
| ProdGroupId | Long | The unique identifier of the Product Group. | |
| ProductType | String | The type of the product. | |
| StartDate | Datetime | The effective start date of the product. | |
| Text | String | The text or keywords associated with the product. | |
| 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. |