JDBC Driver for FreshBooks

Build 23.0.8839

Projects

Projects in FreshBooks are used to track business projects and related information such as hourly rate, service(s) being offered, projected end date...etc.

Columns

Name Type ReadOnly Description
Id [KEY] String True

Unique identifier of the project.

Title String False

Title of the project.

ClientId String False

Unique identifier of the client.

GroupId String True

Unique id of group membership.

FixedPrice Decimal False

Used for flat-rate projects. Represents the amount being charged to the client for the project.

UpdatedAt Datetime True

The time the project was last updated.

Sample Boolean True

True if project is sample.

Active Boolean True

Whether the project is active or not.

Rate String True

The hourly rate of the project. Only applies to hourly_rate projects.

ProjectType String False

Type of project: fixed_price, hourly_rate.

Description String True

Description of project.

LoggedDuration Integer True

The time logged for the project in seconds.

Internal Boolean True

Clarifies that the project is internally within the company (client is the company).

DueDate Date True

Date of projected completion.

Complete Boolean True

Whether the project is completed or not.

BilledAmount Decimal True

The amount billed for the project.

BilledStatus String True

Shows the billed status.

BillingMethod String True

The method of payment for the project.

CreatedAt Datetime True

The date/time the project was created.

Budget Integer True

Budget for project.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839