InventorySites
Create, Update, Query, and Delete QuickBooks Inventory Sites. Inventory Sites are only available in QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on.
Columns
| Name | Type | Description | ReadOnly |
| ID [KEY] | String |
The id of the Inventory Site. | True |
| Name | String |
Name of the Inventory Site. | False |
| IsActive | Boolean |
Whether or not the Inventory Site is active. | False |
| SiteDesc | String |
A description of the Inventory Site. | False |
| Contact | String |
Contact for the Inventory Site. | False |
| Phone | String |
Phone number for the Inventory Site. | False |
| Fax | String |
Fax number for the Inventory Site. | False |
| String |
Email address for the Inventory Site. | False | |
| SiteAddress_Addr1 | String |
First line of the Address. | False |
| SiteAddress_Addr2 | String |
Second line of the Address. | False |
| SiteAddress_Addr3 | String |
Third line of the Address. | False |
| SiteAddress_Addr4 | String |
Fourth line of the Address. | False |
| SiteAddress_Addr5 | String |
Fifth line of the Address. | False |
| SiteAddress_City | String |
City portion of the Address. | False |
| SiteAddress_State | String |
State portion of the Address. | False |
| SiteAddress_PostalCode | String |
Postal Code portion fo the Address. | False |
| SiteAddress_Country | String |
Country portion of the Address. | False |
| EditSequence | String |
A string indicating the revision of the Inventory Site. | True |
| TimeCreated | Datetime |
The time the Inventory Site was created. | True |
| TimeModified | Datetime |
The time the Inventory Site was modified. | True |
| IsDefaultSite | Boolean |
Boolean indicating if the Inventory Site is the default site for the company. | True |
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 | |
| StartModifiedDate | String |
Earliest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format) | |
| EndModifiedDate | String |
Latest modified date to search for (in yyyy-MM-dd, MM-dd-yy, MM-dd-yyyy, MM/dd/yy, or MM/dd/yyyy format). | |
| MaxResults | String |
Maximum number of results to return. |