Tableau Connector for HubSpot

Build 25.0.9434

Invoices

Retrieve the available Invoices in HubSpot.

Columns

Name Type ReadOnly References Filterable Description
Id [KEY] Long True True

Unique identifier of the object.

Archived Bool True False

Whether the object is archived or not.

CreatedAt Datetime True False

When the object was created.

UpdatedAt Datetime True False

When the object was last updated.

All teams String True False

The team IDs, including the team hierarchy, of all default and custom owner properties for this record.

Business units String False False

The business units this record is assigned to.

All owner IDs String True False

Values of all default and custom owner properties for this record.

All team IDs String True False

The team IDs of all default and custom owner properties for this record.

Allow partial payments Bool False True

Allow your customer to pay less than the balance due

Allowed payment methods String False False

The payment methods that can be used to pay the invoice.

Amount billed Decimal False True

The amount billed on the invoice.

Amount billed in company currency Decimal True True

The amount billed on the invoice in the company currency.

Amount billed (preTax) Decimal True True

The amount billed on the invoice before tax.

Amount paid Decimal True True

The total value of non-failed payments associated to the invoice.

Amount paid in company currency Decimal True True

The total value of non-failed payments associated to the invoice in the company currency.

Amount processing Decimal True True

The total value of processing payments associated to the invoice.

Line item names String True True

The line item names associated to this invoice.

Balance due Decimal True True

The balance due for the invoice.

Balance due in company currency Decimal True True

The balance due for the invoice in the company currency.

Billing frequency type String True False

Indicates whether or not the invoice is part of a recurring series (a subscription).

Address types to collect String False False

The types of addresses that are collected while paying the invoice.

Comments String False True

Comments to the invoice recipient.

Created by user ID Decimal True True

The user who created this record. This value is set automatically by HubSpot.

Create Date Datetime True True

The date and time at which this object was created. This value is automatically set by HubSpot and may not be modified.

Currency String False True

The currency of the invoice.

Custom Invoice Fields String False False

The custom fields that have been added to the invoice.

Days paid late String True False

How many days the invoice was paid after the due date

Discounts total Decimal True True

The sum of all line item level discounts and invoice level discounts applied to the invoice.

Domain String False True

Domain of the hosted rendered invoice.

Due date Datetime False True

The due date for the current invoice.

Automated taxes on Bool False True

Whether or not automated tax is enabled for the invoice.

Exchange rate Decimal True True

This is the exchange rate used to convert the invoice amount into your company currency.

External account id String True True

The 3rd party account Id associated with this invoice.

Invoice external create date/time Datetime False True

The date and time at which the invoice was created in the 3rd party accounting application

External id String True True

The 3rd party unique Id associated with this invoice.

External recipient String False True

The recipient of the current invoice.

Fees total Decimal True True

The sum of all fees applied to the invoice.

Age category String True False

How many days an invoice has been outstanding

Invoice billable Bool False True

Whether or not the invoice is billable

Invoice class String False True

Classification of an invoice, typically synced from third party accounting integrations.

Invoice date Datetime False True

Date of the invoice.

Latest company name String True True

The latest name value among companies associated to this invoice.

Latest contact email String True True

The latest email value among contacts associated to this invoice.

Latest contact first name String True True

The latest first name value among contacts associated to this invoice.

Latest contact last name String True True

The latest last name value among contacts associated to this invoice.

Invoice link String True True

The invoice url link, based on the domain and slug.

Invoice payment collection method String False False

The method used to collect payment for the invoice.

Preset ID Decimal False True

The id of the preset set for this invoice.

Invoice source String True False

Creation source of the invoice.

Invoice status String False False

The status of the invoice. Invoice statuses allow you to categorize and track billing progress.

Invoice status details String True False

Additional invoice status details.

Invoice Tool Source String True False

The tool that was used to create the invoice.

Invoice Tool Source ID String True True

The ID of the tool used to create the invoice.

Language String False True

Language of the invoice.

Last Edit Date Datetime True True

The last time a finalized invoice was edited. This is automatically updated by HubSpot.

Last reminder sent date Datetime True True

The last time an email reminder was sent to the customer. This is automatically updated by HubSpot.

Last sent date Datetime True True

The last time the invoice was sent to the customer. This is updated automatically by HubSpot.

Object last modified date/time Datetime True True

Most recent timestamp of any property update for this object. This includes HubSpot internal properties, which can be visible or hidden. This property is updated automatically.

Locale String False True

Locale of the invoice.

Merged record IDs String True False

The list of record IDs that have been merged into this record. This value is set automatically by HubSpot.

net payment term Decimal False True

Refers to the period, expressed in days (such as Net 30), within which invoice must be paid.

Number String False True

The 3rd party number associated to this invoice.

