Salesforce
## Columns
| Type | Name | Description |
| -------- | --------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| DATETIME | \_fivetran\_synced | The time at which fivetran last synced this record |
| STRING | account\_id | ID of the account associated with this opportunity. |
| DECIMAL | amount | Estimated total sale amount. For opportunities with products, the amount is the sum of the related products. |
| INTEGER | campaign\_id | ID of a related Campaign. This field is defined only for those organizations that have the campaign feature Campaigns enabled. |
| DATETIME | close\_date | Required. Date when the opportunity is expected to close. |
| DATETIME | created\_date | Date when the opportunity is was created. |
| INTEGER | opportunity\_description | Text description of the opportunity. |
| DECIMAL | expected\_revenue | Read-only field that is equal to the product of the opportunity Amount field and the Probability. |
| STRING | fiscal | If fiscal years are not enabled, the name of the fiscal quarter or period in which the opportunity CloseDate falls. |
| INTEGER | fiscal\_quarter | Represents the fiscal quarter. Valid values are 1, 2, 3, or 4. |
| INTEGER | fiscal\_year | Represents the fiscal year, for example, 2006. |
| STRING | forecast\_category | The category of the state of the opportunity. Default values are 'pipeline','forecast','bestcase','closed', and 'omited' |
| STRING | forecast\_category\_name | The name of the forecast category. |
| BOOLEAN | has\_open\_activity | Indicates whether an opportunity has an open event or task (true) or not (false). |
| BOOLEAN | has\_opportunity\_line\_item | Read-only field that indicates whether the opportunity has associated line items. A value of true means that Opportunity line items have been created for the opportunity. |
| BOOLEAN | has\_overdue\_task | Indicates whether an opportunity has an overdue task (true) or not (false). |
| STRING | opportunity\_id | The unique, system-generated ID assigned during creation. |
| BOOLEAN | is\_closed | True, if Stage Name Label is Closed. |
| BOOLEAN | is\_deleted | Indicates whether the object has been moved to the Recycle Bin (true) or not (false). |
| BOOLEAN | is\_won | True, if Stage Name Label is Won. |
| DATETIME | last\_activity\_date | Value is one of the following, whichever is the most recent:Due date of the most recent event logged against the record or Due date of the most recently closed task associated with the record. |
| DATETIME | last\_referenced\_date | The timestamp when the current user last accessed this record, a record related to this record, or a list view. |
| DATETIME | last\_viewed\_date | The timestamp when the current user last viewed this record or list view. If this value is null, the user might have only accessed this record or list view (LastReferencedDate) but not viewed it. |
| STRING | lead\_source | Source of this opportunity, such as Advertisement or Trade Show. |
| STRING | opportunity\_name | Required. A name for this opportunity. |
| INTEGER | next\_step | Description of next task in closing opportunity. |
| STRING | owner\_id | Id of the owner of this opportunity |
| DECIMAL | probability | Percentage of estimated confidence in closing the opportunity. |
| STRING | record\_type\_id | ID of the record type assigned to this object. |
| STRING | stage\_name | Required. Current stage of this record. The StageName field controls several other fields on an opportunity. |
| INTEGER | synced\_quote\_id | The ID of the Quote that syncs with the opportunity. |
| STRING | type | Type of opportunity. For example, Existing Business or New Business. |
| BOOLEAN | is\_created\_this\_month | Boolean field, indicating whether the created date is greater than or equal to the first day of this month. |
| BOOLEAN | is\_created\_this\_quarter | Boolean field, indicating whether the created date is greater than or equal to the first day of this quarter. |
| INTEGER | days\_since\_created | The difference in days between the current day and the day the opportunity was created. |
| INTEGER | days\_to\_close | The difference in days between the close day and the day the opportunity was created. |
| BOOLEAN | is\_closed\_this\_month | Boolean field, indicating whether the closed month is equal to the current month. |
| BOOLEAN | is\_closed\_this\_quarter | Boolean field, indicating whether the closed quarter is equal to the current quarter. |
| INTEGER | account\_number | Number of the account associated with this opportunity. |
| STRING | account\_source | The source of the account record. For example, Advertisement, Data.com, or Trade Show. |
| STRING | industry | An industry associated with this account. |
| STRING | account\_name | Name of the account. |
| INTEGER | number\_of\_employees | Number of employees working at the company represented by this account. |
| STRING | account\_type | Type of account, for example, Customer, Competitor, or Partner. |
| STRING | opportunity\_owner\_id | ID of the User who has been assigned to work this opportunity. |
| STRING | opportunity\_owner\_name | The first and last name of the owner. |
| STRING | opportunity\_owner\_role\_id | The ID associated with the owner's user role. |
| INTEGER | opportunity\_owner\_city | The city associated with the owner. |
| INTEGER | opportunity\_owner\_state | The state associated with the owner. |
| STRING | opportunity\_manager\_id | The Id of the user who manages this owner. |
| STRING | opportunity\_manager\_name | The name of the opportunity owner's manager. |
| INTEGER | opportunity\_manager\_city | The city associated with the owner's manager. |
| INTEGER | opportunity\_manager\_state | The state associated with the owner's manager. |
| STRING | opportunity\_owner\_position | Name of the position of the opportunity owner. |
| STRING | opportunity\_owner\_developer\_name | The name of the object of the opportunity owner. |
| STRING | opportunity\_owner\_parent\_role\_id | The ID of the parent role of the opportunity owner. |
| STRING | opportunity\_owner\_rollup\_description | Description of the forecast rollup of the opportunity owner.. |
| STRING | status | Whether the opportunity is won, lost, in the pipeline, or other. |
| INTEGER | created\_amount\_this\_month | The opportunity amount, if created this month. |
| INTEGER | created\_amount\_this\_quarter | The opportunity amount, if created this quarter. |
| INTEGER | created\_count\_this\_month | The opportunity count, if created this month. |
| INTEGER | created\_count\_this\_quarter | The opportunity count, if created this quarter. |
| INTEGER | closed\_amount\_this\_month | The opportunity amount, if closed this month. |
| INTEGER | closed\_amount\_this\_quarter | The opportunity amount, if closed this quarter. |
| INTEGER | closed\_count\_this\_month | The opportunity count, if closed this month. |
| INTEGER | closed\_count\_this\_quarter | The opportunity count, if closed this quarter. |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/salesforce-opportunity-enhanced.md?ask=