JDBC Driver for FreshBooks

Build 22.0.8462


The Invoice Details Report shows all the information involving your invoices.


Name Type Description
CreatedDate Date The date the invoice was created.
InvoiceId [KEY] String The unique id of the invoice.
DueOffsetDays Int Number of days from creation that the invoice is due.
Amount Decimal The amount of money that is owed or been paid.
Code String The currency that the amount is in.
PostOfficeNumber Int Post office box number for address on invoice.
TaxAmount Decimal Amount of tax.
TaxCode String Three-letter currency code.
PaidAmount Decimal Amount paid.
PaidCode String Three-letter currency code.
DatePaid Date The date the invoice was paid.
DiscountAmount Decimal The amount discount.
DiscountCode String Three-letter currency code.
InvoiceNumber String User-specified and visible invoice id.
currency_code String Three-letter currency code for invoice.
UserId String The unique id of the client.
FirstName String First name of the user.
LastName String The last name of the user.
Email String The email of the user.
Organization String Name of the organization the user is a part of.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
StartDate String The starting date for the expense report query.
EndDate String Will only return invoices that were created before the given date.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462