Tables
The adapter models the data in as a list of tables in a relational database that can be queried using standard SQL statements.
Adapter Tables
| Name | Description |
| CustomFieldItemFilters | Create, Update and Query the Custom Field Item Filters in . |
| CustomFieldItems | Create, Update and Query the Custom Field Items in . |
| CustomFields | Create, Update and Query the Custom Fields in . |
| EstimateItems | Create, Update and Query the Estimate Item in . |
| Estimates | Create, Update and Query the Estimates in . |
| 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 . |
| ProjectNotes | Create, Update and Query the Project Notes in . |
| Projects | Create, Update and Query the Projects in . |
| 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 . |
| TimeOffRequests | Create, Update and Query the Time off Requests in . |
| Timesheets | This table contains a list of file objects. |
| Users | Retrieves a list of all users associated with your company. |