Interactions
Query Interactions within Sage UK 50 Accounts.
Table Specific Information
Select
The Interactions table returns the customer interaction information for a Sage 50 UK company dataset.
SELECT * FROM Interactions
Columns
| Name | Type | Description |
| InteractionUUID [KEY] | String | Interaction UUID |
| TradingAccountUUID | String | Interaction Trading Account UUID |
| Type | String | Interaction Type |
| Status | String | Interaction Status |
| TradingAccountReference | String | Interaction Reference |
| Description | String | Interaction Description |
| User | String | Interaction User |
| Date | Date | Interaction Date |
| Time | Time | Interaction Time |
| EndDate | Date | Interaction End Date |
| EndTime | Time | Interaction End Time |
| Recurrence | Boolean | Interaction Recurrence |
| PrivacyFlag | Boolean | Interaction Privacy Flag |
| PromisedPaymentDate | Date | Interaciton Promised Payment Date |
| FollowUpDate | Date | Interaction Follow Up Date |
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 |
| Updated | Datetime | An input used internally to filter records updated at a specific datetime. |