CustomerNotes
Create, update, and query QuickBooks Customer Notes. This table requires QBXML version 12.0 or higher.
Columns
| Name | Type | ReadOnly | References | ColumnSize | Description |
| ID [KEY] | String | True | 255 |
The unique identifier of the note in the format CustomerId|NoteId. | |
| CustomerID | String | False |
Customers.ID | 255 |
The Id of the customer the note 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. | |
| NoteId | String | False | 255 |
Id of the note. | |
| Date | String | False | 5000 |
Date for this note | |
| Note | String | False | 5000 |
Note for this customer | |
| 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です。 |