JDBC Driver for QuickBooks POS

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462