JDBC Driver for Sage 50 UK

Build 22.0.8462

TradingActivities

Query TradingActivities within Sage UK 50 Accounts.

Table Specific Information

Select

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

SELECT * FROM TradingActivities

Columns

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