CustomerContacts
Create, update, delete, and query QuickBooks Customer Contacts. This table requires QBXML version 12.0 or higher, and is only available in QuickBooks editions 2016 and above.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier of the shipping address in the format CustomerId|ContactId. | |
| CustomerId | String | False |
Customers.ID | 255 |
The Id of the customer the shipping address is associated with. |
| Name | String | False | 100 |
The name of the customer. This is required to have a value when inserting. | |
| FullName | String | True | 1000 |
The full name of the customer, including parents in the format parent:customer. | |
| ContactId | String | False | 500 |
The Id of the contact. | |
| ContactEditSequence | String | False | 500 |
An identifer used for versioning for this copy of the object. | |
| ContactFirstName | String | False | 500 |
The first name of the contact. | |
| ContactMiddleName | String | False | 500 |
The middle name of the contact. | |
| ContactLastName | String | False | 500 |
The last name of the contact. | |
| ContactJobTitle | String | False | 41 |
The job title of the contact. | |
| ContactSalutation | String | False | 255 |
The salutation of the contact. | |
| ContactMethods | String | False | 1000 |
A list of contact methods for the contact. | |
| EditSequence | String | False | 16 |
An identifier used for versioning for this copy of the object. | |
| TimeModified | Datetime | False |
When the customer was last modified. | ||
| TimeCreated | Datetime | False |
When the customer 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 |
Whether or not to include job information in the results. デフォルト値はTRUEです。 |