Hi All,
Is there a table which keeps the status of seats and when they change? When our Box Office run reports to calculate the house capacity and the percentage sold, the figures change if a change is made to the auditorium once a show has started. So, retrospectively seats that had been blacked out and are now available will be calculated as not sold for past performances.
If I can identify when a seat changed from blacked out to available and then ticketed, I could add that into the reporting calculation, but I can't find where the information might be. I've tried TX_PERF_SEAT, but it doesn't hold a last updated date.
Any ideas anyone?
Thanks, Debbie
Prepare yourself for the Lovecraftian horror that is T_ORDER_SEAT_HIST.
This may be one of the best forum responses ever. How are you caffeinated enough at 9AM to use that 50 cent word?????? I can barely use the. LOL
Creating a meme now
heathwilder.files.wordpress.com/.../complete-sql-of-h.p.lovecraft.jpg