JDBC Driver for QuickBooks Time

Build 24.0.9062

CurrentUser

Query the current user details in TSheets.

Table Specific Information

Select

Query the CurrentUser table. Here, the WHERE clause conditions are not supported on the API side, only a simple SELECT query works on the API side. The filters are executed client side within the 本製品.

For example, the following query is processed server side:

SELECT * FROM CurrentUser

Columns

Name Type Description
Id [KEY] Integer Id of the current user.
FirstName String First name
LastName String Last name
DisplayName String Display name
GroupId Integer Group Id.
Active Boolean Boolean value which show the active status.
EmployeeNumber Integer The employee number.
Salaried Boolean Salaried
Exempt Boolean Exempt
UserName String Username
Email String Email
EmailVerified String Email verified
PayrollId String Payroll id
HireDate String Hire date
TermDate String Term date
LastModified Datetime Last modified
LastActive Datetime Last active
Created Datetime Created
ClientUrl String Client URL
CompanyName String Company Name
ProfileImageUrl String Profile Image URL
MobileNumber String Mobile Number
PtoBalances String PTO Balances
SubmittedTo Datetime Submitted To
ApprovedTo Datetime Approved To
ManagerOfGroupIds String Manager of Group IDs
RequirePasswordChange Boolean Require Password Change
PayRate Integer Pay Rate
PayInterval String Pay Interval
PermissionsAdmin Boolean Permissions - Admin
PermissionsMobile Boolean Permissions - Mobile
PermissionsStatusBox Boolean Permissions - Status Box
PermissionsReports Boolean Permissions - Reports
PermissionsManageTimesheets Boolean Permissions - Manage Timesheets
PermissionsManageAuthorization Boolean Permissions - Manage Authorization
PermissionsManageUsers Boolean Permissions - Manage Users
PermissionsManageMyTimesheets Boolean Permissions - Manage My Timesheets
PermissionsManageJobcodes Boolean Permissions - Manage Jobcodes
PermissionsPinLogin Boolean Permissions - PIN Login
PermissionsApproveTimesheets Boolean Permissions - Approve Timesheets
PermissionsManageSchedules Boolean Permissions - Manage Schedules
PermissionsExternalAccess Boolean Permissions - External Access
PermissionsManageMySchedule Boolean Permissions - Manage My Schedule
PermissionsManageCompanySchedules Boolean Permissions - Manage Company Schedules
PermissionsViewCompanySchedules Boolean Permissions - View Company Schedules
PermissionsViewGroupSchedules Boolean Permissions - View Group Schedules
PermissionsManageNoSchedules Boolean Permissions - Manage No Schedules
PermissionsViewMySchedules Boolean Permissions - View My Schedules
PermissionsViewProjects Boolean Permissions - View Projects
PermissionsManageProjects Boolean Permissions - Manage Projects
PermissionsTimeTracking Boolean Permissions - Time Tracking

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062