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 Desktop 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 | 255 |
The site inventory was transfered from. | |
| FromInventorySiteRef_FullName | String | False | 31 |
The site inventory was transfered from. | |
| ToInventorySiteRef_ListID | String | False | 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. |