ItemSites
Create, update, delete, and query QuickBooks Item Sites. Item sites are only available in QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on. This table requires a minimum of QBXML version 10.0.
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The Id of the inventory site. | |
| ItemInventoryAssemblyRef_ListID | String |
Items.ID | Reference to the Id of an inventory assembly located on the item site. Either an inventory assembly or an inventory item will be specified, but not both. |
| ItemInventoryAssemblyRef_FullName | String | Reference to the full name of an inventory assembly located on the item site. Either an inventory assembly or an inventory item will be specified, but not both. | |
| ItemInventoryRef_ListID | String |
Items.ID | Reference to the Id of an inventory item located on the item site. Either an inventory assembly or an inventory item will be specified, but not both. |
| ItemInventoryRef_FullName | String | Reference to the full name of an inventory item located on the item Site. Either an inventory assembly or an Inventory Item will be specified, but not both. | |
| InventorySiteRef_ListID | String | Reference to the Id of an inventory site. | |
| InventorySiteRef_FullName | String | Reference to the full name of an inventory site. | |
| InventorySiteLocationRef_ListID | String | Reference to the Id of an inventory site location. This field requires QBXML version 12.0 or higher. | |
| InventorySiteLocationRef_FullName | String | Reference to the full name of an inventory site location. This field requires QBXML version 12.0 or higher. | |
| ReorderLevel | Double | The quantity at which to reorder the inventory assembly or inventory item. | |
| QuantityOnHand | Double | The total quantity of the inventory assemblies or inventory items in the inventory. | |
| QuantityOnPurchaseOrders | Double | The quantity of the inventory assemblies or inventory items currently on open purchase orders. | |
| QuantityOnSalesOrders | Double | The quantity of the inventory assemblies or inventory items currently on open sales orders. | |
| QuantityToBeBuiltByPendingBuildTxns | Double | The quantity of the inventory assemblies or inventory items are in use by pending Build Assembly transactions. | |
| QuantityRequiredByPendingBuildTxns | Double | The quantity of the inventory assemblies or inventory items that are required to complete remaining build assembly transactions. | |
| QuantityOnPendingTransfers | Double | The quantity of the inventory assemblies or inventory items that are currently on pending transfer inventory transactions. | |
| AssemblyBuildPoint | Double | The quantity of the inventory assemblies or inventory items remaining before creating a new Assembly. | |
| EditSequence | String | A string indicating the revision of the inventory site. | |
| TimeCreated | Datetime | The time the inventory site was created. | |
| TimeModified | Datetime | The time the inventory site was modified. |
Pseudo-Columns
Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| ItemType | String | The type of item. Can be specified as a criteria for the table. |