I can't find any reference to this in documentation. Can anyone tell me what logic populates T_PERF.sales_version?
I had never really noticed the column before, but in V12 testing, a user noted that the Ticket Sales by Period report will not run in Price Type Category mode if the report includes sales_version values < 12.
Looking at all of our T_PERF records, I can't find anything obvious for when this value gets populated. I seek enlightenment oh wise message board!
- Levi
Hi Levi,
I believe that the sales_version column is populated during data migration to indicate what version of Tess was used to set up the performance originally to indicate if you can continue to join on TX_PERF_PMAP
Hi Paul.
I thought that might have been the case, but when I look at the whole table it seems more random than that. The values populated in my Live environment (V11) only appear for a few shows while the majority of shows have a NULL. And it doesn't seem to be date dependent.