OpportunityRevenueProducts
The following table describes the default response for this task.
Columns
Name | Type | ReadOnly | References | Description |
ProductNum [KEY] | String | False |
The number of the product. | |
RevnId [KEY] | String | False | ||
OptyNumber [KEY] | String | False | ||
ActiveFlag | Boolean | False |
Indicates if the product is Active. | |
Description | String | False |
The description of the product associated with the opportunity. | |
EndDate | Datetime | False |
The effective end date of the product. | |
InventoryItemId | Long | False |
The unique identifier of the product inventory item associated with the opportunity. | |
InvOrgId | Long | False |
The unique identifier of the inventory organization. | |
LastUpdateDate | Datetime | False |
The date the product was last updated. | |
LongDescription | String | False |
Text to describe the product. | |
ProdGroupId | Long | False |
The unique identifier of the Product Group. | |
ProductType | String | False |
The type of the product. | |
StartDate | Datetime | False |
The effective start date of the product. | |
Text | String | False |
The text or keywords associated with the product. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
RecordSet | String |
Input specifying the resource type. |
Finder | String |
Input specifying the Finder type. |