OpportunitySources
The opportunity source resource is used to view, create, and update the source of an opportunity.The opportunity source is used to capture the marketing or sales campaign that resulted in this opportunity.
Columns
| Name | Type | ReadOnly | References | Description |
| OptySrcId [KEY] | Long | False |
This is the primary key of the opportunity sources table. | |
| OptyNumber | String | False | ||
| CreatedBy | String | False |
The user who created the record. | |
| CreationDate | Datetime | False |
The date and time when the record was created. | |
| LastUpdateDate | Datetime | False |
The date when the record was last updated. | |
| LastUpdatedBy | String | False |
The user who last updated the record. | |
| LastUpdateLogin | String | False |
The session login associated to the user who last updated the record. | |
| OptyId | Long | False |
The unique Identifier of the opportunity. | |
| SrcNumber | String | False |
A unique number indicating the source of the marketing event for the opportunity, such as campaign, new product line, a marketing seminar, and so on. | |
| UserLastUpdateDate | Datetime | False |
The date and time when the opportunity was last updated from mobile. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| RecordSet | String |
Input specifying the resource type. |
| Finder | String |
Input specifying the Finder type. |