Data Dictionary
Field | Type | Notes |
Amount | Number | The Amount in the Currency of the Deal |
Amount (RC) | Number | Amount In Home Currency |
Archived | Boolean | True if the Deal has been archived |
CCO ID | Integer | The Connectorly Connection ID. If you group Connectorly's together, then you will see a CCO ID for each one. Organisations has the corresponding Connection Name for each CCO ID. |
Campaign | Text | |
Closed Amount | Number | The Closed Amount in the Currency of the Deal |
Closed Amount (RC) | Number | Closed Amount In Home Currency |
Closed Lost Reason | Text | |
Closed Won Count | Number | |
Closed Won Date | Datetime | |
Created | Datetime | The date and time that a record was created. |
Created By | Number | The Owner ID of the person that created the record. |
Created Date | Date | The date that a record was created. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on. |
Data current as of | Datetime | Gives the date and time that this record was taken from HubSpot. |
Days To Close | Number | |
Deal Currency | Text | Deal Currency Code |
Deal Name | Text | Dealname |
Deal Pipeline | Text | Pipeline |
Deal Stage | Text | Dealstage |
Deal Stage Probability | Number | |
Deal Type | Text | Dealtype |
Description | Text | |
Discount Amount | Number | |
Exchange Rate | Number | |
First Company ID | Integer | |
First Contact ID | Integer | |
Forecast Amount | Number | |
Forecast Close Date | Date | Closedate |
Forecast Probability | Number | |
Is Closed | Boolean | |
Is Closed Won | Boolean | |
Link | Text | |
Manual Forecast Category | Text | |
Next Step | Text | |
Number Of Line Items | Number | Of Associated Line Items |
Object ID | Integer | |
Order Number | Text | |
Owner ID | Integer | The Owner ID of the person that owns/is responsible for the record. Not necessarily the same as the Created By Owner ID. Find related details in the Owners table. |
Predicted Amount | Number | The Predicted Amount in the Currency of the Deal |
Predicted Amount (RC) | Number | Predicted Amount In Home Currency |
Priority | Text | |
Projected Amount | Number | |
Projected Amount (RC) | Number | Projected Amount In Home Currency |
Tag IDs | Text | Tag Ids |
Tax Amount | Number | |
Type | Text | |
Type | Text | |
Type | Text | |
Updated | Datetime | The date and time that the record was updated. |
Updated Date | Date | The date that a record was updated. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on. |