| Name | Type | ReadOnly | Filterable | Description |
|---|---|---|---|---|
| Id [KEY] | string | true | true | The Id of the item. |
| SyncToken | string | false | false | The sync token. This must be specified when executing an update or delete. |
| MetaData_CreateTime | datetime | true | true | The time the record was created. |
| MetaData_LastUpdatedTime | datetime | true | true | The time the record was last updated. |
| Name | string | false | true | The name of the item. |
| FullyQualifiedName | string | 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 | The description for the item that describes the details of the service or product. |
| Active | boolean | false | true | This column sets whether the item active. Inactive items may be hidden from display and are not used in financial transactions. |
| ParentRef | string | false | false | The Id of the parent entity of the item. If SubItem is true, then ParenRef is required. |
| ParentRef_Name | string | true | false | A name that identifies the parent entity of the item. If SubItem is true, then ParenRef is required. |
| PrefVendorRef | string | false | false | The Id of the vendor entity of the item. |
| PrefVendorRef_Name | string | false | false | A name that identifies the vendor entity of the item. |
| SubItem | boolean | 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 | Monetary value of the service or product, expressed in the home currency. |
| Type | string | false | true | Classification that specifies the use of this item. |
| Taxable | boolean | false | false | This field indicates whether the item is subject to tax. |
| AssetAccountRef | string | 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 | 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 | false | The Id of the account that records the proceeds from the sale of this item. |
| IncomeAccountRef_Name | string | true | false | The name of the account that records the proceeds from the sale of this item. |
| PurchaseDesc | string | false | false | The purchase description for the item. |
| PurchaseCost | decimal | false | false | The amount paid when buying or ordering the item, as expressed in the home currency. |
| ExpenseAccountRef | string | false | false | The Id of the expense account associated with the purchase item. |
| ExpenseAccountRef_Name | string | true | false | The name of the expense account reference associated with the purchase item. |
| QtyOnHand | double | false | false | The current quantity of the inventory items available for sale. |
| ReorderPoint | double | false | false | The minimum quantity of a product to have on hand. |
| InvStartDate | date | false | false | The date to start tracking inventory. Required if TrackQtyOnHand is set. |
| SalesTaxCodeRef | string | false | false | The sales tax code for the item. |
| SalesTaxCodeRef_Name | string | true | false | The name of the sales tax code for the item. |
| PurchaseTaxCodeRef | string | false | false | The purchase tax code for the item. |
| PurchaseTaxCodeRef_Name | string | true | false | The name of the purchase tax code for the item. |
| TrackQtyOnHand | boolean | false | false | This field indicates whether there is quantity on hand to be tracked. |
| Level | integer | true | 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 | 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 | This field indicates whether the sales tax is included in the item amount, and therefore not calculated for the transaction. |
| PurchaseTaxIncluded | boolean | false | false | This field indicates whether the purchase tax is included in the item amount, and therefore not calculated for the transaction. |
| ItemGroupDetail_ItemGroupLine | string | true | false | One or more Item objects that comprise a bundle. |
| ClassRef | string | false | true | The Id of the class associated with the transaction. |
| ClassRef_Name | string | true | false | The name of the class associated with the transaction. |
