Hi Tess Network,
I crafted a report that collects all Comp Tickets sold for a performance run by aggregating records from the t_sub_lineitem table. We would like to include a "revenue" value to associate with these comp ticket totals, by summing up what the base price woudl have been if they were paid for. I understand this value appears in the "Season Overview report" that Tessitura generates.
Where would I find a "base price" value in the database described in a detailed enough way to associate that value with each comp ticket from the T_sub_lineitem table?
Hi Aaron,
The procedure RP_PERF_SALES_DATA has a cte that provides base price based on zone per performance. That should give you everything you need to calculate your revenue lost to comps. This procedure is the base of the Performance Revenue Gain-Loss report. I have comps in their own Price Type Category so I can get the revenue loss to comps from this report out of the box.
Dorothy