ItemLineItems
Manages individual line items in QuickBooks Items, including creation, updates, deletion, and queries for detailed inventory tracking.
Table Specific Information
Item Line Items may be inserted, deleted, and updated via the ItemLineItems table. Item Line Items refer to the Line Items associated with item groups, inventory assemblies, or sales tax groups.
This table has a Custom Fields column. See the Custom Fields page for more information.
Select
By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.
QuickBooks allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only the equals or = comparison. The available columns for Items are Id, TimeModified, Name, Type, and IsActive. TimeModified may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. Name may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:
SELECT * FROM ItemLineItems WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND Name LIKE '%12345%'
Insert
To add a Line Item, specify the ItemId or Assembly Id columns of the Item Group or Assembly you want to add the Line Item to when making the insertion. For example:
INSERT INTO ItemLineItems (ItemId, LineItemName, LineItemQuantity) VALUES ('430001-1071511103|130000-933272656', 'Hardware:Doorknobs Std', 1)
To insert a new Inventory Assembly, Item Group, or Sales Tax Group with Line Items, provide the Name and Type columns and at least one Line Item. For example:
INSERT INTO ItemLineItems#TEMP (Name, Type, LineItemName, LineItemQuantity) VALUES ('MyItemGroup', 'ItemGroup', 'Hardware:Doorknobs Std', 1)
INSERT INTO ItemLineItems#TEMP (Name, Type, LineItemName, LineItemQuantity) VALUES ('MyItemGroup', 'ItemGroup', 'Cabinets', 2)
INSERT INTO ItemLineItems (Name, Type, LineItemName, LineItemQuantity) SELECT Name, Type, LineItemName, LineItemQuantity FROM ItemLineItems#TEMP
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
A unique identifier for the line item, formatted as ItemId|ItemLineNumber. | |
| ItemId | String | False |
Items.ID | 255 |
The unique identifier for the inventory assembly or group item within QuickBooks. |
| Name | String | False | 100 |
The name of the inventory assembly or group item. | |
| FullName | String | True | 1000 |
The full name of the item, including parent item names if it is a subitem. Formatted as parentname:name. | |
| Type | String | False | 100 |
The type of item, such as inventory, non-inventory, or service. This field is required when inserting new items. デフォルト値はALLです。 | |
| Barcode | String | False |
The barcode assigned to the item for scanning and identification purposes. | ||
| Account | String | False | 1000 |
The name of the account associated with the inventory assembly or group. | |
| AccountId | String | False |
Accounts.ID | 255 |
The unique identifier of the account associated with the inventory assembly or group. |
| COGSAccount | String | False | 1000 |
The name of the Cost of Goods Sold (COGS) account linked to the inventory assembly or group. | |
| COGSAccountId | String | False |
Accounts.ID | 255 |
The unique identifier of the Cost of Goods Sold (COGS) account linked to the inventory assembly or group. |
| AssetAccount | String | False | 1000 |
The name of the inventory asset account associated with the inventory assembly or group, applicable if it is an inventory item. | |
| AssetAccountId | String | False |
Accounts.ID | 255 |
The unique identifier of the inventory asset account associated with the inventory assembly or group, applicable if it is an inventory item. |
| LineItemNumber | Integer | False |
The sequential number of the line item within the inventory assembly or group. | ||
| LineItemId | String | False |
Items.ID | 255 |
The unique identifier for the line item. Either LineItemId or LineItemName must be provided when inserting. |
| LineItemName | String | False |
The name of the line item. Either LineItemId or LineItemName must be provided when inserting. | ||
| LineItemQuantity | Double | False |
The quantity of the line item included in the inventory assembly or group. | ||
| LineItemUnitOfMeasure | String | False |
The unit of measure used for the line item, such as 'each' or 'dozen.' | ||
| ParentName | String | False |
The name of the parent item for the inventory assembly or group, if it is a subitem. | ||
| ParentId | String | False |
Items.ID | 255 |
The unique identifier of the parent item for the inventory assembly or group, if it is a subitem. |
| Description | String | False | 5000 |
A description of the inventory assembly or group, providing details about its use or contents. | |
| Price | Double | False |
The price of the inventory assembly or group, used for sales and pricing calculations. | ||
| AverageCost | Double | True |
The average cost of the inventory assembly or group, calculated based on purchase and inventory data. | ||
| IsActive | Boolean | False |
Indicates whether the inventory assembly or group item is active and available for use. | ||
| PurchaseCost | Double | False |
The cost of purchasing the inventory assembly or group item. | ||
| PurchaseDescription | String | False | 5000 |
A description of the inventory assembly or group item specific to purchasing transactions. | |
| PreferredVendor | String | False | 1000 |
The name of the preferred vendor for procuring the inventory assembly or group item. | |
| PreferredVendorId | String | False |
Vendors.ID | 255 |
The unique identifier of the preferred vendor for procuring the inventory assembly or group item. |
| TaxCode | String | False | 3 |
A reference to a predefined sales tax code within QuickBooks, applicable to the item. | |
| TaxCodeId | String | False | 255 |
The unique identifier for the sales tax code within QuickBooks, applicable to the item. | |
| IsTaxIncluded | Boolean | False |
Indicates whether taxes are included in the transaction amount. This feature is available only in international editions of QuickBooks. | ||
| CustomFields | String | False |
Custom fields defined for the item, returned as XML data. | ||
| TimeModified | Datetime | True |
The date and time when the inventory assembly or group was last modified. | ||
| TimeCreated | Datetime | True |
The date and time when the inventory assembly or group was originally created. |