Power BI Connector for Sage 200

Build 20.0.7587

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587