Departments
Create, update, delete, and query QuickBooks POS Departments.
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 Departments WHERE DepartmentName LIKE '%WEAR%'
Insert
To create a new department record, the DepartmentName field is required.
INSERT INTO Departments (DepartmentName, DepartmentCode, DefaultMarginPercent)
VALUES ('Sports Wear', 'SPW', '7.25')
Update
Any field that is not read-only can be updated.
UPDATE Departments SET DefaultMarkupPercent='20.50' WHERE ListId='-1234567890123456789'
Columns
| Name | Type | ReadOnly | Filter Type | Description |
| ListID [KEY] | String | True | Single |
The unique identifier, generated by QuickBooks POS. |
| DepartmentName | String | False | Range |
The name of the department. |
| DepartmentCode | String | False | Range |
A unique, 1-3 character code identifying the department. The department code can be used when defining an item in inventory. The first character usually indicates the broadest classification. |
| DefaultMarginPercent | Double | False | Range |
The default margin percentage. If you do not wish QBPOS to calculate prices for new items as they are added to inventory, leave this field and the DefaultMarkupPercent field at 0. |
| DefaultMarkupPercent | Double | False |
The default markup percentage. | |
| StoreExchangeStatus | String | True | Single |
In multistore configurations, if the customer information has changed, this information is updated at the headquarters store. This response field indicates whether changes to the customer information were successfully updated or not. Possible values are Modified, Sent, and Acknowledged. |
| TaxCode | String | False | Single |
The tax code of the department. |
| 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 department was created. |
| TimeModified | Datetime | True | Range |
When the department was last modified. |