Skip to main content

Deal Lines

Written by Nick Maxwell

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

Did this answer your question?