JDBC Driver for HubSpot

Build 26.0.9770

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 False

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 False

The amount billed on the invoice.

Amount billed in company currency Decimal True False

The amount billed on the invoice in the company currency.

Amount billed (preTax) Decimal True False

The amount billed on the invoice before tax.

Amount paid Decimal True False

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

Amount paid in company currency Decimal True False

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

Amount processing Decimal True False

The total value of processing payments associated to the invoice.

Line item names String True False

The line item names associated to this invoice.

Balance due Decimal True False

The balance due for the invoice.

Balance due in company currency Decimal True False

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 False

Comments to the invoice recipient.

Created by user ID Decimal True False

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

Create Date Datetime True False

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 False

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 False

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

Domain String False False

Domain of the hosted rendered invoice.

Due date Datetime False False

The due date for the current invoice.

Automated taxes on Bool False False

Whether or not automated tax is enabled for the invoice.

Exchange rate Decimal True False

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

External account id String True False

The 3rd party account Id associated with this invoice.

Invoice external create date/time Datetime False False

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

External id String True False

The 3rd party unique Id associated with this invoice.

External recipient String False False

The recipient of the current invoice.

Fees total Decimal True False

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 False

Whether or not the invoice is billable.

Invoice class String False False

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

Invoice date Datetime False False

Date of the invoice.

Latest company name String True False

The latest name value among companies associated to this invoice.

Latest contact email String True False

The latest email value among contacts associated to this invoice.

Latest contact first name String True False

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

Latest contact last name String True False

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

Invoice link String True False

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 False

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 False

The ID of the tool used to create the invoice.

Language String False False

Language of the invoice.

Last Edit Date Datetime True False

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

Last reminder sent date Datetime True False

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

Last sent date Datetime True False

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

Object last modified date/time Datetime True False

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 False

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 False

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

Number String False False

The 3rd party number associated to this invoice.

Number of Subscriptions Decimal True False

Number of subscriptions associated to the invoice.

Record ID Decimal True False

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

Record creation source String True False

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

Record source detail 1 String True False

First level of detail on how this record was created.

Record source detail 2 String True False

Second level of detail on how this record was created.

Record source detail 3 String True False

Third level of detail on how this record was created.

Record creation source ID String True False

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 False

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

Order level discounts total Decimal True False

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 False

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 False

The link to download the pdf of this invoice.

PO number String False False

Purchase order number of the invoice.

Read only object Bool True False

Determines whether a record can be edited by a user.

Received by recipient date (QuickBooks Online) Datetime False False

The date the invoice was received by the recipient.

Recipient company street address String False False

The address of the recipient's company or organization.

Recipient company street address 2 String False False

Additional address of the recipient's company or organization.

Recipient company city String False False

The city of the recipient's company or organization.

Recipient company country String False False

The country of the recipient's company or organization.

Recipient company country code String False False

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

Recipient company state/region String False False

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

Recipient company postal code String False False

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

Recipient shipping street address String False False

The shipping address of the recipient.

Recipient shipping street address 2 String False False

Additional shipping address of the recipient.

Recipient shipping city String False False

The shipping city of the recipient.

Recipient shipping country String False False

The shipping country of the recipient.

Recipient shipping country code String False False

The shipping country of the recipient.

Recipient shipping name String False False

The shipping name of the recipient.

Recipient shipping state/region String False False

The shipping state or region of the recipient.

Recipient shipping postal code String False False

The shipping postal or zip code of the recipient.

Sender company address String True False

The street address of the company sending this invoice.

Sender company address line 2 String True False

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

Sender company city String True False

The city of the company sending this invoice.

Sender company country String True False

The country of the company sending this invoice.

Sender company domain String True False

The domain of the company sending this invoice.

Sender company logo url String True False

The logo url of the company sending this invoice.

Sender company name String True False

The name of the company sending this invoice.

Sender company state String True False

The state of the company sending this invoice.

Sender company zip String True False

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 False

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 False

Allow customers to store their payment method at checkout.

Subtotal Decimal True False

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

Tax calculation ID String True False

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 False

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 False

The time zone of dates on the invoice.

Title String False False

Title of the invoice.

Unique creation key String True False

Unique property used for idempotent creates.

Unique id String True False

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 False

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 False

Object is part of an import.

Owner assigned date Datetime True False

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

Owner String False False

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) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770