CustomerContacts
Manages QuickBooks Customer Contacts, allowing creation, updates, deletion, and queries for customer relationship management. 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 for the shipping address, formatted as CustomerId|ContactId. | |
| CustomerId | String | False |
Customers.ID | 255 |
The unique identifier of the customer associated with the shipping address. |
| Name | String | False | 100 |
The name of the customer. This field is required when inserting a new record. | |
| FullName | String | True | 1000 |
The full name of the customer, including hierarchical parent relationships, formatted as Parent:Customer. | |
| ContactId | String | False | 500 |
The unique identifier of the contact associated with the customer. | |
| ContactEditSequence | String | False | 500 |
An identifier used to track versioning for this specific copy of the contact object. | |
| ContactFirstName | String | False | 500 |
The first name of the contact associated with the customer. | |
| ContactMiddleName | String | False | 500 |
The middle name of the contact associated with the customer. | |
| ContactLastName | String | False | 500 |
The last name of the contact associated with the customer. | |
| ContactJobTitle | String | False | 41 |
The job title or position of the contact within their organization. | |
| ContactSalutation | String | False | 255 |
The salutation for the contact, such as Mr., Ms., or Dr. | |
| ContactMethods | String | False | 1000 |
A list of contact methods for the contact, such as phone numbers, email addresses, or fax numbers. | |
| EditSequence | String | False | 16 |
An identifier used to track versioning for this specific copy of the object. | |
| TimeModified | Datetime | False |
The timestamp indicating when the customer or contact record was last modified. | ||
| TimeCreated | Datetime | False |
The timestamp indicating when the customer or contact record was originally 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 |
Indicates whether job information should be included in the query results. True to include jobs; false otherwise. デフォルト値はTRUEです。 |