ADO.NET Provider for FreshBooks

Build 20.0.7587

ExpenseDetailsGroupByDate

Returns information about all, or a filtered set of expenses, as grouped by a specific month.

Columns

Name Type Description
Unbilled Decimal Unbilled expense, two decimal places.
Invoiced Decimal Invoiced expense, two decimal places.
Recouped Decimal Recouped expense, two decimal places.
Internal Decimal Internal expense, two decimal places.
Year String Year when the expense occurred.
Month String Month when the expense occurred.

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
ClientId String Identifier for the client
DateFrom Datetime Starting date filter.
DateTo Datetime Ending date filter.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587