Data Dictionary
Field | Type | Notes |
Archived | Boolean | Derived from text_to_boolean Archived |
Connection Name | Text | The name of the Connection. Typically the name of the HubSpot Organisation., Derived from clean_name Connection Name |
Created | Datetime | Derived from text_to_timestamptz Properties.createdate |
Data current as of | Datetime | Gives the date and time that this record was taken from HubSpot. |
Deal ID | Integer | HubSpot's unique ID for the Deal., Derived from text_to_bigint Deal ID |
Deal Name | Text | API: properties.dealname |
Internal URL | Text | The URL to the Deal record - only available to those that have access to HubSpot., Derived from create_deeplink 'deal' and Deal ID |
Lineitem Amount | Number | Amount, Derived from text_to_numeric properties.None |
Lineitem Currency | Text | The 3 letter ISO currency code for the Currency of the Lineitem., API: Properties.hs_line_item_currency_code |
Lineitem ID | Integer | ID, Derived from text_to_bigint Lineitem ID |
Lineitem Price | Number | Derived from text_to_numeric Properties.price |
Lineitem Quantity | Number | Quantity, Derived from text_to_numeric Properties.quantity |
Product ID | Integer | Derived from text_to_bigint Properties.hs_product_id |
Reporting Currency | Text | None |
Updated | Datetime | Derived from text_to_timestamptz properties.None |
