InventorySites
Manages QuickBooks Inventory Sites, including creation, updates, deletion, and queries. Available only in QuickBooks Enterprise with Advanced Inventory and QBXML Version 10.0 or higher.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier for the inventory site. | |
| Name | String | False | 31 |
The name of the inventory site, used for identification within QuickBooks. | |
| IsActive | Boolean | False |
Indicates whether the inventory site is currently active and available for use. | ||
| SiteDesc | String | False | 100 |
A detailed description of the inventory site, providing additional context or notes. | |
| Contact | String | False | 41 |
The name of the primary contact person for the inventory site. | |
| Phone | String | False | 21 |
The phone number associated with the inventory site for communication. | |
| Fax | String | False | 21 |
The fax number associated with the inventory site. | |
| String | False | 1023 |
The email address associated with the inventory site for correspondence. | ||
| SiteAddress_Addr1 | String | False | 500 |
The first line of the inventory site's address, typically the street address. | |
| SiteAddress_Addr2 | String | False | 500 |
The second line of the inventory site's address, often used for suite or unit numbers. | |
| SiteAddress_Addr3 | String | False | 500 |
The third line of the inventory site's address, used for additional location details. | |
| SiteAddress_Addr4 | String | False | 500 |
The fourth line of the inventory site's address, used as needed for further address details. | |
| SiteAddress_Addr5 | String | False | 41 |
The fifth line of the inventory site's address, for any remaining address information. | |
| SiteAddress_City | String | False | 255 |
The city where the inventory site is located. | |
| SiteAddress_State | String | False | 255 |
The state or province where the inventory site is located. | |
| SiteAddress_PostalCode | String | False | 30 |
The postal or ZIP code for the inventory site's location. | |
| SiteAddress_Country | String | False | 255 |
The country where the inventory site is located. | |
| EditSequence | String | True | 16 |
A version control string that tracks changes made to the inventory site. | |
| TimeCreated | Datetime | True |
The date and time when the inventory site was first created. | ||
| TimeModified | Datetime | True |
The date and time when the inventory site was last updated. | ||
| IsDefaultSite | Boolean | True |
Indicates whether this inventory site is set as the default site for the company. |