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