Items

Columns

Name	Type	ReadOnly	References	Filterable	Sortable	Description
Id [KEY]	String	True		true	true	The Id of the item.
SyncToken	String	True		false	false	Version number of the object. It is used to lock an object for use by one app at a time. As soon as an application modifies an object, its SyncToken is incremented. Attempts to modify an object specifying an older SyncToken fails. Only the latest version of the object is maintained by QuickBooks Online.
MetaData_CreateTime	Datetime	True		true	true	The time the record was created.
MetaData_LastUpdatedTime	Datetime	True		true	true	The time the record was last updated.
Name	String	False		true	true	The name of the item.
FullyQualifiedName	String	False		false	false	The fully qualified name of the item. The fully qualified name consists the topmost parent element followed by each subelement and separated by colons. For example: Parent:Account1:SubAccount1:SubAccount2.
Description	String	False		false	false	The description for the item that describes the details of the service or product.
Active	Boolean	False		true	false	This column sets whether the item active. Inactive items may be hidden from display and are not used in financial transactions.
ParentRef	String	False	Items.Id	false	true	The Id of the parent entity of the item. If SubItem is true, then ParenRef is required.
ParentRef_Name	String	True	Items.Name	false	false	A name that identifies the parent entity of the item. If SubItem is true, then ParenRef is required.
PrefVendorRef	String	False	Vendors.Id	false	true	The Id of the vendor entity of the item.
PrefVendorRef_Name	String	False	Vendors.Name	false	false	A name that identifies the vendor entity of the item.
SubItem	Boolean	False		false	false	This field indicates whether the item is a subitem. A value of false or null indicates a top-level item.
UnitPrice	Decimal	False		false	true	Monetary value of the service or product, expressed in the home currency.
Type	String	False		true	true	Classification that specifies the use of this item. The allowed values are Inventory, NonInventory, Service, Category, Group.
Taxable	Boolean	False		false	false	This field indicates whether the item is subject to tax.
AssetAccountRef	String	False	Accounts.Id	false	false	The Id of the inventory asset account. If the same inventory asset account is assigned for individual items, the current balance of that account will show the current total value of the inventory. However, individual items may have different account.
AssetAccountRef_Name	String	True	Accounts.Name	false	false	The name of the inventory asset account. If the same inventory asset account is assigned for individual items, the current balance of that account will show the current total value of the inventory. However, individual items may have different accounts.
IncomeAccountRef	String	False	Accounts.Id	false	false	The Id of the account that records the proceeds from the sale of this item.
IncomeAccountRef_Name	String	True	Accounts.Name	false	false	The name of the account that records the proceeds from the sale of this item.
PurchaseDesc	String	False		false	false	The purchase description for the item.
PurchaseCost	Decimal	False		false	false	The amount paid when buying or ordering the item, as expressed in the home currency.
ExpenseAccountRef	String	False	Accounts.Id	false	false	The Id of the expense account associated with the purchase item.
ExpenseAccountRef_Name	String	True	Accounts.Name	false	false	The name of the expense account reference associated with the purchase item.
QtyOnHand	Double	False		false	true	The current quantity of the inventory items available for sale.
ReorderPoint	Double	False		false	false	The minimum quantity of a product to have on hand.
InvStartDate	Date	False		false	false	The date to start tracking inventory. Required if TrackQtyOnHand is set.
SalesTaxCodeRef	String	False	TaxCodes.Id	false	false	The sales tax code for the item.
PurchaseTaxCodeRef	String	False	TaxCodes.Id	false	false	The purchase tax code for the item.
TrackQtyOnHand	Boolean	False		false	false	This field indicates whether there is quantity on hand to be tracked.
Level	Integer	True		false	false	The level of the item. The value 0 indicates the top-level parent. Otherwise, this field specifies the depth from the top parent.
Sku	String	False		true	false	The stock keeping unit (SKU) for this Item. This is a company-defined identifier for an item or product used in tracking inventory.
SalesTaxIncluded	Boolean	False		false	false	This field indicates whether the sales tax is included in the item amount, and therefore not calculated for the transaction.
PurchaseTaxIncluded	Boolean	False		false	false	This field indicates whether the purchase tax is included in the item amount, and therefore not calculated for the transaction.
ItemGroupDetail_ItemGroupLineAggregate	String	True		false	false	One or more Item objects that comprise a bundle.