ODBC Driver for Sage 50 UK

Build 23.0.8839


Query TradingActivities within Sage UK 50 Accounts.

Table Specific Information


The TradingActivities table returns the trading activity information for a Sage 50 UK company dataset.

SELECT * FROM TradingActivities


Name Type Description
TradingActivityUUID [KEY] String TradingActivity UUID
ApplicationID String TradingActivity Application ID
Deleted Boolean TradingActivity Deleted
Label String TradingActivity Label
Reference String TradingActivity Reference
TransactionType String TradingActivity TransactionType
Date Date TradingActivity Date
Details String TradingActivity Details
AmountNet Decimal TradingActivity NetAmount
AmountTax Decimal TradingActivity TaxAmount
AmountGross Decimal TradingActivity GrossAmount
Currency String TradingActivity Currency
AmountPaid Decimal TradingActivity PaidAcmount
TradingAccountReference String TradingActivity AccountReference
DueDate Date TradingActivity Due Date
HeaderNumber String TradingActivity Header Number


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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839