Data Dictionary
Field | Type | Notes |
Allowed Payment Methods | Text | |
Approver ID | Integer | |
Archived | Boolean | True if the Quote 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. |
Comments | Text | |
Created | Datetime | The date and time that a record was created. |
Created By | Integer | 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. |
Currency | Text | |
Data current as of | Datetime | Gives the date and time that this record was taken from HubSpot. |
Esign Date | Date | |
Esign Enabled | Boolean | |
Expiration Date | Date | |
First Company ID | Integer | |
First Contact ID | Integer | |
Language | Text | |
Link | Text | |
Locale | Text | |
Logo URL | Text | |
Manually Signed | 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. |
PDF Download Link | Text | Pdf Download Link |
Payment Date | Text | |
Payment Enabled | Text | |
Payment Status | Text | |
Payment Type | Text | |
Public URL Key | Text | |
Quote Amount | Number | |
Quote Link | Text | |
Quote Number | Text | |
Sender Company Domain | Text | |
Sender Company Name | Text | |
Sender Email | Text | |
Sender First Name | Text | Sender Firstname |
Sender Image URL | Text | |
Sender Last Name | Text | Sender Lastname |
Sender Name | Text | |
Status | Text | |
Template Type | Text | |
Terms | Text | |
Timezone | Text | |
Title | Text | |
Type | Text | |
Type | Text | |
Type | Text | |
Updated | Datetime | The date and time that the record was updated. |
Updated By | Integer | The Owner ID of the person that updated the record. |
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. |