Where are fees stored prior to committing and order?

Hello,


We are trying to figure out what table holds the fees attached to an order before you click done.  To try and figure this out I've set up an order with a line item attached.  I can see the fee in the fee tab via the client, but when I look in the working tables the fee is nowhere to be found.  Does anyone know where the fee is stored at this stage?

 

Many thanks,
Rathi 

  • Rathi,

     

    Did you look at TM_SLI_FEE?

     

    Thanks,

    Bobby Moseley

    601 Preston

    Houston, TX 77002

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Rathi Kumar
    Sent: Wednesday, November 28, 2012 12:07 PM
    To: Moseley, Bobby
    Subject: [Tessitura Technical Forum] Where are fees stored prior to committing and order?

     

    Hello,


    We are trying to figure out what table holds the fees attached to an order before you click done.  To try and figure this out I've set up an order with a line item attached.  I can see the fee in the fee tab via the client, but when I look in the working tables the fee is nowhere to be found.  Does anyone know where the fee is stored at this stage?

     

    Many thanks,
    Rathi 




    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!

  • Hi Bobby,

    Yes, I have looked there and no luck.  I was reading through some of the comments in one of the procedures and I believe the mirror table is only used when loading an existing order, but I could be wrong.

    Thanks for the reply, though!

    Sent from my iPhone

    On 2012-11-28, at 19:36, "Bobby Moseley" <bounce-bobbymoseley3262@tessituranetwork.com> wrote:

    Rathi,

     

    Did you look at TM_SLI_FEE?

     

    Thanks,

    Bobby Moseley

    601 Preston

    Houston, TX 77002

     

    --
    Rathi Kumar | Business Systems Analyst | 020 7424 8463 | www.roundhouse.org.uk

    Each year the Roundhouse works with over 3,000 11-25s enabling them to realise their creative potential; and offers audiences of all ages new and extraordinary experiences in live music, circus, theatre and new media.


    Roundhouse Trust registered office: 100a Chalk Farm Road, London NW1 8EH. A company limited by guarantee. Registered in England and Wales. Company number 3572184. Charity number 1071487. This message is private and confidential. If you've received it in error, please notify us and remove it from your system.


    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Rathi Kumar
    Sent: Wednesday, November 28, 2012 12:07 PM
    To: Moseley, Bobby
    Subject: [Tessitura Technical Forum] Where are fees stored prior to committing and order?

     

    Hello,


    We are trying to figure out what table holds the fees attached to an order before you click done.  To try and figure this out I've set up an order with a line item attached.  I can see the fee in the fee tab via the client, but when I look in the working tables the fee is nowhere to be found.  Does anyone know where the fee is stored at this stage?

     

    Many thanks,
    Rathi 




    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 e-mail has been scanned for all viruses by Star Internet



    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 e-mail has been scanned for all viruses by Star Internet
    ________________________________________________________________________
  • In a non-controlled batch, the fees are not written to any table until the order is saved.  

  • That would explain it.  Thanks, Chuck.

    --
    Rathi Kumar | Business Systems Analyst | 020 7424 8463 | www.roundhouse.org.uk

    Each year the Roundhouse works with over 3,000 11-25s enabling them to realise their creative potential; and offers audiences of all ages new and extraordinary experiences in live music, circus, theatre and new media.


    Roundhouse Trust registered office: 100a Chalk Farm Road, London NW1 8EH. A company limited by guarantee. Registered in England and Wales. Company number 3572184. Charity number 1071487. This message is private and confidential. If you've received it in error, please notify us and remove it from your system.



    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Chuck Reif
    Sent: 28 November 2012 21:29
    To: Rathi Kumar
    Subject: Re: [Tessitura Technical Forum] Where are fees stored prior to committing and order?

    In a non-controlled batch, the fees are not written to any table until the order is saved.  

    From: Rathi Kumar <bounce-rathikumar7243@tessituranetwork.com>
    Sent: 11/28/2012 11:42:04 AM

    Hello,


    We are trying to figure out what table holds the fees attached to an order before you click done.  To try and figure this out I've set up an order with a line item attached.  I can see the fee in the fee tab via the client, but when I look in the working tables the fee is nowhere to be found.  Does anyone know where the fee is stored at this stage?

     

    Many thanks,
    Rathi 




    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 e-mail has been scanned for all viruses by Star Internet

    ________________________________________________________________________
    This e-mail has been scanned for all viruses by Star Internet
    ________________________________________________________________________