Hi,
I am trying to write the code for a report that shows the current prices by seats unsold for any performance. I just can't find what table(s) is holding that data.
Can anyone give me a hint here?
Thanks for your help.
Gustavo
Hi Lucie and thanks for your reply,
We are in V12 and those tables are obsolete in that version and I am not sure what tables are replacing them.
Thanks again for your reply.
Hi, Gustavo:
I don’t know if this has changed (we’re still in v11), but T_SUBPRICE ties price, zone, and price map, and tx_perf_pmap ties performance to price type and price map for a date range.
Lucie
_____________________________________________
Lucie Spieler Florida Grand Opera
Hi Gustavo,
There's a function called FT_GET_PRICES with a date parameter and a bridge view called VXB_PERF_PMAP
You should be able to get prices for shows using those.
Caspian