JDBC Driver for Sage 50 UK

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462