FreshBooks Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
FreshBooks Tables
| Name | Description |
| Accounts | FreshBooks chart of accounts and ledger structure |
| BillPayments | FreshBooks vendor bill payment records |
| Bills | FreshBooks vendor bill records |
| BillVendors | FreshBooks bill vendor relationships and associations |
| Clients | FreshBooks client records and contact information |
| CreditNotes | FreshBooks credit note records |
| CurrentUser | Current authenticated user information |
| Estimates | FreshBooks estimate records and quotations |
| ExpenseCategories | FreshBooks expense category definitions for expense classification |
| Expenses | FreshBooks expense records and business costs |
| Gateways | FreshBooks payment gateway configurations |
| InvoiceProfiles | FreshBooks invoice profile templates and settings |
| Invoices | FreshBooks invoice records with comprehensive details and status tracking |
| Items | FreshBooks item catalog for products and services |
| JournalEntries | FreshBooks journal entry records for accounting adjustments |
| ManualJournalEntries | FreshBooks manual journal entry records for accounting adjustments |
| OtherIncome | FreshBooks other income records and non-invoice revenue |
| PaymentOptions | FreshBooks payment option configurations and methods |
| Payments | FreshBooks payment records and transaction details |
| Projects | FreshBooks project management and tracking |
| ServiceRates | FreshBooks service hourly rates for billing |
| Services | FreshBooks service definitions and rates |
| Systems | FreshBooks system information and configuration |
| Tasks | FreshBooks task definitions for project time tracking |
| Taxes | FreshBooks tax definitions and rates |
| TeamMembers | FreshBooks team member directory and permissions |
| TimeEntries | Time tracking entries for projects and tasks |