DealHistory
Query information regarding deal history.
Columns
| Name | Type | Description |
| Id [KEY] | String | |
| DealName_Id | String | |
| DealName_Name | String | |
| Stage | String | |
| StageDuration(CalendarDays) | Int | |
| ModifiedBy_Id | String | |
| ModifiedBy_Name | String | |
| ModifiedTime | Datetime | |
| Amount | Decimal | |
| Probability(%) | Int | |
| ExpectedRevenue | Decimal | |
| ClosingDate | Date | |
| RecordId | Long | |
| LastActivityTime | Datetime | |
| MovedTo | String |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DuplicateCheckFields | String | The field/s to be used for checking in an upsert. |
| CustomViewId | Long | The custom view Id to be used for filtering this record. Will work when useCOQL=false. |
| Trigger | String | To trigger the rule while inserting record into CRM account. |