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