Hi ,
I am planning to add source channel to this report.
I jus want the data from tr_sales_channel to be linked to know whether its from phone room or telesales.
I don't want to add the source name,not from tx_appeal_media_type where I can get the source from(not neccesary).
Can this be possible.....
Kindly let me know your suggestionss....
Hi,
Did anyone get a chance to look at this...
Kindly let me know........
Hi, Did anyone get a chance to look at this... Kindly let me know........ From: Revanth Anne <bounce-revanthanne9441@tessituranetwork.com> Sent: 5/6/2009 5:32:55 PMHi , I am planning to add source channel to this report. I jus want the data from tr_sales_channel to be linked to know whether its from phone room or telesales. I don't want to add the source name,not from tx_appeal_media_type where I can get the source from(not neccesary). Can this be possible..... Kindly let me know your suggestionss.... 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!
From: Revanth Anne <bounce-revanthanne9441@tessituranetwork.com> Sent: 5/6/2009 5:32:55 PM
Hi Dan,
I am looking to add the source channel to on account tracking report.
but I can't see any tables which is connected to source channel tr_sales_channel.
Source Number in t_transaction or t_order is the source name from tx_appeal_media_type.
I am looking for a report that has feild post date,customer no,Name,source channel and amont on account.
Kindly ,let me know if this is clear.
will appreciate your help
If the payment was made through a contribution, the sales channel will come from T_CONTRIBUTION. If the payment was made through an order, the sales channel will come from T_ORDER.
Here’s a sample query that could be used to retrieve the payment amount and sales channel from Orders:
SELECT a.customer_no,
lname = MAX(o.lname),
pmt_method = pm.description,
channel = sc.description,
total_pmt = sum(a.pmt_amt) * (-1)
FROM [dbo].t_payment a (NOLOCK)
JOIN [dbo].T_TRANSACTION t on a.transaction_no = t.transaction_no and a.sequence_no = t.sequence_no
JOIN [dbo].TR_PAYMENT_METHOD pm on a.pmt_method = pm.id
JOIN [dbo].t_customer o (NOLOCK) on o.customer_no = a.customer_no
JOIN [dbo].T_ORDER d on t.order_no = d.order_no
JOIN [dbo].VRS_SALES_CHANNEL sc on d.channel = sc.id
WHERE a.pmt_dt <= '2009-01-01' -- Some date as your cutoff in a variable
and pm.pmt_type = 2
GROUP BY a.customer_no,
pm.description,
sc.description
______________________________________
Ryan Creps
Network Developer |Tessitura Network, Inc
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Revanth Anne Sent: Thursday, May 07, 2009 7:37 AM To: Ryan Creps Subject: Re: [Tessitura Technical Forum] ON ACCOUNT TRACKING REPORT
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!
No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.325 / Virus Database: 270.12.18/2096 - Release Date: 05/06/09 17:58:00
Thank you Ryan this helps.