Deals

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	False	The unique identifier for this record.
DealOwner_Id	String	False	The Id of the deal owner.
DealOwner_Name	String	True	The name of the deal owner.
Amount	Double	False	The amount of the deal.
DealName	String	False	The name of the deal.
ClosingDate	Date	False	The closing date of the dal.
AccountName_Id	String	False	The Id of the account who created the deal.
AccountName_Name	String	True	The name of the account who created the deal.
Stage	String	False	The stage in which the deal is in.
Type	String	False	The type of the deal.
Probability_	Int	False	The probability this deal has of being closed.
NextStep	String	False	The next step of the deal.
ExpectedRevenue	Double	True	The expected revenue from the deal.
LeadSource	String	False	The source of the deal.
CampaignSource_Id	String	False	The Id of the campaign source concerning this deal.
CampaignSource_Name	String	True	The name of the campaign source concerning this deal.
ContactName_Id	String	False	The Id of the contact regarding this deal.
ContactName_Name	String	True	The name of the contact regarding this deal.
CreatedBy_Id	String	False	The Id of the User who created the record.
CreatedBy_Name	String	True	The name of the user who created the record.
ModifiedBy_Id	String	False	The Id of the User who modified the record.
ModifiedBy_Name	String	True	The name of the User who modified the record.
CreatedTime	Datetime	False	The time when the record was created.
Tag	String	False	A list of tags regarding this deal.
ModifiedTime	Datetime	False	The time when the record was modified.
LastActivityTime	Datetime	False	The last activity time of this deal.
LeadConversionTime	Int	False	The time it took for this lead to convert.
SalesCycleDuration	Int	False	The duration of sales cycles it took for this deal.
OverallSalesDuration	Int	False	The overal sales duration of this deal.
Description	String	False	The descrption of this deal.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Word	String	Used to search for a specific word in records.
DuplicateCheckFields	String	The field/s to be used for checking in an upsert.
Converted	Boolean	Set to true to return only converted records.
Approved	Boolean	Set to true to return only approved records.
CustomViewId	String	The custom view Id to be used for filtering this record.