Tables
The driver models the data in QuickBooks Time as a list of tables in a relational database that can be queried using standard SQL statements.
CData ODBC Driver for QuickBooks Time Tables
| Name | Description |
| CustomFieldItemFilters | Create, Update and Query the Custom Field Item Filters in TSheets. |
| CustomFieldItems | Create, Update and Query the Custom Field Items in TSheets. |
| CustomFields | Create, Update and Query the Custom Fields in TSheets. |
| EstimateItems | Create, Update and Query the Estimate Item in TSheets. |
| Estimates | Create, Update and Query the Estimates in TSheets. |
| Files | This table contains a list of file objects. |
| GeoLocations | Retrieves a list of all geofence configs. |
| Groups | This table contains a list of all groups associated with your company. |
| JobcodeAssignments | Returns a list of all jobcode assignments associated with users. |
| JobCodes | This table contains a list of jobcodes associated with your company |
| Locations | Retrieves a list of all locations associated with your company. |
| Notifications | Retrieves a list of notifications associated with your company. |
| ProjectActivityReplies | Create, Update and Query the Project Activity Replies in TSheets. |
| ProjectNotes | Create, Update and Query the Project Notes in TSheets. |
| Projects | Create, Update and Query the Projects in TSheets. |
| Reminders | Retrieves a list of reminders associated with your employees or company. |
| ScheduleEvents | Retrieves a list of schedule events associated with your employees or company. |
| TimeOffRequestEntries | Create, Update and Query the Time off Request Entries in TSheets. |
| TimeOffRequests | Create, Update and Query the Time off Requests in TSheets. |
| Timesheets | This table contains a list of file objects. |
| Users | Retrieves a list of all users associated with your company. |