Opportunities data model
The Opportunities data source provides information about opportunities and their attributes, such as owner, type, source, priority, and stage. Furthermore, this data source also tracks all updates done to opportunities.
To learn how to create an opportunity, refer to this Help article: Create a New Opportunity or a Sales Lead.
Example use cases
Opportunities created over time
Number of opportunities by sales stage and owner
Number of opportunities by source
Granularity of the data
At the most basic level, every opportunity is populated as a separate row in this data source. Furthermore, whenever an opportunity is updated, a new row is created with the updated details. All the changes made to opportunities are tracked as new rows. The timestamp of the change is also captured.
In the following table, the green rows represent two distinct opportunities created for a guest named Sarah. Opportunity 111 was created on 1/23 and Opportunity 222 was created on 1/25. These rows represent the latest records corresponding to those particular opportunities, as a result, the opportunity end date field is blank. The current sales stage of both these opportunities is Prospect. In addition, for Opportunity 111, the next lead start date is populated as 1/25 because the same guest has a subsequent opportunity.
The pink rows represent an opportunity 333 for a guest named Lisa. This opportunity has undergone many updates. Joe created the opportunity on 6/21 and Kelly was marked as the owner. A disposition was also entered against the opportunity. The first record for opportunity 333 has the start date populated as the created date, as illustrated in the yellow highlighted cells.
Then on 6/22, Larry updated the owner of the opportunity as himself along with the follow up date details. Due to this, the second record was created. This timestamp of 6/22 (which is the time at which the opportunity was updated) is marked as the opportunity end date for the first record and as the opportunity start date for the second record. The second record captures the updated details. At the same time, Larry also updated the notes field and a third record reflecting this was created.
Later on 6/23, Larry updated the follow up date field again. This timestamp is marked as the opportunity end date for the third record and as the opportunity start date for the fourth record. After one second later, the notes were updated again and a fifth record reflecting this was created. A few hours later, the follow up date field was updated and a sixth record reflecting this was created.
Finally on 6/26, the follow up date field was updated again and the seventh record reflects this change. This last update was done by Dan. The last record represents the most updated record of the opportunity, this is why the opportunity end date field is blank for this record. Every time an opportunity is updated, the time of the update is populated as the end date for the current record as well as the start date for the new record. This is how the entire life cycle of the opportunity is captured.
Group | Description | Field | Definition | Examples/Notes | Data Type |
|---|---|---|---|---|---|
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | organization name | Formal name of the organization. | Massage Spa Express is the formal name of an organization. | varchar(512) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | organization account name | Domain name of the organization in Zenoti. | If you use the https://massagespa.zenoti.com URL to log in to Zenoti, massagespa is your account name. The formal name and domain name may be different. | varchar(256) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | center name | Center in which the opportunity is created. | varchar(128) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | zone name | Zone to which the center belongs. | varchar(800) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | center city | City in which the center is located. | varchar(128) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | center state name | State in which the center is located. | varchar(4096) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | country name | Country in which the center is located. | varchar(4096) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | center zip | Zip code of the center's location. | varchar(32) | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | center company name | Name under which the center is registered. | Businesses, especially in a franchisee model, may register each center as a different company - such details are tracked on the Centers > General tab. | varchar(200) |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | operating center | Flag that indicates whether the center is operational. - True: Operational - False: Not operational | boolean | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | center wid | Unique identifier of the center. This is generated in Analytics; it does not exist in the core system. | bigint | |
Center, Zone, Organization | An organization can be divided into zones, which can be further divided into centers. Here, we refer to the center where the opportunity is created. | minutes to add | Number of minutes that need to be added to UTC time to calculate the current time at the center. Timestamps that are generated by Tableau (for example, if you use filters such as Today and Tomorrow) are in UTC. As a result, you need this field to find out the current center time. Note: You do not need this field for timestamps that are directly in the data source - these timestamps are already in the center's time zone. | int4 | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest wid | Unique identifier of the guest. This is generated in Analytics; it does not exist in the core system. | bigint | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest id | Unique identifier of the guest. This is a non-blank value that is generated in the core system for every guest. | varchar(36) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest code | Unique identifier of the guest. This is a non-mandatory value and it can be blank. This maps to the guest code in a guest's profile in Zenoti. | varchar(128) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest first name | First name of the guest for whom the opportunity was created. | varchar(160) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest middle name | Middle name of the guest for whom the opportunity was created. | varchar(128) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest last name | Last name of the guest for whom the opportunity was created. | varchar(256) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest city | City to which the guest belongs. | varchar(128) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest state | State to which the guest belongs. | varchar(4096) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest country name | Country to which the guest belongs. | varchar(4096) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest zipcode | Zip code of the guest's address. | varchar(128) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest email | Email ID of the guest. | varchar(256) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest mobile phone | Mobile number of the guest. | varchar(64) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest home phone | Home phone number of the guest. | varchar(64) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest phone code | Phone country code of the guest. | integer | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest gender | Gender of the guest. | varchar(14) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest dob | Date of birth of the guest. | timestamp | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest anniversary date | Marriage anniversary date of the guest. | timestamp | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest type name | Indicator of whether the guest is indeed a guest or an employee. | Possible values: - Guest - Employee - Internal Guest/Virtual Guest: Guests who made their first purchase on Webstore. | varchar(128) |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest tags | Tags associated with the guest. | Tags can be set up for guests in their profile under the General tab. If there are multiple tags, they will be comma-separated values. | varchar(65535) |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | is guest inactive | Flag that indicates whether the guest is inactive. A guest is considered inactive if his/her profile has been removed from the system. - True: Guest is inactive. - False: Guest is active. | boolean | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest referral source | Source from where the guest got to know about the organization. | Possible values: - Advertisement - Driving By - Friend - Guest - Instagram - Other - Walkin - Yelp - Youtube | varchar(1600) |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | referred by guestid | Guest ID of the person who referred the guest. | varchar(36) | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest email state | Staus of the guest email based on email delivery status. | Possible values: - 1: notifications will go. - 2: notifications will not go. - 3: Transient - 0: This is to ensure that emails are not sent to addresses that might bounce. | integer |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest receive marketing email | Flag that indicates whether the guest opted for marketing emails. - True: Opted - False: Not opted | boolean | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest receive marketing sms | Flag that indicates whether the guest opted for marketing SMSs. - True: Opted - False: Not opted | boolean | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest receive transactional email | Flag that indicates whether the guest opted for transactional emails. - True: Opted - False: Not opted | boolean | |
Guest | These fields detail the attributes of the guest for whom the opportunity is created. | guest receive transactional sms | Flag that indicates whether the guest opted for transactional SMSs. - True: Opted - False: Not opted | boolean | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | created by first name | First name of the employee who created the opportunity. | varchar(160) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | created by middle name | Middle name of the employee who created the opportunity. | varchar(128) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | created by last name | Last name of the employee who created the opportunity. | varchar(256) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | created by employee - code | Unique code of the employee who created the opportunity. This code is taken from the employee's profile in Zenoti. | varchar(128) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | created by code | Unique code of the employee who created the opportunity. This code is taken from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The employee code is usually the same as employee - code, unless someone manually changes it in the database. | DO NOT USE- THIS FIELD IS BEING DEPRECATED | varchar(128) |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | opportunity created by | Unique ID of the employee who created the opportunity. | varchar(36) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | created by gender | Gender of the employee who created the opportunity. | varchar(14) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | created by mobile phone | Mobile number of the employee who created the opportunity. | varchar(64) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | created by job name | Job name associated with the employee who created the opportunity. | Therapist, Manager, Aesthetician, etc. | varchar(1020) |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | created by job code | Unique code associated with the job of the employee who created the opportunity. | varchar(8000) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | is created by inactive | Flag that indicates whether the employee who created the opportunity is inactive. An employee is considered inactive if they have been removed from the system. - True: Employee is inactive. - False: Employee is active. | boolean | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | owner first name | First name of the sales owner of the opportunity. | varchar(160) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | owner middle name | Middle name of the sales owner of the opportunity. | varchar(128) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | owner last name | Last name of the sales owner of the opportunity. | varchar(256) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | owner employee - code | Unique code of the sales owner of the opportunity. This code is taken from the employee's profile in Zenoti. | varchar(128) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | owner code | Unique code of the sales owner of the opportunity. This code is taken from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The employee code is usually the same as employee - code, unless someone manually changes it in the database. | DO NOT USE- THIS FIELD IS BEING DEPRECATED | varchar(128) |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | owner gender | Gender of the sales owner of the opportunity. | varchar(14) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | owner mobile phone | Mobile number of the sales owner of the opportunity. | varchar(64) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | owner job name | Job name associated with the sales owner of the opportunity. | Therapist, Manager, Aesthetician etc. | varchar(1020) |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | owner job code | Unique code associated with the job of the sales owner of the opportunity. | varchar(8000) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | is owner inactive | Flag that indicates whether the sales owner of the opportunity is inactive. An employee is considered inactive if they have been removed from the system. - True: Employee is inactive. - False: Employee is active. | boolean | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | updated by first name | First name of the employee who updated the opportunity. | varchar(160) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | updated by middle name | Middle name of the employee who updated the opportunity. | varchar(128) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | updated by last name | Last name of the employee who updated the opportunity. | varchar(256) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | updated by employee - code | Unique code of the employee who updated the opportunity. This code is taken from the employee's profile in Zenoti. | varchar(128) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | updated by code | Unique code of the employee who updated the opportunity. This code is taken from the employee's guest profile. When an employee's profile is created, Zenoti automatically creates their guest profile. Note: The employee code is usually the same as employee - code, unless someone manually changes it in the database. | DO NOT USE- THIS FIELD IS BEING DEPRECATED | varchar(128) |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | updated by gender | Gender of the employee who updated the opportunity. | varchar(14) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | updated by mobile phone | Mobile number of the employee who updated the opportunity. | varchar(64) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | updated by job name | Job name associated with the employee who updated the opportunity. | Therapist, Manager, Aesthetician, etc. | varchar(1020) |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | updated by job code | Unique code associated with the job of the employee who updated the opportunity. | varchar(8000) | |
Employee | These fields detail the attributes of three types of employees: - Created By: Employee who created the opportunity. - Owner: Sales owner of the opportunity. - Updated By: Employee who updated the opportunity. | is updated by inactive | Flag that indicates whether the employee who updated the opportunity is inactive. An employee is considered inactive if they have been removed from the system. - True: Employee is inactive. - False: Employee is active. | boolean | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity id | Unique identifier of the opportunity. This is a non-blank value that is generated in the core system for every opportunity. This is unique across the organization. | varchar(36) | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity no | Unique identifier of the opportunity. This is a non-mandatory value and it can be blank. This maps to the opportunity number in the core system. This is unique within each center. | integer | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity title | Title of the opportunity. | varchar(16000) | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity desc | Description of the opportunity. | varchar(16000) | |
Opportunity | These fields detail the attributes of the opportunity. | priority name | Priority set for the opportunity. Possible values: - High - Medium - Low | varchar(64) | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity type | Type of the opportunity. | For example, Memberships, Packages, Products, and Others. | varchar(16000) |
Opportunity | These fields detail the attributes of the opportunity. | opportunity source name | Source of the opportunity. | varchar(256) | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity source description | Description of the opportunity source. | varchar(4096) | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity source code | Code assigned to the opportunity source. | varchar(256) | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity source active | Flag that indicates whether the opportunity source is active. - True: Opportunity is active. - False: Opportunity is inactive. | boolean | |
Opportunity | These fields detail the attributes of the opportunity. | optional field 1 | Optional field 1 to add more information about the opportunity source. | varchar(14) | |
Opportunity | These fields detail the attributes of the opportunity. | optional field 2 | Optional field 2 to add more information about the opportunity source. | varchar(16000) | |
Opportunity | These fields detail the attributes of the opportunity. | optional field 3 | Optional field 3 to add more information about the opportunity source. | varchar(16000) | |
Opportunity | These fields detail the attributes of the opportunity. | optional field 4 | Optional field 4 to add more information about the opportunity source. | varchar(16000) | |
Opportunity | These fields detail the attributes of the opportunity. | sales stage | Sales stage of the opportunity. | Example: Prospect, Lead, Won, Active, Cancelled etc. | varchar(64) |
Opportunity | These fields detail the attributes of the opportunity. | list price | Actual price for the opportunity. | float | |
Opportunity | These fields detail the attributes of the opportunity. | offered price | Offered price for the opportunity. This price can either be same as List Price or a bit lower so as to attract guests to make the purchase. | float | |
Opportunity | These fields detail the attributes of the opportunity. | follow up date | Next follow-up date for the business to contact the guest. | timestamp | |
Opportunity | These fields detail the attributes of the opportunity. | expected close date | Expected close date of the opportunity. | timestamp | |
Opportunity | These fields detail the attributes of the opportunity. | notes | Notes entered against the opportunity. | varchar(65535) | |
Opportunity | These fields detail the attributes of the opportunity. | no sale comments | Comments that the front-desk executive enters when the sale of an intended service, membership, or package does not take place. | For example, a guest comes in for a paid consulation for a weight loss program. The consultant may not recommend that the guest undertake the program due to medical conditions. In such a scenario, the front-desk executive may enter a comment such as: "Guest has a medical condition - the medical consultant advises against taking this program." Such comments are displayed under the No Sale Comments column. | varchar(65535) |
Opportunity | These fields detail the attributes of the opportunity. | optional text 1 | Optional text field 1 to add more information about the opportunity. | varchar(16000) | |
Opportunity | These fields detail the attributes of the opportunity. | optional text 2 | Optional text field 2 to add more information about the opportunity. | varchar(16000) | |
Opportunity | These fields detail the attributes of the opportunity. | optional text 3 | Optional text field 3 to add more information about the opportunity. | varchar(16000) | |
Opportunity | These fields detail the attributes of the opportunity. | disposition name | Outcome/response of the calls to prospective customers. | varchar(1600) | |
Opportunity | These fields detail the attributes of the opportunity. | disposition description | Description of the call disposition. | varchar(16000) | |
Opportunity | These fields detail the attributes of the opportunity. | dispostion followup days | Number of days after which the prospective customer should be contacted. | integer | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity created date | Date on which the opportunity was created. This date is in the center time zone. | timestamp | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity created date utc | Date on which the opportunity was created. This date is in UTC time zone. | timestamp | |
Opportunity | These fields detail the attributes of the opportunity. | opportunity start date | Start date of the opportunity. This date is in the center time zone. | When an opportunity is created, this field displays the created timestamp. When an opportunity is modified, a new row is created and the new row has this field populated with the modified timestamp. | timestamp |
Opportunity | These fields detail the attributes of the opportunity. | opportunity end date | Expiry or end date of the opportunity. This date is in the center time zone. | When an opportunity is created, this field shows the end/expiry timestamp. When an opportunity is modified, a new row is created and the old row is modified to populate this field with the modified timestamp. | timestamp |
Opportunity | These fields detail the attributes of the opportunity. | next lead start date | Start date of the subsequent opportunity for the same guest. This is only populated if the guest has another opportunity post the current one. | timestamp | |
Opportunity | These fields detail the attributes of the opportunity. | invoicecreateddate | Invoice item created date of the first invoice after the creation of the opportunity within the same business unit. | Note: Do not use this field. It is relevant for very specific scenarios only. | date |
Opportunity | These fields detail the attributes of the opportunity. | conv_leg | If an invoice is created on the same day as the opportunity was created within the same business unit, this field is populated as 1. If no invoice is created on the same day as the opportunity was created within the same business unit, but there is an invoice after that date, this field is populated as 2. Else, this field is populated as 0. | Note: Do not use this field. It is relevant for very specific scenarios only. | integer |
Opportunity | These fields detail the attributes of the opportunity. | oppurtunity voided | Flag that indicates whether the opportunity is voided or not. -True: Opportunity is deleted -False: Opportunity is not deleted | varchar(14) | |
Opportunity | These fields detail the attributes of the opportunity. | issuewid | Unique identifier of every row in the data source. | bigint | |
Opportunity | These fields detail the attributes of the opportunity. | issue type name | Name of the issue type. This populates a static value: Opportunities. | varchar(1020) |