JDBC Driver for QuickBooks Online

Build 25.0.9434

Items

Maintains the catalog of products and services that are offered by the business, including inventory and non-inventory items, used for sales, purchases, and expense tracking across QuickBooks Online.

Columns

Name Type ReadOnly References Filterable Sortable Description
Id [KEY] String True True True

The unique identifier (Id) of the item. This value distinguishes the item record from all other items in QuickBooks Online.

SyncToken String True False False

The version number of the item record. It is used to lock the item for use by one app at a time. When an application modifies an item, its sync token is incremented. Attempts to modify an item specifying an older sync token fail. Only the latest version of the item is maintained by QuickBooks Online.

MetaData_CreateTime Datetime True True True

The date and time when the item record was created.

MetaData_LastUpdatedTime Datetime True True True

The date and time when the item record was last updated.

Name String False True True

The name of the item as it appears in QuickBooks Online forms and reports.

FullyQualifiedName String False False False

The fully qualified name of the item. The fully qualified name consists of the topmost parent element followed by each subelement and separated by colons. For example, Parent:Account1:SubAccount1:SubAccount2.

Description String False False False

A detailed description for the item that explains the service or product offered. This value appears on invoices, sales receipts, or purchase forms that include the item.

Active Boolean False True False

This field indicates whether the item is currently active. Inactive items that are set to false may be hidden from display and are not used in new financial transactions.

ParentRef String False

Items.Id

False False

The Id of the parent entity of the item that is referenced when the item is a subitem. If SubItem is true, then ParentRef is required.

ParentRef_Name String True

Items.Name

False False

The name of the parent entity of the item that is referenced when the item is a subitem. If SubItem is true, then ParentRef is required.

PrefVendorRef String False

Vendors.Id

False False

The Id of the preferred vendor entity that is linked to the item for purchase purposes.

PrefVendorRef_Name String False

Vendors.Name

False False

The name of the preferred vendor entity that is linked to the item for purchase purposes.

SubItem Boolean False False False

This field indicates whether the item is a subitem. A value of false or null indicates the item is a top-level item.

UnitPrice Decimal False False False

The monetary value of the service or product that is expressed in the home currency. This value is used when the item is added to a sales form.

Type String False True True

The classification that specifies how the item is used (for example, Inventory, Service, Non-inventory, or Other Charge).

The allowed values are Inventory, NonInventory, Service, Category, Group.

Taxable Boolean False False False

This field indicates whether the item is subject to tax when it is sold.

AssetAccountRef String False

Accounts.Id

False False

The Id of the inventory asset account that is assigned to this item. If the same inventory asset account is assigned for multiple items, the current balance of that account shows the combined total value of the inventory.

AssetAccountRef_Name String True

Accounts.Name

False False

The name of the inventory asset account that is assigned to this item. If the same inventory asset account is assigned for multiple items, the current balance of that account shows the combined total value of the inventory.

IncomeAccountRef String False

Accounts.Id

False False

The Id of the income account that records the proceeds from the sale of this item.

IncomeAccountRef_Name String True

Accounts.Name

False False

The name of the income account that records the proceeds from the sale of this item.

PurchaseDesc String False False False

The purchase description for the item that appears on bills and purchase orders.

PurchaseCost Decimal False False False

The amount paid when buying or ordering the item that is expressed in the home currency.

ExpenseAccountRef String False

Accounts.Id

False False

The Id of the expense account that is associated with the purchase of the item.

ExpenseAccountRef_Name String True

Accounts.Name

False False

The name of the expense account that is associated with the purchase of the item.

QtyOnHand Double False False False

The current quantity of the inventory item that is available for sale.

ReorderPoint Double False False False

The minimum quantity of the item that should be kept on hand before reordering.

InvStartDate Date False False False

The date to start tracking inventory for the item. This value is required if the TrackQtyOnHand attribute is set to true.

SalesTaxCodeRef String False

TaxCodes.Id

False False

The sales tax code that is applied when selling this item.

PurchaseTaxCodeRef String False

TaxCodes.Id

False False

The purchase tax code that is applied when purchasing this item.

TrackQtyOnHand Boolean False False False

Specifies whether the system tracks the quantity on hand for this item. This setting determines if inventory levels are monitored and updated automatically when transactions occur.

Level Integer True False False

Indicates the hierarchical level of the item within a parent-child structure. This value is 0 for top-level items. Any other value specifies the depth of the item from its top parent in the hierarchy.

Sku String False True False

Specifies the stock keeping unit (SKU) for this item. This value is a company-defined identifier that is used to track and manage inventory.

SalesTaxIncluded Boolean False False False

Indicates whether sales tax is included in the item amount. When this flag is set to true, the system does not calculate additional tax for transactions involving this item.

PurchaseTaxIncluded Boolean False False False

Indicates whether purchase tax is included in the item amount. When this flag is set to true, the system does not calculate additional tax on purchases involving this item.

ItemGroupDetail_ItemGroupLineAggregate String True False False

Contains one or more Item objects that are grouped together to form a bundle. This aggregate defines the composition of bundled or grouped items within QuickBooks Online.

ClassRef String False

Class.Id

False False

The unique Id for the class object that is linked to this item as found in the Id field of the class payload. This unique Id allows you to categorize the item under a specific class for reporting and tracking.

ClassRef_Name String False

Class.Name

False False

The identifying name for the class object that is linked to this item. This name provides a human-readable reference to the class that is applied.

ItemCategoryType String False False False

Specifies the classification that defines how this item is used. This field is applicable only for companies in France and helps categorize items according to local reporting requirements.

The allowed values are Product, Service.

Source String False False False

Specifies the source type for transactions that are created by QuickBooks Commerce. This value identifies where the item originated from within the system.

The allowed values are QBCommerce.

AbatementRate Decimal False False False

Specifies the sales tax abatement rate that is applied to this item. This field is used for transactions in Indian locales to comply with regional tax rules.

UQCDisplayText String False False False

Specifies the text that is displayed on a customer's invoice to denote the Unit of Measure instead of the standard code. This text provides clarity to customers on how quantities are measured.

UQCId String False False False

Specifies the identifier of the Standard Unit of Measure (UQC: Unique Quantity Code) for the item according to GST rules. This field ensures compliance with Indian GST requirements.

ReverseChargeRate Decimal False False False

Specifies the sales tax reverse charge rate that is applied to this item. This field is used for transactions in Indian locales to comply with reverse charge tax rules.

ServiceType String False False False

Specifies the sales tax service type that is applied to this item. This field is used for transactions in Indian locales to classify services according to regional tax categories.

TaxClassificationRef String False

TaxClassification.Id

False False

Specifies the unique identifier for the tax classification object that is linked to this item as found in the Id field of the tax classification payload. This field determines the tax treatment of the item.

TaxClassificationRef_Name String False

TaxClassification.Name

False False

Specifies the identifying name for the tax classification object that is linked to this item. This provides a human-readable reference for the tax classification that is applied.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434