Number of Subscriptions Decimal True True

Number of subscriptions associated to the invoice.

Record ID Decimal True True

The unique ID for this record. This value is set automatically by HubSpot.

Record creation source String True True

Raw internal PropertySource present in the RequestMeta when this record was created.

Record source detail 1 String True True

First level of detail on how this record was created.

Record source detail 2 String True True

Second level of detail on how this record was created.

Record source detail 3 String True True

Third level of detail on how this record was created.

Record creation source ID String True True

Raw internal sourceId present in the RequestMeta when this record was created.

Record source String True False

How this record was created.

Record creation source user ID Decimal True True

Raw internal userId present in the RequestMeta when this record was created.

Order level discounts total Decimal True True

The sum of only invoice level discounts applied to the invoice.

Owning Teams String False False

The teams that are attributed to this record.

Payment date Datetime False True

The date when payment of an invoice has fully completed.

Payment status String True False

The state of payment on an invoice.

PDF download link String True True

The link to download the pdf of this invoice.

PO number String False True

Purchase order number of the invoice.

Read only object Bool True True

Determines whether a record can be edited by a user.

Received by recipient date (QuickBooks Online) Datetime False True

The date the invoice was received by the recipient.

Recipient company street address String False True

The address of the recipient's company or organization.

Recipient company street address 2 String False True

Additional address of the recipient's company or organization.

Recipient company city String False True

The city of the recipient's company or organization.

Recipient company country String False True

The country of the recipient's company or organization.

Recipient company country code String False True

The country code of the recipient's company or organization.

Recipient company state/region String False True

The state or region of the recipient's company or organization.

Recipient company postal code String False True

The postal or zip code of the recipient's company or organization.

Recipient shipping street address String False True

The shipping address of the recipient.

Recipient shipping street address 2 String False True

Additional shipping address of the recipient.

Recipient shipping city String False True

The shipping city of the recipient.

Recipient shipping country String False True

The shipping country of the recipient.

Recipient shipping country code String False True

The shipping country of the recipient.

Recipient shipping name String False True

The shipping name of the recipient.

Recipient shipping state/region String False True

The shipping state or region of the recipient.

Recipient shipping postal code String False True

The shipping postal or zip code of the recipient.

Sender company address String True True

The street address of the company sending this invoice.

Sender company address line 2 String True True

The second line of the street address of the company sending this invoice.

Sender company city String True True

The city of the company sending this invoice.

Sender company country String True True

The country of the company sending this invoice.

Sender company domain String True True

The domain of the company sending this invoice.

Sender company logo url String True True

The logo url of the company sending this invoice.

Sender company name String True True

The name of the company sending this invoice.

Sender company state String True True

The state of the company sending this invoice.

Sender company zip String True True

The zip code of the company sending this invoice.

Shared teams String True False

Additional teams whose users can access the record based on their permissions. This can be set manually or through Workflows or APIs.

Shared users String True False

Additional users that can access the record based on their permissions. This can be set manually or through Workflows and APIs.

Slug String False True

Slug of the hosted rendered invoice.

External Invoice Status String True False

The external status of the current invoice. This value is retrieved from a third party and may not be modified

Store payment method at checkout Bool False True

Allow customers to store their payment method at checkout.

Subtotal Decimal True True

The sum of all line items of the invoice including line item level taxes.

Tax calculation ID String True True

The id reference to the tax calculation data for the invoice.

Tax ID String False False

The account tax ID listed on this invoice. The tax ID includes a tax ID type and a tax ID number.

Taxes total Decimal True True

The sum of all taxes applied to the invoice.

Test mode String False False

Indicates if the invoice is in test mode

Time zone String False True

The time zone of dates on the invoice.

Title String False True

The title of the invoice.

Unique creation key String True True

Unique property used for idempotent creates

Unique id String True True

The unique identifier of the invoice. This value is automatically set by HubSpot and may not be modified.

Upcoming reminder dates String True False

The upcoming dates in which email reminders will be sent to the customer. This is updated automatically by HubSpot.

Updated by user ID Decimal True True

The user who last updated this record. This value is set automatically by HubSpot.

User IDs of all notification followers String True False

The user IDs of all users that have clicked follow within the object to opt-in to getting follow notifications

User IDs of all notification unfollowers String True False

The user IDs of all object owners that have clicked unfollow within the object to opt-out of getting follow notifications

User IDs of all owners String True False

The user IDs of all owners of this record.

Performed in an import Bool True True

The object is part of an import.

Owner assigned date Datetime True True

The most recent timestamp of when an owner was assigned to this record. This value is set automatically by HubSpot.

Owner String False True

The owner of the object.

Owner's main team String True False

The main team of the record owner. This value is set automatically by HubSpot.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434