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.

Parents
  • 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!

Reply
  • 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!

Children
No Data