Power BI Connector for QuickBooks

Build 23.0.8839

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

InventorySites.ID

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839