JDBC Driver for FreshBooks

Build 22.0.8462

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 Description
Id [KEY] String Unique identifier of the project.
Title String Title of the project.
ClientId String Unique identifier of the client.
GroupId String Unique id of group membership.
FixedPrice Decimal Used for flat-rate projects. Represents the amount being charged to the client for the project.
UpdatedAt Datetime The time the project was last updated.
Sample Boolean True if project is sample.
Active Boolean Whether the project is active or not.
Rate String The hourly rate of the project. Only applies to hourly_rate projects.
ProjectType String Type of project: fixed_price, hourly_rate.
Description String Description of project.
LoggedDuration Integer The time logged for the project in seconds.
Internal Boolean Clarifies that the project is internally within the company (client is the company).
DueDate Date Date of projected completion.
Complete Boolean Whether the project is completed or not.
BilledAmount Decimal The amount billed for the project.
BilledStatus String Shows the billed status.
BillingMethod String The method of payment for the project.
CreatedAt Datetime The date/time the project was created.
Budget Integer Budget for project.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462