Power BI Connector for QuickBooks

Build 23.0.8839

TransferInventory

Query and delete QuickBooks Transfer Inventory transactions. Transfer Inventory is available in only QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on.

Table Specific Information

TransferInventory transactions may be queried via the TransferInventory or TransferInventoryLineItems tables. TransferInventory transactions may be added by using the TransferInventoryLineItems table. TransferInventory transactions may be deleted by using the TransferInventory table. Updates to existing TransferInventory transactions are not supported at this time.

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 only be used with the equals or = comparison. The available columns for the TransferInventory table are Id, TimeModified, TxnDate, and RefNumber. TimeModified and TxnDate may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. RefNumber may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:

SELECT * FROM TransferInventoryLineItems WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND RefNumber LIKE '%12345%'

To insert subitems, set the ItemName field to the FullName of the item; for example, '<Row><ItemName>Subs:Carpet</ItemName><ItemQuantity>0</ItemQuantity></Row>'

Columns

Name Type ReadOnly References ColumnSize Description
ID [KEY] String True 255

The unique identifier.

TxnDate Date False

The date of the transaction.

TxnNumber Integer True

An identifying number for this transaction.

RefNumber String False 21

The transaction reference number.

FromInventorySiteRef_ListID String False

InventorySites.ID

255

The site inventory was transfered from.

FromInventorySiteRef_FullName String False 31

The site inventory was transfered from.

ToInventorySiteRef_ListID String False

InventorySites.ID

255

The site inventory was transfered to.

ToInventorySiteRef_FullName String False 31

The site inventory was transfered to.

Memo String False 5000

Additional information about the transaction.

ExternalGUID String False

Allows for the attachment of a user defined GUID value.

TransferInventoryLineAggregate String False 5000

An aggregate of the line item data which can be used for adding a transfer inventory and its line item data.

TimeCreated Datetime True

The datetime the transaction was made.

TimeModified Datetime True

The last datetime the transaction was modified.

EditSequence String True 16

An identifier used for versioning for this copy of the object.

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