TransferInventory
Manages QuickBooks Inventory Transfers, supporting queries and deletion for inventory movement tracking. Available in QuickBooks Enterprise with Advanced Inventory.
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 assigned to this inventory transfer transaction by QuickBooks. It ensures each transaction is distinct. | |
| TxnDate | Date | False |
The date when the inventory transfer occurred, formatted as YYYY-MM-DD. This field is required when inserting a transaction. | ||
| TxnNumber | Integer | True |
An identifying number assigned to this transaction, typically used for tracking purposes. | ||
| RefNumber | String | False | 21 |
A user-defined reference number for the transaction, such as a document or tracking number. | |
| FromInventorySiteRef_ListID | String | False | 255 |
The unique identifier (ListID) of the inventory site from which the inventory was transferred. | |
| FromInventorySiteRef_FullName | String | False | 31 |
The full name of the inventory site from which the inventory was transferred. | |
| ToInventorySiteRef_ListID | String | False | 255 |
The unique identifier (ListID) of the inventory site to which the inventory was transferred. | |
| ToInventorySiteRef_FullName | String | False | 31 |
The full name of the inventory site to which the inventory was transferred. | |
| Memo | String | False | 5000 |
Optional additional information or notes about the inventory transfer. | |
| ExternalGUID | String | False |
A user-defined globally unique identifier (GUID) that can be attached to this transaction for tracking purposes. | ||
| TransferInventoryLineAggregate | String | False | 5000 |
A collection of line item data representing the details of the inventory being transferred. Use this field to include multiple items in a single transaction. | |
| TimeCreated | Datetime | True |
The date and time when the inventory transfer transaction was created, in the format YYYY-MM-DD HH:MM:SS. | ||
| TimeModified | Datetime | True |
The date and time when the inventory transfer transaction was last modified, in the format YYYY-MM-DD HH:MM:SS. | ||
| EditSequence | String | True | 16 |
A unique identifier used for version control to ensure this copy of the transaction is up to date. |