Request for Data on Payments

Greetings All, we are deep into the infrastructure work for the Payment feature for v14 and looking for some usage data around controlled batches and gift certificates.  If you are willing to participate, please run the following SQL script on your test database and send the results (2 numeric values) to roadmap@tessituranetwork.com with a subject of Payment Data. 

Thank you in advance for your assistance.

Anna 

Select sum(CASE when p.pmt_amt > 0 then 1 else 0 end) as 'gift cert redemptions',

       sum(CASE when p.pmt_amt < 0 then 1 else 0 end) as 'gift cert sales'

From dbo.T_PAYMENT p (NOLOCK)

join dbo.T_BATCH b (NOLOCK) on p.batch_no = b.batch_no

join dbo.TR_BATCH_TYPE bt (NOLOCK) on b.batch_type = bt.id

join dbo.TR_PAYMENT_METHOD (NOLOCK) pm on p.pmt_method = pm.id

Where bt.cntl_ind = 'Y'

  and pm.pmt_type = 8

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!

Greetings All, we are deep into the infrastructure work for the Payment feature for v14 and looking for some usage data around controlled batches and gift certificates.  If you are willing to participate, please run the following SQL script on your test database and send the results (2 numeric values) to roadmap@tessituranetwork.com with a subject of Payment Data. 

Thank you in advance for your assistance.

Anna 

Select sum(CASE when p.pmt_amt > 0 then 1 else 0 end) as 'gift cert redemptions',

       sum(CASE when p.pmt_amt < 0 then 1 else 0 end) as 'gift cert sales'

From dbo.T_PAYMENT p (NOLOCK)

join dbo.T_BATCH b (NOLOCK) on p.batch_no = b.batch_no

join dbo.TR_BATCH_TYPE bt (NOLOCK) on b.batch_type = bt.id

join dbo.TR_PAYMENT_METHOD (NOLOCK) pm on p.pmt_method = pm.id

Where bt.cntl_ind = 'Y'

  and pm.pmt_type = 8

You were sent this message automatically by www.tessituranetwork.com because you subscribed to the Tessitura Next Generation forum email notifications. You may reply to this message or visit the site to reply to the post above. If replying via email, please consider deleting the previous message text before sending to help with readability on the site. Thank you!