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 

Parents
  • 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
    ________________________________________________________________________
Reply
  • 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
    ________________________________________________________________________
Children
No Data