CustomerNotes
Manages QuickBooks Customer Notes, allowing creation, updates, and queries for tracking customer-specific information. Requires QBXML Version 12.0 or higher.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier for the note, formatted as CustomerId|NoteId. | |
| CustomerID | String | False |
Customers.ID | 255 |
The unique identifier of the customer associated with the note. |
| 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 any hierarchical parent relationships, formatted as Parent:Customer. | |
| NoteId | String | False | 255 |
The unique identifier for the note associated with the customer. | |
| Date | String | False | 5000 |
The date when the note was created or last updated. | |
| Note | String | False | 5000 |
The content of the note related to the customer. | |
| EditSequence | String | False | 16 |
An identifier used to track versioning for this specific note object. | |
| TimeModified | Datetime | False |
The timestamp indicating when the customer or note record was last modified. | ||
| TimeCreated | Datetime | False |
The timestamp indicating when the customer or note 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-related information should be included in the query results. True to include jobs; false otherwise. The default value is TRUE. |