ScheduleCalendars
Retrieves a list of schedule calendars associated with your employees or company.
Table Specific Information
Select
The add-in uses the QuickBooks Time API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the add-in.- Id field supports the =, IN operators.
- LastModified field supports the <=, <, >=, >, = operators.
For example, the following queries are processed server-side:
SELECT * FROM ScheduleCalendars WHERE Id IN (72595, 72597) SELECT * FROM ScheduleCalendars WHERE LastModified < '2019-01-01 18:30'
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id of the schedule calendar. |
| Name | String | The name of the schedule calendar. |
| Created | Datetime | Date/time when this schedule calendar was created |
| LastModified | Datetime | Date/time when this schedule calendar was last modified. |