• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 24 views
  • Users 0 members are here
Related

Checking what the price of a seat was before a the price zone was changed

Sheila Collins
$organization

Hello Everyone,

We're trying to see (create a report) our gains/losses when changing the price zones of seats.  In other words, how much would it have sold for compared to what it did sell for.  I see in the t_order_seat_hist table the fact that it changed, where can I see what it was changed from/to, etc?  Thank you and Happy Friday.

Sheila

 

  • Former Member
    Former Member $organization

    Hi Sheila, 

    I would have said TX_PERF_SEAT_HIST but upon looking at this in our own database...it is totally blank! Maybe you will have more luck with this table. I think this is what you might be after if it has data in it.

    Tash 

  • $organization

    Ours is blank too, so I guess that table is not used.

     

    From: Natasha Purkiss [mailto:bounce-natashapurkiss5883@tessituranetwork.com]
    Sent: Friday, April 06, 2012 12:35 PM
    To: Sheila Crossman
    Subject: Re: [Tessitura Technical Forum] Checking what the price of a seat was before a the price zone was changed

     

    Hi Sheila, 

    I would have said TX_PERF_SEAT_HIST but upon looking at this in our own database...it is totally blank! Maybe you will have more luck with this table. I think this is what you might be after if it has data in it.

    Tash 

    From: Sheila Crossman <bounce-sheilacrossman3944@tessituranetwork.com>
    Sent: 4/6/2012 10:33:15 AM

    Hello Everyone,

    We're trying to see (create a report) our gains/losses when changing the price zones of seats.  In other words, how much would it have sold for compared to what it did sell for.  I see in the t_order_seat_hist table the fact that it changed, where can I see what it was changed from/to, etc?  Thank you and Happy Friday.

    Sheila

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!