• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 59 views
  • Users 0 members are here
Related

New Zones

Marty Jones
$organization

I think I know the answer to this, If we and new zones to a zone map, is there any procedures I need to run. I have a feeling the answer is no.

 

Thanks

Marty

Parents
  • $organization

    Another question, When I run these procedures, what table(s) are affected? Little concern with custom reporting on zones. I assume that I should pull zone_no from t_sub_lineItem instead of tx_perf_seat?

     

    Marty

     

  • $organization in reply to Marty Jones

    The “master” if you will, for orders is always T_SUB_LINEITEM.zone_no.

     

    You won’t be able to change the zone on a perf seat once it has been assigned to a ticket, so theoretically once an order is created, TX_PERF_SEAT and T_SUB_LINEITEM should be in sync for the relevant seat/perf/pkg.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marty Jones
    Sent: Tuesday, March 16, 2010 3:02 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] New Zones

     

    Another question, When I run these procedures, what table(s) are affected? Little concern with custom reporting on zones. I assume that I should pull zone_no from t_sub_lineItem instead of tx_perf_seat?

     

    Marty

     




    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!

Reply
  • $organization in reply to Marty Jones

    The “master” if you will, for orders is always T_SUB_LINEITEM.zone_no.

     

    You won’t be able to change the zone on a perf seat once it has been assigned to a ticket, so theoretically once an order is created, TX_PERF_SEAT and T_SUB_LINEITEM should be in sync for the relevant seat/perf/pkg.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Marty Jones
    Sent: Tuesday, March 16, 2010 3:02 PM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] New Zones

     

    Another question, When I run these procedures, what table(s) are affected? Little concern with custom reporting on zones. I assume that I should pull zone_no from t_sub_lineItem instead of tx_perf_seat?

     

    Marty

     




    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!

Children
No Data