GeneralSettings
Retrieves a list of all effective settings associated with a single user.
Table Specific Information
Select
Query the GeneralSettings table. The provider will use 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 provider.
- LastModified field supports the <=,<,>=,>,= operators.
- UserId field supports the = operators.
For example, the following queries are processed server side:
SELECT * FROM GeneralSettings WHERE LastModified = '2021-12-17 05:08:02.0' SELECT * FROM GeneralSettings WHERE UserId = '12345'
Columns
| Name | Type | Description |
| CalculateOvertime | Boolean | The CalculateOvertime setting. |
| ClockoutOverride | Boolean | The ClockoutOverride setting. |
| ClockoutOverrideHours | Integer | The ClockoutOverrideHours setting. |
| ClockoutOverrideNotifyAdmin | Boolean | The ClockoutOverrideNotifyAdmin setting. |
| ClockoutOverrideNotifyManager | Boolean | The ClockoutOverrideNotifyManager setting. |
| DailyDoubletime | Integer | The DailyDoubletime setting. |
| DailyOvertime | Integer | The DailyOvertime setting. |
| DailyRegularHours | Integer | The DailyRegularHours setting. |
| DateLocale | String | The DateLocale setting. |
| EmpPanel | Boolean | The EmpPanel setting. |
| EmpPanelMail | String | The EmpPanelMail setting. |
| EmpPanelPassword | String | The EmpPanelPassword setting. |
| EmployeePtoEntry | Boolean | The EmployeePtoEntry setting. |
| EnableTimesheetNotes | String | The EnableTimesheetNotes setting. |
| HideWorkingTime | String | The HideWorkingTime setting. |
| JcLabel | String | The JcLabel setting. |
| LunchDeduct | Boolean | The LunchDeduct setting. |
| LunchLength | Boolean | The LunchLength setting. |
| LunchThreshold | Integer | The LunchThreshold setting. |
| MaxCustomFieldItems | Integer | The MaxCustomFieldItems setting. |
| MaxJobCodes | Integer | The MaxJobCodes setting. |
| ParentClockinDisplay | Integer | The ParentClockinDisplay setting. |
| PayrollEndDate | Date | The PayrollEndDate setting. |
| PayrollFirstEndDay | String | The PayrollFirstEndDay setting. |
| PayrollLastEndDay | String | The PayrollLastEndDay setting. |
| PayrollMonthEndDay | String | The PayrollMonthEndDay setting. |
| PayrollType | String | The PayrollType setting. |
| PtoEntry | Boolean | The PtoEntry setting. |
| PtoOvertime | Boolean | The PtoOvertime setting. |
| SimpleClockin | Boolean | The SimpleClockin setting. |
| TimeFormat | Integer | The TimeFormat setting. |
| TimecardFields | String | The TimecardFields setting. |
| TimeclockLabel | String | The TimeclockLabel setting. |
| TimesheetEditNotesForAllUsers | Boolean | The TimesheetEditNotesForAllUsers setting. |
| TimesheetNotesNotifyAdmin | Boolean | The TimesheetNotesNotifyAdmin setting. |
| TimesheetNotesNotifyManagers | Boolean | The TimesheetNotesNotifyManagers setting. |
| TimesheetNotesRequired | Boolean | The TimesheetNotesRequired setting. |
| Timezone | String | The Timezone setting. |
| WeekStart | String | The WeekStart setting. |
| WeeklyRegularHours | String | The WeeklyRegularHours setting. |
| LastModified | Datetime | When the record was last modified. |
| EmpPanelTz | String | The EmpPanelTz setting. |
| AccountType | String | The type of account for this company. |
| AdminCrewThreshold | Integer | The minimum number of employees that must be clocked in at a location before an admin is alerted. |
| AuthManageMyTimesheets | Integer | The authorization level required for employees to manage their own timesheets. |
| BillType | String | The billing type for the account. |
| Processor | String | The payment processor used for billing the account. |
| CustomfieldItemNameMaxLength | Integer | The maximum number of characters allowed for a custom field item name. |
| JobcodeNameMaxLength | Integer | The maximum number of characters allowed for a jobcode name. |
| TimesheetNotesMaxLength | Integer | The maximum number of characters allowed for timesheet notes. |
| SplitAtEod | Integer | The Split at EOD value. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| UserId | Integer | User id for whom you'd like to retrieve effective settings. If none is specified, the currently logged in user's id will be used. Only effective settings that apply to this user_id will be returned. |