MuleSoft Connector for FreshBooks

Build 20.0.7587

ExpensesReport

The Expenses Report shows all the information involving your Expenses.

Columns

Name Type Description
ExpenseId [KEY] String Unique id for the expense.
GroupId String Unique id for the group.
Amount Decimal The amount of money that is owed or been paid.
Code String The currency that the amount is in.
VendorId String The unique id for the vendor.
Vendor String The name of the vendor.
Notes String Custom notes about the expense.
ClientId String Unique id for the client.
AuthorId String Id for the author.
CreatedDate Date The date the expense took place.
TaxName1 String The name of the first tax.
TaxPercent1 Decimal The percentage you are being taxed on.
TaxAmount1 Decimal The amount of the first tax.
TaxCode1 String The currency of the first tax.
TaxName2 String The name of the second tax.
TaxPercent2 Decimal The percentage you are being taxed on.
TaxAmount2 Decimal The amount of the second tax.
TaxCode2 String The currency of the second tax.
CategoryId String The identifier of the category.
CompanyName String Name of the company that the expenses are charged too.

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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587