JDBC Driver for FreshBooks

Build 22.0.8462

ProfitLossReport

The Profit/Loss Report shows all the information involving both your Profits and Losses.

Columns

Name Type Description
ProfitsAmount Decimal Amount of total profits.
ProfitsCode String Three-letter currency code.
IncomesAmount Decimal Amount of total incomes.
IncomesCode String Three-letter currency code.
ExpensesAmount Decimal Amount of total expenses.
ExpensesCode String Three-letter currency code.
FromDate Date The beginning date of the report.
ToDate Date The ending date of the report.

Pseudo-Columns

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