Hi all,
Just when I thought I understood the results of GetPerformanceDetailWithDiscountingEx(), I'm getting some results that don't make sense, though it may be that someone has set up discounted price types incorrectly. How should I consider the three tables, Price, PriceType, and AllPrice? By what general algorithm should I expose zones and price types for a user to choose from?
Here's what I originally thought:
My main question would be, how do you know when a price type should be offered to the user? The system that I'm working with is returning all kinds of discount price types that should not be shown to web users by default. I can't figure out how to differentiate.
Also, what is the meaning of the "def_price_type" field of the PriceType table? What purpose does it serve that the AllPrice table's "def_price_type" field doesn't already serve? That seems to imply that a single price type must be set as default for every single zone.
Other than that, what is the practical use for the Price table? It seems redundant from the AllPrice table.
Thanks for your advice,Bryan
Here’s the explanation of the three tables, from the Web API documentation:
Price details the price of a seat using the default price type for the mode of sale. A separate grouping of data is listed for each price zone in the performance, with the total number of available seats in the price zone.
NOTE: If a default price type has not been designated for the mode of sale in TX_MOS_PRICE_TYPE the Price table is not included in the results dataset.
PriceType lists details of a price type (from TR_PRICE_TYPE). A separate grouping of data is listed for each available price type. If a price type from an offer is returned, details of the offer will also be listed with the following values:
AllPrice lists the price of a seat using every available price type. A separate grouping of data is listed for each price type/price zone combination, with the total number of available seats in the price zone. Pricing for price types associated with offers will be returned even if no session key is passed or the source for the session does not qualify for the offer.
Kevin Sheehan
Senior Documentation & Learning Resources Specialist
Tessitura Network
+1 888 643 5778 x 329
ksheehan@tessituranetwork.com