API Data Provider - Online Help

Expenses

Expense tracking for workspace projects.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Expense ID

WorkspaceId String False

Workspaces.Id

Workspace ID

UserId String False

WorkspaceUsers.Id

User ID

Date Datetime False

Expense date

ProjectId String False

Projects.Id

Project ID

ProjectName String True

Project name

ProjectColor String True

Project color

TaskId String False

Tasks.Id

Task ID

CategoryId String False

Expense category ID

CategoryName String True

Expense category name

Notes String False

Expense notes

Quantity Decimal False

Expense quantity

Billable Boolean False

Whether expense is billable

FileId String True

Attached file ID

FileName String True

Attached file name

Total Decimal False

Total expense amount

Locked Boolean True

Whether expense is locked

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770.0