T_order/T_lineitem question

What process updates the cancel_ind field in the t_order table? Also, what exactly does this indicator mean? Does it mean the order has been cancelled?

Second question; where is the reference table for the li_status field in T_lineitem table.

 

Thanks.

  • Matt,

    I was poking around in these tables a few days ago and couldn't figure this out either so I checked the documentation and found that both of these fields are obsolete and no longer used.

    Dale

  • T_ORDER.cancel_ind is only used by the Seat Cancellation process in Season Manager.  You would typically only see this used for subscription rollover orders that are cancelled (seats released) using this process.

     

    The li_status column on T_LINEITEM is obsolete and should not be used.

     

    A lot of similar information is available in the Tessitura Table Structures document.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Winchester
    Sent: Thursday, June 14, 2012 10:36 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] T_order/T_lineitem question

     

    What process updates the cancel_ind field in the t_order table? Also, what exactly does this indicator mean? Does it mean the order has been cancelled?

    Second question; where is the reference table for the li_status field in T_lineitem table.

     

    Thanks.




    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!

  • Thanks.

     

    Matt Winchester
    Database Administrator
    Dallas Symphony Orchestra
    Morton H. Meyerson Symphony Center
    Schlegel Administrative Suites
    2301 Flora Street
    Dallas, Texas 75201

    214-871-4028 - phone
    214-953-1218 - fax

    m.winchester@DalSym.com
    www.dallassymphony.com

    http://www.dallassymphony.com/media/112512/clip_image001.gif


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Dale Aucoin
    Sent: Thursday, June 14, 2012 9:55 AM
    To: Matt Winchester
    Subject: Re: [Tessitura Technical Forum] T_order/T_lineitem question

     

    Matt,

    I was poking around in these tables a few days ago and couldn't figure this out either so I checked the documentation and found that both of these fields are obsolete and no longer used.

    Dale

    From: Matt Winchester <bounce-matthewwinchester1652@tessituranetwork.com>
    Sent: 6/14/2012 9:25:45 AM

    What process updates the cancel_ind field in the t_order table? Also, what exactly does this indicator mean? Does it mean the order has been cancelled?

    Second question; where is the reference table for the li_status field in T_lineitem table.

     

    Thanks.




    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!

  • Thank you.

     

    Matt Winchester
    Database Administrator
    Dallas Symphony Orchestra
    Morton H. Meyerson Symphony Center
    Schlegel Administrative Suites
    2301 Flora Street
    Dallas, Texas 75201

    214-871-4028 - phone
    214-953-1218 - fax

    m.winchester@DalSym.com
    www.dallassymphony.com

    http://www.dallassymphony.com/media/112512/clip_image001.gif


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Creps
    Sent: Thursday, June 14, 2012 10:08 AM
    To: Matt Winchester
    Subject: RE: [Tessitura Technical Forum] T_order/T_lineitem question

     

    T_ORDER.cancel_ind is only used by the Seat Cancellation process in Season Manager.  You would typically only see this used for subscription rollover orders that are cancelled (seats released) using this process.

     

    The li_status column on T_LINEITEM is obsolete and should not be used.

     

    A lot of similar information is available in the Tessitura Table Structures document.

     

    +Ryan Creps

    +Tessitura Network

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Matt Winchester
    Sent: Thursday, June 14, 2012 10:36 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] T_order/T_lineitem question

     

    What process updates the cancel_ind field in the t_order table? Also, what exactly does this indicator mean? Does it mean the order has been cancelled?

    Second question; where is the reference table for the li_status field in T_lineitem table.

     

    Thanks.




    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!




    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!