What would be the simplest way (pseudocode is fine) to ask Tessitura if a particular customer number was a single ticket buyer for a particular season?
My only hangup is which table would definitively have that info. I can write the logic, but I get so easily confused about what tables hold what information when it comes to ticketing.
Thanks for your help, guys.
Trivia Carrot on Stick: Elephants are the only mammal (besides humans) that can stand on its head.
Simplest way would be lt_tkt_hist ->tr_price_type (assuming your tkt hist has price type) where the pt category/group/ however your org establishes what is "single" and season= (the season in question).
If your tkt hist doesn't contain pricetype, then I'd say
order -> sublineitem
-> perf (for the season)
->price_type