Prices
Query Prices within Sage UK 50 Accounts.
Table Specific Information
Select
The Prices table returns the product and services pricing information for a Sage 50 UK company dataset.
SELECT * FROM Prices WHERE Price < 10.00
Columns
| Name | Type | Description |
| PriceUUID [KEY] | String | Price UUID |
| ProductCode | String | Price Reference |
| Price | Decimal | Price |
| IncludesTax | Boolean | Price Includes Tax |
| Currency | String | Price Currency |
| DecimalPlaces | Decimal | Price Decimal Places |
| CustomerSupplierFlag | String | Price Customer Supplier Flag |
| OCCurrency | String | PurchaseOrderDelivery Operating Company Currency |
| OCCurrencyExchangeRate | Decimal | PurchaseOrderDelivery Operating Company Currency Exchange Rate |
| OCCurrencyExchangeRateOperator | String | PurchaseOrderDelivery Operating Company Currency Exchange Rate Operator |
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. |