ProductPrices

This returns the selling prices of your products. A price is returned for each price band associated with a product. A price band is simply a price list. The price a customer receives for a product depends on the price band their account is linked to. The 'Standard' price band is the default. The prices returned here do not include any customer specific discounts. The default sort (orderby) field is by 'product_code' ascending.

Table Specific Information

Select

The driver uses the Sage 200c Standard Online API to process all search criteria.

Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.

For example, the following queries are processed server side:

SELECT * FROM ProductPriceViews WHERE ProductPriceId = 34760
SELECT * FROM ProductPriceViews WHERE ProductId = 34751
SELECT * FROM ProductPriceViews WHERE ProductCode = 'BOARD001'
SELECT * FROM ProductPriceViews WHERE ProductName = 'Whiteboard - Drywipe (900 x 1200)'
SELECT * FROM ProductPriceViews WHERE ProductStockUnitName = 'Each'
SELECT * FROM ProductPriceViews WHERE PriceBandId = 1064
SELECT * FROM ProductPriceViews WHERE PriceBandName = 'Standard'
SELECT * FROM ProductPriceViews WHERE ProductPriceUseStandard = true
SELECT * FROM ProductPriceViews WHERE ProductPricePrice = 20
SELECT * FROM ProductPriceViews WHERE CurrencyId = 2103
SELECT * FROM ProductPriceViews WHERE CurrencyName = 'Pound Sterling'
SELECT * FROM ProductPriceViews WHERE CurrencySymbol = '£'
SELECT * FROM ProductPriceViews WHERE DateTimeUpdated = '2018-02-28T15:23:46.787+01:00'

Columns


Name	Type	References	Description
ProductPriceId	Long		Product price record Id.
ProductId	Long		Product record Id. See products
ProductCode [KEY]	String		Product code.
ProductName	String		Product name.
ProductStockUnitName	String		The name of the unit the product is sold in. For example box, crate, bottle. The default unit is each.
PriceBandId	Long		Price band record Id.
PriceBandName	String		The name of the price band.
ProductPriceUseStandard	Bool		'True' if uses the price from the standard price band is used otherwise 'False' The price of a product can be linked to the price set in the standard price band. This is used when only some product prices are different to the standard price.
ProductPricePrice	Decimal		The selling price for the shown product and price band.
CurrencyId	Long		Currency record Id. See currencies
CurrencyName	String		The name of the currency used for the price.
CurrencySymbol	String		The symbol of the currency used for the price.
DateTimeUpdated	Datetime		The date and time this entity was last updated (UTC).

JDBC Driver for Sage 200

ProductPrices

Table Specific Information

Select

Columns