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. |