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

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

Children
No Data