LocationMaps
Retrieves a list of all locations maps associated with your company.
Table Specific Information
Select
Query the LocationMaps table. The add-in 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 add-in.
- Id field supports the '=' and IN operators.
- ByJobcodeAssignment field supports the '=' operator.
- LastModified field supports the <=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM LocationMaps WHERE Id IN ('102839', '110761')
SELECT * FROM LocationMaps WHERE ByJobcodeAssignment = true
Columns
| Name | Type | Description |
| Id [KEY] | String | Id of location map. |
| XTable | String | The name of the entity the location is mapped to. |
| XId | Integer | The id of the entity the location is mapped to. |
| LocationId | Integer | The id of the location that is mapped to the entity. |
| Created | Datetime | Date/time when this locations map was created |
| LastModified | Datetime | Date/time when this locations map was last modified. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| ByJobcodeAssignment | Boolean | If specified only locations maps mapped to a jobcode the user is assigned to will be returned. |