PriceBands

A price band is simply a price list. They're used to offer different prices to different customers. Product prices are set in the each price band. The price a customer receives for a product depends on the price band their account is linked to.

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 PriceBands WHERE Id = 1064
SELECT * FROM PriceBands WHERE Name = 'Standard'
SELECT * FROM PriceBands WHERE Description = 'Standard'
SELECT * FROM PriceBands WHERE IsStandardBand = true
SELECT * FROM PriceBands WHERE CurrencyId = 2103
SELECT * FROM PriceBands WHERE PriceBandTypeId = 0
SELECT * FROM PriceBands WHERE IsActive = true
SELECT * FROM PriceBands WHERE IsTimeBased = false
SELECT * FROM PriceBands WHERE ActiveDateTimeFrom = '2019-10-02T11:46:53Z'
SELECT * FROM PriceBands WHERE ActiveDateTimeTo = '2019-10-02T11:46:53Z'
SELECT * FROM PriceBands WHERE DateTimeUpdated = '2018-02-28T15:23:46.183+01:00'

Columns


Name	Type	References	Description
Id [KEY]	Long		Price band record Id.
Name	String		Price band name.
Description	String		Price band description.
IsStandardBand	Bool		Is this the Standard price band.
CurrencyId	Long		Currency record Id. See currencies
PriceBandTypeId	Long		Price band type record Id; this will be 0 for Universal price bands and 1 for Limited price bands.
IsActive	Bool		Is this price band active.
IsTimeBased	Bool		Is this price band time based.
ActiveDateTimeFrom	Datetime		The date and time this price band is active from.
ActiveDateTimeTo	Datetime		The date and time this price band is active to.
DateTimeUpdated	Datetime		The date and time this entity was last updated (UTC).

JDBC Driver for Sage 200

PriceBands

Table Specific Information

Select

Columns