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