InvoiceDetailsGroupByDateCData Excel Add-In for FreshBooks 2019 - Build 19.0.7354
Returns information about all, or a filtered set of invoices, as grouped by each month.
|Billed||Decimal||Billed amount, two decimal places.|
|Collected||Decimal||Collected amount so far, two decimal places.|
|Outstanding||Decimal||Outstanding amount (remaining), two decimal places.|
|CurrencyCode||String||Three-letter currency code.|
|Year||String||Year which the invoice was sent.|
|Month||String||Month which the invoice was sent.|
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.
|ClientId||String||Identifier for the client.|
|Status||String||Status of invoice.|
|DateFrom||Datetime||Starting date filter.|
|DateTo||Datetime||Ending date filter.|