Contact log

Hi,

I am currently looking into the information displayed on the contact log screen in Tessitura.  Please shed some light if you know that the information on this screen comes from which object/s.

 

Thanks for your time.

Harpreet

  • Hi Harpreet,

    Good day.

    it comes from AP_CUSTOMER_LOG, and also you can load your customized info through LP_CONTACT_LOG.

    have fun.

    Thank you for your time.

    Ben

     

     

  • Thanks Ben. So is this procedure runs everytime we click on contact log button or it stores the information in one table and displays it.

    Thanks

    Harpreet

     


    From: Tessitura Customer Service Forum [mailto:forums-cust.serv@tessituranetwork.com] On Behalf Of Ben Gu
    Sent: Monday, 14 September 2009 14:22
    To: Harpreet Gangyan
    Subject: Re: [Tessitura Customer Service Forum] Contact log

     

    Hi Harpreet,

    Good day.

    it comes from AP_CUSTOMER_LOG, and also you can load your customized info through LP_CONTACT_LOG.

    have fun.

    Thank you for your time.

    Ben

     

     

    From: Harpreet Gangyan <bounce-harpreetsinghgangyan5939@tessituranetwork.com>
    Sent: 9/13/2009 7:45:51 PM

    Hi,

    I am currently looking into the information displayed on the contact log screen in Tessitura.  Please shed some light if you know that the information on this screen comes from which object/s.

     

    Thanks for your time.

    Harpreet




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Customer Service Forum. You may reply to this message to post to the Customer Service 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 Harpreet,

    Good day.

    If you open SQL Profiler, it will record something like:

    execute dbo.AP_CUSTOMER_LOG   @customer_no = 54321

    So, yes, every time you click the tab, it will run this script.

    inside AP_CUSTOMER_LOG, it calls LP_CONTACT_LOG @customer_no = 54321 to show customized info,

    then it links

     T_CUST_ACTIVITY ,

    TX_APPEAL_MEDIA_TYPE/T_PROMOTION,

     TX_SOL_TASK

    T_Issue_Action

    T_TRANSACTION

    T_TCK_HIST

    T_ACK_EXT

    T_OPERA_LABEL

    T_NOTICE

    T_PLEDGE_BILL2

    VS_MSOFFICE_ITEM_LOG

    T_LOG_REPORT_EMAIL.

    have fun.

    Ben