TimeEntries
Create, update, and query QuickBooks POS employee time entries.
Table Specific Information
Select
QuickBooks POS allows many of the columns to be used in the WHERE clause of a SELECT query. These columns can create either Single or Range filters, as defined in the table schema.
| Single Filters | Single filters make direct comparisons by using the = comparison. |
| Range Filters | Range filters can search only ranges that have an inclusive lower bound, specified by the >= operator, and an exclusive upper bound, specified by the < operator.
To apply a single bound to a string column that has the Range filter type, the = or LIKE operators are available. To apply a single bound to a numeric or datetime column that has the Range filter type, the >, >=, <, <=, or = operators are available. |
SELECT * FROM TimeEntries WHERE FirstName LIKE '%George%'
Insert
To create a new time entry record, there are no required fields; however, EmployeeListId should be specified to identify who the employee is.
INSERT INTO TimeEntries (EmployeeListId, ClockInTime)
VALUES ('-9876543210987654321', '2014-08-04T13:15:20-04:00')
Update
Any field that is not read-only can be updated.
UPDATE TimeEntries SET ClockOutTime='2014-08-04T19:15:20-04:00' WHERE ListId='-1234567890123456789'
Columns
| Name | Type | ReadOnly | Filter Type | Description |
| ListID [KEY] | String | True | Single |
The unique identifier, generated by QuickBooks POS. |
| EmployeeListID | String | False | Single |
A reference to the employee. |
| EmployeeLoginName | String | True | Range |
The name used by the employee to log into the QBPOS company. |
| FirstName | String | True | Range |
The first name of the employee. |
| LastName | String | True | Range |
The last name of the employee. |
| ClockInTime | Datetime | False | Range |
The date and time when the employee clocked in. |
| ClockOutTime | Datetime | False | Range |
The date and time when the employee clocked out. |
| CreatedBy | String | False | Range |
The person who created this time entry. |
| QuickBooksFlag | Boolean | False | Single |
The status of data export for a memo. This element is used only if QBPOS is being used with QuickBooks Financial Software. Possible values are NOT POSTED (the memo has not yet been sent to QuickBooks), COMPLETE (the memo has been sent to QuickBooks), and ERROR (attempting to send the memo to QuickBooks resulted in an error). No default value. |
| CustomFieldsOwnerID | String | False | Multi |
Identifies the owner of the CustomFields to be returned in the response. The default value of '0' is sent which refers to a public custom field that is exposed in the QuickBooks POS UI. All other values are GUID's that are created by the owner and are private custom fields (not exposed via the QuickBooks POS UI). |
| CustomFields | String | False |
Custom fields returned from QuickBooks POS and formatted into XML. | |
| TimeCreated | Datetime | True | Range |
When the employee was created. |
| TimeModified | Datetime | True | Range |
When the employee was last modified. |