How could I pull a list of all of the performances valid for a specific promo code?
Hi Shelley,
It's not a report, but in TR_WEB_SOURCE_NO, for each source number I use the Promo Code Column to indicate conditions for a source code including amount of discount, all valid performances for the promo code and the Price Type to use for booking the tickets. Mos and Parent Key columns are left blank for this purpose.
For example, for one source code in this column I have entered Soulpepper members - 20% off Kingfisher, all shows except opening night GAF20
Then when the box office staff pull up the Source Code window, conditions are populated in the line below the Source code name and number. They can also then use the Promo Phrase Like: box at the bottom of this window to quickly filter down to all source codes that are applicable to a specific production.
Duane
To clarify my last post, if a source code has a promo code attached to it, then two separate line entries are made in TR_WEB_SOURCE_NO for that code - 1) assign promo code to MOS, 2) list of discount, performance and price type conditions.