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