FireDAC Components for TSheets

Build 20.0.7654

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.

CData FireDAC Components for TSheets Views

Name Description
CurrentTotalsReport Report for the current totals (shift and day) along with additional information provided for those who are currently on the clock.
Files This table contains a list of file objects.
GeneralSettings Retrieves a list of all effective settings associated with a single user.
GeofenceConfigs Retrieves a list of all geofence configs.
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
LastModifiedTimestamps Retrieves a list of last_modified timestamps associated with each requested API endpoint.
LocationMaps Retrieves a list of all locations maps associated with your company.
Locations Retrieves a list of all locations associated with your company.
ManagedClients Retrieves a list of managed clients available from your account.
Notifications Retrieves a list of notifications associated with your company.
PayrollReport Payroll Report associated with a timeframe.
PayrollReportByJobCode Payroll Report broken down by jobcode
ProjectReport Retrieves a project report.
Reminders Retrieves a list of reminders associated with your employees or company.
ScheduleCalendars Retrieves a list of schedule calendars associated with your employees or company.
ScheduleEvents Retrieves a list of schedule events associated with your employees or company.
Timesheets This table contains a list of file objects.
UserPermissions The rights assignable to an individual user.
Users Retrieves a list of all users associated with your company.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654