JDBC Driver for Sage 50 UK

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462