ADO.NET Provider for FreshBooks

Build 20.0.7587

Expenses

A list of expenses for the FreshBooks account. Staff can only access expenses that belong to them or are associated with clients they are assigned to.

Table Specific Information

Select

The Classic API allows only a subset of columns to be used as filter criteria in the WHERE clause. The following columns can be used:

  • ExpenseId
  • ClientId
  • Date
  • Folder

Note: ExpenseId cannot be used at the same time as the other columns.

Other filters are processed client side by the provider. See SupportEnhancedSQL for more information.

Insert

To insert, the following fields are required:

  • StaffId
  • CategoryId
  • Amount

Columns

Name Type ReadOnly Description
ExpenseId [KEY] String True

The unique identifier for an expense.

StaffId String False

The Id of the staff member associated with an expense.

CategoryId String False

The Id of the category associated with an expense.

ProjectId String False

The Id of the project associated with an expense.

ClientId String False

The Id of the client associated with an expense.

Amount Decimal False

The cost amount associated with an expense.

Date Datetime False

The date of an expense.

Notes String False

A custom note for an expense.

Vendor String True

The vendor associated with an expense.

Status String False

The status associated with an expense.

Folder String True

The folder associated with an expense.

Tax1Name String False

The primary tax name associated with an expense.

Tax1Percent Decimal False

The primary tax percent associated with an expense.

Tax1Amount Decimal False

The primary tax amount associated with an expense.

Tax2Name String False

The secondary tax name associated with an expense.

Tax2Percent Decimal False

The secondary tax percent associated with an expense.

Tax2Amount Decimal False

The secondary tax amount associated with an expense.

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