CustomerContacts
Create, update, delete, and query Reckon Customer Contacts. This table requires QBXML version 12.0 or higher, and is only available in Reckon editions 2016 and above.
Columns
| Name | Type | ReadOnly | References | Description |
| ID [KEY] | String | True |
The unique identifier of the shipping address in the format CustomerId|ContactId. | |
| CustomerId | String | False |
Customers.ID |
The Id of the customer the shipping address is associated with. |
| Name | String | False |
The name of the customer. This is required to have a value when inserting. | |
| FullName | String | True |
The full name of the customer, including parents in the format parent:customer. | |
| ContactId | String | False |
The Id of the contact. | |
| ContactEditSequence | String | False |
An identifer used for versioning for this copy of the object. | |
| ContactFirstName | String | False |
The first name of the contact. | |
| ContactMiddleName | String | False |
The middle name of the contact. | |
| ContactLastName | String | False |
The last name of the contact. | |
| ContactJobTitle | String | False |
The job title of the contact. | |
| ContactSalutation | String | False |
The salutation of the contact. | |
| ContactMethods | String | False |
A list of contact methods for the contact. | |
| EditSequence | String | False |
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. The default value is TRUE. |