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
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
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,
From: Harpreet Gangyan <bounce-harpreetsinghgangyan5939@tessituranetwork.com> Sent: 9/13/2009 7:45:51 PM
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!
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.
then it links
T_CUST_ACTIVITY , TX_APPEAL_MEDIA_TYPE/T_PROMOTION,
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.
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.
T_TRANSACTION T_TCK_HIST T_ACK_EXT T_OPERA_LABEL T_NOTICE T_PLEDGE_BILL2 VS_MSOFFICE_ITEM_LOG T_LOG_REPORT_EMAIL.
T_TCK_HIST T_ACK_EXT T_OPERA_LABEL T_NOTICE T_PLEDGE_BILL2 VS_MSOFFICE_ITEM_LOG T_LOG_REPORT_EMAIL.
T_ACK_EXT T_OPERA_LABEL T_NOTICE T_PLEDGE_BILL2 VS_MSOFFICE_ITEM_LOG T_LOG_REPORT_EMAIL.
T_OPERA_LABEL T_NOTICE T_PLEDGE_BILL2 VS_MSOFFICE_ITEM_LOG T_LOG_REPORT_EMAIL.
T_NOTICE T_PLEDGE_BILL2 VS_MSOFFICE_ITEM_LOG T_LOG_REPORT_EMAIL.
T_PLEDGE_BILL2 VS_MSOFFICE_ITEM_LOG T_LOG_REPORT_EMAIL.
VS_MSOFFICE_ITEM_LOG T_LOG_REPORT_EMAIL.
T_LOG_REPORT_EMAIL.