JDBC Driver for FreshBooks

Build 22.0.8462


The Payments Collected Report shows details regarding collected payments made to your business.


Name Type Description
InvoiceId String The unique id of the invoice.
ClientId String The unique id of the client.
Amount Decimal Amount paid on invoice to two decimal places.
Code String Three-letter currency code.
Client String The name of the business client belongs to.
Description String The description of the payment.
Date Date The date of the payment.
InvoiceNumber String A custom id for the invoice.
Method String Method of payment.


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