CustomerShippingAddresses
Manages multiple shipping addresses for QuickBooks Customers, including creation, updates, deletion, and queries. Requires QBXML Version 12.0 or higher and is supported in QuickBooks 2013 and higher.
Table Specific Information
Insert
To insert a new Shipping Address, specify the CustomerId and the ShipToName of the new Address. Fields designated with a Shipping may be used as to insert multiple Addresses in one statement. For example:INSERT INTO CustomerShippingAddresses#TEMP (CustomerId, ShipToName, ShipToCity) VALUES ('123456789-9999', 'Shipto Addr 1', 'London')
INSERT INTO CustomerShippingAddresses#TEMP (CustomerId, ShipToName, ShipToCity) VALUES ('123456789-9999', 'Shipto Addr 2', 'Paris')
INSERT INTO CustomerShippingAddresses (CustomerId, ShipToName, ShipToCity) SELECT CustomerId, ShipToName, ShipToCity FROM CustomerShippingAddresses#TEMP
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier for the shipping address, formatted as CustomerId|ShipToName. | |
| CustomerId | String | False |
Customers.ID | 255 |
The unique identifier of the customer associated with this shipping address. |
| Name | String | False | 100 |
The name of the customer. This is required when adding a new shipping address. | |
| FullName | String | True | 1000 |
The full hierarchical name of the customer, formatted as Parent:Customer. | |
| ShipToName | String | False | 500 |
The name assigned to the shipping address in QuickBooks. This field is required when adding additional shipping addresses for a customer. | |
| ShipToAddr1 | String | False | 500 |
The first line of the shipping address. | |
| ShipToAddr2 | String | False | 500 |
The second line of the shipping address. | |
| ShipToAddr3 | String | False | 500 |
The third line of the shipping address. | |
| ShipToAddr4 | String | False | 500 |
The fourth line of the shipping address. | |
| ShipToAddr5 | String | False | 41 |
The fifth line of the shipping address. | |
| ShipToCity | String | False | 255 |
The city associated with the shipping address. | |
| ShipToState | String | False | 255 |
The state or province associated with the shipping address. | |
| ShipToPostalCode | String | False | 30 |
The postal code or ZIP code of the shipping address. | |
| ShipToCountry | String | False | 255 |
The country associated with the shipping address. | |
| ShipToNote | String | False | 41 |
Additional notes or information about the shipping address. | |
| ShipToDefaultShipTo | Boolean | False |
Indicates whether this shipping address is set as the default for the customer. | ||
| EditSequence | String | False | 16 |
An identifier used to track versioning for this shipping address. | |
| TimeModified | Datetime | False |
The timestamp of the last modification made to this shipping address. | ||
| TimeCreated | Datetime | False |
The timestamp when this shipping address was created. |
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 |
| IncludeJobs | Boolean |
Specifies whether to include job-related information in the results. デフォルト値はTRUEです。 |