Alternative grouping for based pricing
Sterling™ Order Management System Software supplies region based pricing capability in its user interface. If you have a requirement to group based on criteria other than region, you can extend the organization and price list assignment tables. With a little customization, you can support the grouping of any way you want, and then do assignment based on that grouping.
For example, on the organization table, you could add an extended attribute for "competition level," with the values high, medium, and low. Then for each , define its competition level value, so that when you do the assignment you would also put that extended attribute on the assignment table. Instead of passing the assignment based on region key, you would pass it based whether competition is high, medium, or low for that or group of .